[jira] [Commented] (HIVE-2629) Make a single Hive binary work with both 0.20.x and 0.23.0

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186775#comment-13186775 ] Hudson commented on HIVE-2629: -- Integrated in Hive-trunk-h0.21-dbg #3 (See [https://builds.ap

[jira] [Commented] (HIVE-2589) Newly created partition should inherit properties from table

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186779#comment-13186779 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #3 (See [https://builds.ap

[jira] [Commented] (HIVE-2504) Warehouse table subdirectories should inherit the group permissions of the warehouse parent directory

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186776#comment-13186776 ] Hudson commented on HIVE-2504: -- Integrated in Hive-trunk-h0.21-dbg #3 (See [https://builds.ap

[jira] [Commented] (HIVE-2695) Add PRINTF() Udf

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186778#comment-13186778 ] Hudson commented on HIVE-2695: -- Integrated in Hive-trunk-h0.21-dbg #3 (See [https://builds.ap

[jira] [Commented] (HIVE-2682) Clean-up logs

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186777#comment-13186777 ] Hudson commented on HIVE-2682: -- Integrated in Hive-trunk-h0.21-dbg #3 (See [https://builds.ap

[jira] [Assigned] (HIVE-2673) Eclipse launch configurations fail due to unsatisfied builtins JAR dependency

2012-01-16 Thread Carl Steinbach (Assigned) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach reassigned HIVE-2673: Assignee: Carl Steinbach (was: John Sichi) > Eclipse launch configurations fail due to

[jira] [Updated] (HIVE-2673) Eclipse launch configurations fail due to unsatisfied builtins JAR dependency

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2673: - Status: Patch Available (was: Open) > Eclipse launch configurations fail due to unsatisfied b

[jira] [Updated] (HIVE-2673) Eclipse launch configurations fail due to unsatisfied builtins JAR dependency

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2673: - Attachment: HIVE-2673.1.patch.txt > Eclipse launch configurations fail due to unsatisfied buil

[jira] [Updated] (HIVE-2279) Implement sort(array) UDF

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2279: - Status: Open (was: Patch Available) @Zhenxiao: Please attach a copy of your patch (D1143) and cli

[jira] [Updated] (HIVE-2203) Extend concat_ws() UDF to support arrays of strings

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2203: - Status: Open (was: Patch Available) @Zhenxiao: Please attach a copy of the patch (D1137) and give

[jira] [Commented] (HIVE-2203) Extend concat_ws() UDF to support arrays of strings

2012-01-16 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186824#comment-13186824 ] Phabricator commented on HIVE-2203: --- cwsteinbach has accepted the revision "HIVE-2203 [ji

Hive JOIN fails if SELECT statement contains fields from the first table.

