[jira] [Created] (HIVE-2806) 'The database has reported an Exception: Query returned non-zero code: 9; cause: FAILED' - Queries that have 'JOIN' on tables that have huge data result in this exception

2012-02-15 Thread Archit Garg (Created) (JIRA)
'The database has reported an Exception: Query returned non-zero code: 9; cause: FAILED' - Queries that have 'JOIN' on tables that have huge data result in this exception --

[jira] [Updated] (HIVE-2503) HiveServer should provide per session configuration

2012-02-15 Thread Navis (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2503: Status: Patch Available (was: Open) > HiveServer should provide per session configuration > ---

[jira] [Updated] (HIVE-2261) Add cleanup stages for UDFs

2012-02-15 Thread Navis (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2261: Fix Version/s: 0.9.0 Affects Version/s: 0.9.0 Status: Patch Available (was: Open) > Add

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209172#comment-13209172 ] Phabricator commented on HIVE-2782: --- cwsteinbach has committed the revision "HIVE-2782 [j

[jira] [Commented] (HIVE-2769) union with a multi-table insert is not working

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209174#comment-13209174 ] Phabricator commented on HIVE-2769: --- heyongqiang has committed the revision "HIVE-2769 [j

[jira] [Commented] (HIVE-2793) Disable loadpart_err.q on 0.23

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209170#comment-13209170 ] Phabricator commented on HIVE-2793: --- cwsteinbach has committed the revision "HIVE-2793 [j

[jira] [Commented] (HIVE-2753) Remove empty java files

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209158#comment-13209158 ] Phabricator commented on HIVE-2753: --- omalley has committed the revision "HIVE-2753 [jira]

[jira] [Commented] (HIVE-2662) Add Ant configuration property for dumping classpath of tests

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209161#comment-13209161 ] Phabricator commented on HIVE-2662: --- cwsteinbach has committed the revision "HIVE-2662 [j

[jira] [Commented] (HIVE-2772) make union31.q deterministic

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209157#comment-13209157 ] Phabricator commented on HIVE-2772: --- heyongqiang has committed the revision "HIVE-2772 [j

[jira] [Commented] (HIVE-2760) TestCliDriver should log elapsed time

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209156#comment-13209156 ] Phabricator commented on HIVE-2760: --- cwsteinbach has committed the revision "HIVE-2760 [j

[jira] [Updated] (HIVE-2261) Add cleanup stages for UDFs

2012-02-15 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2261: -- Attachment: HIVE-2261.D1329.2.patch navis updated the revision "HIVE-2261 [jira] Add cleanup stages for

Hive-trunk-h0.21 - Build # 1261 - Fixed

2012-02-15 Thread Apache Jenkins Server
Changes for Build #1220 [namit] HIVE-2727 add a testcase for partitioned view on union and base tables have index (He Yongqiang via namit) Changes for Build #1221 [hashutosh] HIVE-2746 : Metastore client doesn't log properly in case of connection failure to server (hashutosh) [cws] HIVE-2698 [

Re: Running hive in eclipse

2012-02-15 Thread Ashish Sharma
Hello there , https://issues.apache.org/jira/browse/HIVE-2673, this might be helpful. On Thu, Feb 16, 2012 at 1:22 AM, Aaron Sun wrote: > Hi Team, > > I am trying to run and debug hive in eclipse. I checked out release-0.8.0 > 1215012 from the SVN repository and built the project with thrift

[jira] [Updated] (HIVE-2805) Move metastore upgrade scripts labeled 0.10.0 into scripts labeled 0.9.0

2012-02-15 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2805: -- Attachment: HIVE-2805.D1743.1.patch kevinwilfong requested code review of "HIVE-2805 [jira] Move metasto

Potential change to metastore Thrift APIs

2012-02-15 Thread Kevin Wilfong
This is regarding https://issues.apache.org/jira/browse/HIVE-2799 I am working on adding a new string parameter to most metastore RPCs which either create, get, or drop a table, partition, or index. This can either be done by 1. adding the parameter to the existing RPCs and modifying Hive

[jira] [Updated] (HIVE-2796) Support auto completion for hive configs in CliDriver

2012-02-15 Thread Navis (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2796: Fix Version/s: 0.9.0 Affects Version/s: 0.9.0 Status: Patch Available (was: Open) > Supp

[jira] [Assigned] (HIVE-2796) Support auto completion for hive configs in CliDriver

2012-02-15 Thread Ashutosh Chauhan (Assigned) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-2796: -- Assignee: Navis If its ready for review, feel free to change status to "Patch Available"

[jira] [Commented] (HIVE-2797) Make the IP address of a Thrift client available to HMSHandler.

2012-02-15 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209026#comment-13209026 ] Phabricator commented on HIVE-2797: --- ashutoshc has commented on the revision "HIVE-2797 [

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209016#comment-13209016 ] Kevin Wilfong commented on HIVE-2799: - I'm definitely in favor of that approach. The p

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209013#comment-13209013 ] Ashutosh Chauhan commented on HIVE-2799: For that we can modify HiveMetaStoreClient

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208997#comment-13208997 ] Kevin Wilfong commented on HIVE-2799: - @Ashutosh I agree, that will work as well. I m

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208988#comment-13208988 ] Ashutosh Chauhan commented on HIVE-2799: In case client is upgraded but server is n

[jira] [Commented] (HIVE-2805) Move metastore upgrade scripts labeled 0.10.0 into scripts labeled 0.9.0

2012-02-15 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208980#comment-13208980 ] Kevin Wilfong commented on HIVE-2805: - See https://issues.apache.org/jira/browse/HIVE-2

[jira] [Created] (HIVE-2805) Move metastore upgrade scripts labeled 0.10.0 into scripts labeled 0.9.0

2012-02-15 Thread Kevin Wilfong (Created) (JIRA)
Move metastore upgrade scripts labeled 0.10.0 into scripts labeled 0.9.0 Key: HIVE-2805 URL: https://issues.apache.org/jira/browse/HIVE-2805 Project: Hive Issue Type: T

[jira] [Commented] (HIVE-2612) support hive table/partitions exists in more than one region

2012-02-15 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208978#comment-13208978 ] Kevin Wilfong commented on HIVE-2612: - @Ashutosh I'm sorry about that, there already w

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208972#comment-13208972 ] Kevin Wilfong commented on HIVE-2799: - I was under the impression that that's true in t

[jira] [Commented] (HIVE-2612) support hive table/partitions exists in more than one region

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208958#comment-13208958 ] Ashutosh Chauhan commented on HIVE-2612: @Kevin, You named the script upgrade-0.9.

[jira] [Commented] (HIVE-2801) When join key is null, random distribute this tuple

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208953#comment-13208953 ] Ashutosh Chauhan commented on HIVE-2801: I didn't get the context. Can you expand a

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208945#comment-13208945 ] Ashutosh Chauhan commented on HIVE-2799: My understanding of thrift is limited. But

[jira] [Commented] (HIVE-1054) "CHANGE COLUMN" does not support changing partition column types.

2012-02-15 Thread Ashutosh Chauhan (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208940#comment-13208940 ] Ashutosh Chauhan commented on HIVE-1054: I think problem there is what will happen

Hive-0.8.1-SNAPSHOT-h0.21 - Build # 195 - Fixed

2012-02-15 Thread Apache Jenkins Server
Changes for Build #194 Changes for Build #195 All tests passed The Apache Jenkins build system has built Hive-0.8.1-SNAPSHOT-h0.21 (build #195) Status: Fixed Check console output at https://builds.apache.org/job/Hive-0.8.1-SNAPSHOT-h0.21/195/ to view the results.

Re: Running hive in eclipse

2012-02-15 Thread Alexis De La Cruz Toledo
I has the same problem. Can anyone help us? El 15 de febrero de 2012 13:52, Aaron Sun escribió: > Hi Team, > > I am trying to run and debug hive in eclipse. I checked out release-0.8.0 > 1215012 from the SVN repository and built the project with thrift and fb303 > library installed correctly. Th

Hive-trunk-h0.21 - Build # 1260 - Still Failing

2012-02-15 Thread Apache Jenkins Server
Changes for Build #1218 Changes for Build #1219 [hashutosh] HIVE-2665 : Support for metastore service specific HADOOP_OPTS environment setting (thw via hashutosh) Changes for Build #1220 [namit] HIVE-2727 add a testcase for partitioned view on union and base tables have index (He Yongqiang via

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

2012-02-15 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208493#comment-13208493 ] Hudson commented on HIVE-2782: -- Integrated in Hive-trunk-h0.21 #1259 (See [https://builds.apa

[jira] [Commented] (HIVE-2793) Disable loadpart_err.q on 0.23

2012-02-15 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13208494#comment-13208494 ] Hudson commented on HIVE-2793: -- Integrated in Hive-trunk-h0.21 #1259 (See [https://builds.apa

Hive-trunk-h0.21 - Build # 1259 - Still Failing

2012-02-15 Thread Apache Jenkins Server
Changes for Build #1218 Changes for Build #1219 [hashutosh] HIVE-2665 : Support for metastore service specific HADOOP_OPTS environment setting (thw via hashutosh) Changes for Build #1220 [namit] HIVE-2727 add a testcase for partitioned view on union and base tables have index (He Yongqiang via

Re: Doubt in INSERT query in Hive?

2012-02-15 Thread bejoy_ks
Hi Bhavesh INSERT INTO is supported in hive 0.8 . An upgrade would get you things rolling. LOAD DATA inefficient? What was the performance overhead you were facing here? Regards Bejoy K S From handheld, Please excuse typos. -Original Message- From: Bhavesh Shah Date: Wed, 15 Fe

Doubt in INSERT query in Hive?

2012-02-15 Thread Bhavesh Shah
Hello, Whenever we want to insert into table we use: INSERT OVERWRITE TABLE TBL_NAME (SELECT ) Due to this, table gets overwrites everytime. I don't want to overwrite table, I want append it everytime. I thought about LOAD TABLE , but writing the file may take more time and I don't think so th