[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15400892#comment-15400892 ] Carter Shanklin commented on HIVE-11600: It would be good to get this documented without waiting for the followup work. I spent 10 minutes or so figuring this out because of HIVE-14393 > Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) > > > Key: HIVE-11600 > URL: https://issues.apache.org/jira/browse/HIVE-11600 > Project: Hive > Issue Type: New Feature >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Fix For: 2.0.0 > > Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, > HIVE-11600.03.patch, HIVE-11600.04.patch, HIVE-11600.05.patch > > > Current hive only support single column in clause, e.g., > {code}select * from src where col0 in (v1,v2,v3);{code} > We want it to support > {code}select * from src where (col0,col1+3) in > ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14731829#comment-14731829 ] Lefty Leverenz commented on HIVE-11600: --- Doc note: Should documentation for this wait until HIVE-11738 is done? Version: I'm putting 2.0.0 in Fixed Version/s, so if that's wrong please change it. > Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) > > > Key: HIVE-11600 > URL: https://issues.apache.org/jira/browse/HIVE-11600 > Project: Hive > Issue Type: New Feature >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, > HIVE-11600.03.patch, HIVE-11600.04.patch, HIVE-11600.05.patch > > > Current hive only support single column in clause, e.g., > {code}select * from src where col0 in (v1,v2,v3);{code} > We want it to support > {code}select * from src where (col0,col1+3) in > ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14731079#comment-14731079 ] Pengcheng Xiong commented on HIVE-11600: Based on the review comments, pushed it to master. Thanks for [~jpullokkaran]'s review. > Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) > > > Key: HIVE-11600 > URL: https://issues.apache.org/jira/browse/HIVE-11600 > Project: Hive > Issue Type: New Feature >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, > HIVE-11600.03.patch, HIVE-11600.04.patch, HIVE-11600.05.patch > > > Current hive only support single column in clause, e.g., > {code}select * from src where col0 in (v1,v2,v3);{code} > We want it to support > {code}select * from src where (col0,col1+3) in > ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14725723#comment-14725723 ] Pengcheng Xiong commented on HIVE-11600: The test case failures are unrelated and they passed on my laptop. [~jpullokkaran], could you please take a look? Thanks. > Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) > > > Key: HIVE-11600 > URL: https://issues.apache.org/jira/browse/HIVE-11600 > Project: Hive > Issue Type: New Feature >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, > HIVE-11600.03.patch, HIVE-11600.04.patch, HIVE-11600.05.patch > > > Current hive only support single column in clause, e.g., > {code}select * from src where col0 in (v1,v2,v3);{code} > We want it to support > {code}select * from src where (col0,col1+3) in > ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14725675#comment-14725675 ] Hive QA commented on HIVE-11600: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12753422/HIVE-11600.05.patch {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 9390 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1 org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5135/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5135/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5135/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12753422 - PreCommit-HIVE-TRUNK-Build > Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) > > > Key: HIVE-11600 > URL: https://issues.apache.org/jira/browse/HIVE-11600 > Project: Hive > Issue Type: New Feature >Reporter: Pengcheng Xiong >Assignee: Pengcheng Xiong > Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, > HIVE-11600.03.patch, HIVE-11600.04.patch, HIVE-11600.05.patch > > > Current hive only support single column in clause, e.g., > {code}select * from src where col0 in (v1,v2,v3);{code} > We want it to support > {code}select * from src where (col0,col1+3) in > ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14707797#comment-14707797 ] Hive QA commented on HIVE-11600: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12751804/HIVE-11600.04.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 9381 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_schemeAuthority {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5039/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5039/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5039/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12751804 - PreCommit-HIVE-TRUNK-Build Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) Key: HIVE-11600 URL: https://issues.apache.org/jira/browse/HIVE-11600 Project: Hive Issue Type: New Feature Reporter: Pengcheng Xiong Assignee: Pengcheng Xiong Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, HIVE-11600.03.patch, HIVE-11600.04.patch Current hive only support single column in clause, e.g., {code}select * from src where col0 in (v1,v2,v3);{code} We want it to support {code}select * from src where (col0,col1+3) in ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14706369#comment-14706369 ] Hive QA commented on HIVE-11600: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12751613/HIVE-11600.03.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 9369 tests executed *Failed tests:* {noformat} TestSSL - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_char_udf1 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_varchar_udf1 {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5028/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5028/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5028/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12751613 - PreCommit-HIVE-TRUNK-Build Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) Key: HIVE-11600 URL: https://issues.apache.org/jira/browse/HIVE-11600 Project: Hive Issue Type: New Feature Reporter: Pengcheng Xiong Assignee: Pengcheng Xiong Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch, HIVE-11600.03.patch Current hive only support single column in clause, e.g., {code}select * from src where col0 in (v1,v2,v3);{code} We want it to support {code}select * from src where (col0,col1+3) in ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-11600) Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())
[ https://issues.apache.org/jira/browse/HIVE-11600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14704228#comment-14704228 ] Hive QA commented on HIVE-11600: {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12751345/HIVE-11600.02.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 9369 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_char_udf1 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_varchar_udf1 org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5017/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5017/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5017/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12751345 - PreCommit-HIVE-TRUNK-Build Hive Parser to Support multi col in clause (x,y..) in ((..),..., ()) Key: HIVE-11600 URL: https://issues.apache.org/jira/browse/HIVE-11600 Project: Hive Issue Type: New Feature Reporter: Pengcheng Xiong Assignee: Pengcheng Xiong Attachments: HIVE-11600.01.patch, HIVE-11600.02.patch Current hive only support single column in clause, e.g., {code}select * from src where col0 in (v1,v2,v3);{code} We want it to support {code}select * from src where (col0,col1+3) in ((col0+v1,v2),(v3,v4-col1));{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)