[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)