[jira] [Commented] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15879571#comment-15879571 ] Ashutosh Chauhan commented on HIVE-16002: - +1 > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15879353#comment-15879353 ] Vineet Garg commented on HIVE-16002: [~ashutoshc] done > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15879267#comment-15879267 ] Ashutosh Chauhan commented on HIVE-16002: - Can you also add test case from HIVE-5873 > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15877678#comment-15877678 ] Hive QA commented on HIVE-16002: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853851/HIVE-16002.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 10252 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_in] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin] (batchId=151) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_in] (batchId=122) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgressParallel (batchId=211) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3685/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3685/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3685/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase 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: 7 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12853851 - PreCommit-HIVE-Build > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)