Regarding the error in Hive query

2012-01-03 Thread Bhavesh Shah
Hello, I am trying to implement join query in HIve but I am getting error. My query is: insert overwrite table t1 select subset.* from subset s JOIN testencounter t on (t.patient_mrn =s.patient_mrn and t.encounter_date<=s.encounter_date) where s.cad=0; I am getting error as: FAILED: Error in seman

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

2012-01-03 Thread Navis (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179279#comment-13179279 ] Navis commented on HIVE-2503: - @Carl: Yes, ready. > HiveServer should provide

[jira] [Commented] (HIVE-2573) Create per-session function registry

2012-01-03 Thread Navis (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179277#comment-13179277 ] Navis commented on HIVE-2573: - Has no test cases yet. I think HIVE-2503 should be resolved firs

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

2012-01-03 Thread jirapos...@reviews.apache.org (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179275#comment-13179275 ] jirapos...@reviews.apache.org commented on HIVE-2503: - ---

Re: Review Request: HIVE-2503: create per-session HiveConf instance

2012-01-03 Thread Navis Ryu
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/2820/ --- (Updated 2012-01-04 05:08:24.994913) Review request for hive and Carl Steinbach.

[jira] [Commented] (HIVE-2478) Support dry run option in hive

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

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

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

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

2012-01-03 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) > Implement sort(array) UDF > - >

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

2012-01-03 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) > Extend concat_ws() UDF to support arrays of strings > -

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

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

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

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

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

2012-01-03 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2279: -- Attachment: HIVE-2279.D1107.1.patch zhenxiao requested code review of "HIVE-2279 [jira] Implement sort(a

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

2012-01-03 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2279: -- Attachment: HIVE-2279.D1101.1.patch zhenxiao requested code review of "HIVE-2279 [jira] Implement sort(a

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

2012-01-03 Thread Carl Steinbach (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179213#comment-13179213 ] Carl Steinbach commented on HIVE-2503: -- @Navis: Is this ticket ready for a final revie

[jira] [Updated] (HIVE-2498) Group by operator doesnt estimate size of Timestamp & Binary data correctly

2012-01-03 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2498: - Status: Open (was: Patch Available) @Ashutosh: Please rebase the patch and submit a phabricator r

[jira] [Commented] (HIVE-2573) Create per-session function registry

2012-01-03 Thread Carl Steinbach (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179212#comment-13179212 ] Carl Steinbach commented on HIVE-2573: -- @Navis: Is this ready for a final review?

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

2012-01-03 Thread Carl Steinbach (Created) (JIRA)
Specify location of log4j configuration files via configuration properties -- Key: HIVE-2691 URL: https://issues.apache.org/jira/browse/HIVE-2691 Project: Hive Issue Typ

[jira] [Commented] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

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

[jira] [Resolved] (HIVE-1530) Include hive-default.xml and hive-log4j.properties in hive-common JAR

2012-01-03 Thread Carl Steinbach (Resolved) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-1530. -- Resolution: Invalid Resolving as INVALID since hive-default.xml no longer exists.

[jira] [Commented] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13179142#comment-13179142 ] He Yongqiang commented on HIVE-2690: https://reviews.facebook.net/D1095

[jira] [Updated] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2690: -- Attachment: HIVE-2690.D1095.1.patch heyongqiang requested code review of "HIVE-2690 [jira] a bug in 'alt

[jira] [Updated] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-2690: --- Status: Patch Available (was: Open) > a bug in 'alter table concatenate' that causes filenames ge

[jira] [Updated] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-2690: --- Attachment: HIVE-2690.1.patch > a bug in 'alter table concatenate' that causes filenames getting d

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

2012-01-03 Thread Apache Jenkins Server
Changes for Build #1144 [jvs] HIVE-1040 [jira] use sed rather than diff for masking out noise in diff-based tests (Marek Sapota via John Sichi) Summary: Replace diff -I with regex masking in Java The current diff -I approach has two problems: (1) it does not allow resolution finer than line-lev

[jira] [Updated] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-2690: --- Attachment: (was: HIVE-2690.1.patch) > a bug in 'alter table concatenate' that causes filename

[jira] [Commented] (HIVE-2621) Allow multiple group bys with the same input data and spray keys to be run on the same reducer.

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

[jira] [Updated] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-2690: --- Attachment: HIVE-2690.1.patch > a bug in 'alter table concatenate' that causes filenames getting d

[jira] [Created] (HIVE-2690) a bug in 'alter table concatenate' that causes filenames getting double url encoded

2012-01-03 Thread He Yongqiang (Created) (JIRA)
a bug in 'alter table concatenate' that causes filenames getting double url encoded --- Key: HIVE-2690 URL: https://issues.apache.org/jira/browse/HIVE-2690 Project: Hive

Hive-trunk-h0.21 - Build # 1181 - Failure

2012-01-03 Thread Apache Jenkins Server
Changes for Build #1144 [jvs] HIVE-1040 [jira] use sed rather than diff for masking out noise in diff-based tests (Marek Sapota via John Sichi) Summary: Replace diff -I with regex masking in Java The current diff -I approach has two problems: (1) it does not allow resolution finer than line-lev

[jira] [Commented] (HIVE-2478) Support dry run option in hive

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

[jira] [Commented] (HIVE-2478) Support dry run option in hive

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

[jira] [Updated] (HIVE-2621) Allow multiple group bys with the same input data and spray keys to be run on the same reducer.

2012-01-03 Thread He Yongqiang (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-2621: --- Resolution: Fixed Status: Resolved (was: Patch Available) committed, thanks Kevin!