2012-01-16 Thread Bing Li
1. I create two Hive table: Hive> CREATE EXTERNAL TABLE student_details (studentid INT,studentname STRING,age INT,gpa FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION ‘/home/biadmin/hivetbl'; Hive>CREATE EXTERNAL TABLE student_score(studentid INT, classid INT,scor

[jira] [Updated] (HIVE-2694) Add FORMAT UDF

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2694: - Status: Open (was: Patch Available) > Add FORMAT UDF > -- > > Key

[jira] [Commented] (HIVE-2694) Add FORMAT UDF

2012-01-16 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186848#comment-13186848 ] Phabricator commented on HIVE-2694: --- cwsteinbach has requested changes to the revision "H

[jira] [Commented] (HIVE-2691) Specify location of log4j configuration files via configuration properties

2012-01-16 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186862#comment-13186862 ] Phabricator commented on HIVE-2691: --- cwsteinbach has requested changes to the revision "H

[jira] [Commented] (HIVE-2589) Newly created partition should inherit properties from table

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13186895#comment-13186895 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #4 (See [https://builds.ap

[jira] [Commented] (HIVE-2629) Make a single Hive binary work with both 0.20.x and 0.23.0

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187019#comment-13187019 ] Hudson commented on HIVE-2629: -- Integrated in Hive-trunk-h0.21-dbg #5 (See [https://builds.ap

[jira] [Commented] (HIVE-2682) Clean-up logs

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187020#comment-13187020 ] Hudson commented on HIVE-2682: -- Integrated in Hive-trunk-h0.21-dbg #5 (See [https://builds.ap

[jira] [Commented] (HIVE-2705) SemanticAnalyzer twice swallows an exception it shouldn't

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187021#comment-13187021 ] Hudson commented on HIVE-2705: -- Integrated in Hive-trunk-h0.21-dbg #5 (See [https://builds.ap

[jira] [Commented] (HIVE-2589) Newly created partition should inherit properties from table

2012-01-16 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187022#comment-13187022 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #5 (See [https://builds.ap

large sql file creating large num of columns

2012-01-16 Thread ameet chaubal
Hi All, I have a SQL file of size 30mb which is a single create table statement with about 800,000 columns, hence the size. I am trying to execute it using hive -f . Initially, hive ran the command with 256mb heap size and gave me an OOM error. I increased the heap size using export HADOOP_H

Re: large sql file creating large num of columns

2012-01-16 Thread ameet chaubal
thanks, Running it with debug, it spews the following, stored as textfile location '' 12/01/16 11:28:54 INFO parse.ParseDriver: Parse Completed 12/01/16 11:28:54 INFO parse.SemanticAnalyzer: Starting Semantic Analysis 12/01/16 11:28:54 INFO parse.SemanticAnalyzer: Creating table my_table position

Re: Hive JOIN fails if SELECT statement contains fields from the first table.

2012-01-16 Thread Mark Grover
Hi Bing, Something seems wrong about your create table statements. You are using "LOAD DATA LOCAL INPATH" to load data into Hive tables. This makes me think that the files /home/biadmin/hivetbl/student_details.txt and /home/biadmin/hivetbl/student_score.txt are on the local drive. In such a case

[jira] [Updated] (HIVE-2279) Implement sort(array) UDF

2012-01-16 Thread Zhenxiao Luo (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2279: --- Attachment: HIVE-2279.D1143.1.patch > Implement sort(array) UDF > - > >

[jira] [Updated] (HIVE-2279) Implement sort(array) UDF

2012-01-16 Thread Zhenxiao Luo (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2279: --- Status: Patch Available (was: Open) > Implement sort(array) UDF > - > >

[jira] [Updated] (HIVE-2203) Extend concat_ws() UDF to support arrays of strings

2012-01-16 Thread Zhenxiao Luo (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2203: --- Status: Patch Available (was: Open) > Extend concat_ws() UDF to support arrays of strings > -

[jira] [Updated] (HIVE-2203) Extend concat_ws() UDF to support arrays of strings

2012-01-16 Thread Zhenxiao Luo (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2203: --- Attachment: HIVE-2203.D1137.1.patch > Extend concat_ws() UDF to support arrays of strings > --

[jira] [Updated] (HIVE-2719) Fix test failures caused by HIVE-2589

2012-01-16 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2719: - Summary: Fix test failures caused by HIVE-2589 (was: Fix test failures caused by HIVE-2589 or HIV

[jira] [Commented] (HIVE-2719) Fix test failures caused by HIVE-2589

2012-01-16 Thread Carl Steinbach (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187082#comment-13187082 ] Carl Steinbach commented on HIVE-2719: -- I was also able to reproduce the test failures

Hive-0.8.1-SNAPSHOT-h0.21 - Build # 163 - Failure

2012-01-16 Thread Apache Jenkins Server
Changes for Build #163 1 tests failed. REGRESSION: org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_script_broken_pipe1 Error Message: Unexpected exception See build/ql/tmp/hive.log, or try "ant test ... -Dtest.silent=false" to get more logs. Stack Trace: junit.framewo

[jira] [Updated] (HIVE-2691) Specify location of log4j configuration files via configuration properties

2012-01-16 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2691: -- Attachment: HIVE-2691.D1203.6.patch zhenxiao updated the revision "HIVE-2691 [jira] Specify location of

[jira] [Commented] (HIVE-2656) Add a command line flag to specify a jar whence to load UDFs

2012-01-16 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187253#comment-13187253 ] Phabricator commented on HIVE-2656: --- jsichi has commented on the revision "HIVE-2656 [jir

[jira] [Created] (HIVE-2720) Merge MetaStoreListener and HiveMetaHook interfaces

2012-01-16 Thread Enis Soztutar (Created) (JIRA)
Merge MetaStoreListener and HiveMetaHook interfaces --- Key: HIVE-2720 URL: https://issues.apache.org/jira/browse/HIVE-2720 Project: Hive Issue Type: Sub-task Reporter: Enis Soztuta

[jira] [Updated] (HIVE-2694) Add FORMAT UDF

2012-01-16 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2694: -- Attachment: HIVE-2694.D1149.2.patch zhenxiao updated the revision "HIVE-2694 [jira] Add FORMAT UDF". Rev

[jira] [Updated] (HIVE-2694) Add FORMAT UDF

2012-01-16 Thread Zhenxiao Luo (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2694: --- Status: Patch Available (was: Open) > Add FORMAT UDF > -- > > Key: HI

[jira] [Commented] (HIVE-2720) Merge MetaStoreListener and HiveMetaHook interfaces

2012-01-16 Thread Enis Soztutar (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187362#comment-13187362 ] Enis Soztutar commented on HIVE-2720: - MetaStoreListener.onXXX() methods take an Event

[jira] [Created] (HIVE-2721) ability to select a view qualified by the database / schema name

2012-01-16 Thread Robert Morton (Created) (JIRA)
ability to select a view qualified by the database / schema name Key: HIVE-2721 URL: https://issues.apache.org/jira/browse/HIVE-2721 Project: Hive Issue Type: Bug Com

[jira] [Created] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Created) (JIRA)
GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better Key: HIVE-2722 URL: https://issues.apache.org/jira/browse/HIVE-2722 Project: Hive Issue

[jira] [Updated] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-2722: - Attachment: HIVE-2722.patch use CharBuffer > GenericUDFUtils.findText use CharBuffer othe

[jira] [Updated] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-2722: - Attachment: udf_instr_1.q > GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be bett

[jira] [Updated] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-2722: - Release Note: change ByteBuffer to CharBuffer in GenericUDFUtil.findText Hadoop Flags: Reviewed

[jira] [Updated] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-2722: - Resolution: Fixed Status: Resolved (was: Patch Available) > GenericUDFUtils.findText use Char

[jira] [Commented] (HIVE-2722) GenericUDFUtils.findText use CharBuffer other than ByteBuffer will be better

2012-01-16 Thread caofangkun (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187398#comment-13187398 ] caofangkun commented on HIVE-2722: -- hive -e "SELECT instr('ab中国c字d', '国') from dual limit

[jira] [Created] (HIVE-2723) should throw "Ambiguous column reference key" Exception in particular join condition

2012-01-16 Thread caofangkun (Created) (JIRA)
should throw "Ambiguous column reference key" Exception in particular join condition -- Key: HIVE-2723 URL: https://issues.apache.org/jira/browse/HIVE-2723 Project:

[jira] [Updated] (HIVE-2723) should throw "Ambiguous column reference key" Exception in particular join condition

2012-01-16 Thread caofangkun (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-2723: - Description: This Bug can be Repeated as following : create table test(key string, value string); create

[jira] [Commented] (HIVE-2656) Add a command line flag to specify a jar whence to load UDFs

2012-01-16 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13187507#comment-13187507 ] Phabricator commented on HIVE-2656: --- jonchang has commented on the revision "HIVE-2656 [j