Re: A bug of auto convert join with intermediate table?

2013-02-06 Thread Zhong Wang
Hello Abdelrhman, I am using the Hive version 0.8.1 which includes this fixing. I think this is an integer overflow bug of ConditionalResolverCommonJoin's inner class AliasFileSizePair. The compareTo() method may overflow: public int compareTo(AliasFileSizePair o) { if (o == null) {

Re: A bug of auto convert join with intermediate table?

2013-02-06 Thread Abdelrhman Shettia
Hi Zhong, It is possible that you are facing the following hive bug? You may want to upgrade the current hive client. https://issues.apache.org/jira/browse/HIVE-2095 Thanks -Abdelrhman Hortonworks, Inc. Technical Support Engineer Abdelrahman Shettia ashet...@hortonworks.com Office phone

Re: hive alter partition error

2013-02-06 Thread Abdelrhman Shettia
Hi All, When creating a hive partition it is actually creating a dir under the table name which will be called the partition name. It needs to have the right permissions to create this dir. In this case, Creating the partition with the user web_front will work. Thanks Hortonworks, Inc. Te

RE: Getting Error while executing "show partitions TABLE_NAME"

2013-02-06 Thread Venkatesh Kavuluri
Looks like it's memory/ disk space issue with your database server used to store Hive metadata. Can you check the disk usage of /tmp directory (data directory of DB server). Date: Wed, 6 Feb 2013 18:34:31 +0530 Subject: Getting Error while executing "show partitions TABLE_NAME" From: chunky.gu..

Getting Error while executing "show partitions TABLE_NAME"

2013-02-06 Thread Chunky Gupta
Hi All, I ran this :- hive> show partitions tab_name; and got this error :- FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT `THIS`.`PART_NAME` AS NUCORDER0 FROM `PARTITIONS` `THIS` LEFT OUTER JOIN `TBLS` `THIS_TABLE_DATABASE` ON `THIS`.`TBL_ID` = `

RE: Hive JDBC driver query statement timeout.

2013-02-06 Thread Bennie Schut
Normally that would be stmt.setQueryTimout however that call isn't implemented yet. So to answer, no there isn't. public void setQueryTimeout(int seconds) throws SQLException { throw new SQLException("Method not supported"); } You might find a parameter called "hive.stats.jdbc.timeout" b