[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-tabpanelfocusedCommentId=13186775#comment-13186775 ] Hudson commented on HIVE-2629: -- Integrated in Hive-trunk-h0.21-dbg #3 (See

[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-tabpanelfocusedCommentId=13186779#comment-13186779 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #3 (See

[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-tabpanelfocusedCommentId=13186776#comment-13186776 ] Hudson commented on HIVE-2504: -- Integrated in Hive-trunk-h0.21-dbg #3 (See

[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-tabpanelfocusedCommentId=13186778#comment-13186778 ] Hudson commented on HIVE-2695: -- Integrated in Hive-trunk-h0.21-dbg #3 (See

[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-tabpanelfocusedCommentId=13186777#comment-13186777 ] Hudson commented on HIVE-2682: -- Integrated in Hive-trunk-h0.21-dbg #3 (See

[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

[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

[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

[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-tabpanelfocusedCommentId=13186824#comment-13186824 ] Phabricator commented on HIVE-2203: --- cwsteinbach has accepted the revision HIVE-2203

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'; HiveCREATE EXTERNAL TABLE student_score(studentid INT, classid INT,score

[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-tabpanelfocusedCommentId=13186848#comment-13186848 ] Phabricator commented on HIVE-2694: --- cwsteinbach has requested changes to the revision

[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-tabpanelfocusedCommentId=13186862#comment-13186862 ] Phabricator commented on HIVE-2691: --- cwsteinbach has requested changes to the revision

[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-tabpanelfocusedCommentId=13186895#comment-13186895 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #4 (See

[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-tabpanelfocusedCommentId=13187020#comment-13187020 ] Hudson commented on HIVE-2682: -- Integrated in Hive-trunk-h0.21-dbg #5 (See

[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-tabpanelfocusedCommentId=13187021#comment-13187021 ] Hudson commented on HIVE-2705: -- Integrated in Hive-trunk-h0.21-dbg #5 (See

[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-tabpanelfocusedCommentId=13187022#comment-13187022 ] Hudson commented on HIVE-2589: -- Integrated in Hive-trunk-h0.21-dbg #5 (See

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 file. Initially, hive ran the command with 256mb heap size and gave me an OOM error. I increased the heap size using export

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 'myfile' 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

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

[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-tabpanelfocusedCommentId=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:

[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-tabpanelfocusedCommentId=13187253#comment-13187253 ] Phabricator commented on HIVE-2656: --- jsichi has commented on the revision HIVE-2656

[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

[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.

[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:

[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-tabpanelfocusedCommentId=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

[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

[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

[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

[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

[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-tabpanelfocusedCommentId=13187398#comment-13187398 ] caofangkun commented on HIVE-2722: -- hive -e SELECT instr('ab中国c字d', '国') from dual limit 1

[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-tabpanelfocusedCommentId=13187507#comment-13187507 ] Phabricator commented on HIVE-2656: --- jonchang has commented on the revision HIVE-2656