[ https://issues.apache.org/jira/browse/HIVE-11517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14904684#comment-14904684 ]
Hive QA commented on HIVE-11517: -------------------------------- {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/12761745/HIVE-11517.01.patch {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 9565 tests executed *Failed tests:* {noformat} TestMiniTezCliDriver-update_after_multiple_inserts.q-update_all_partitioned.q-vectorized_rcfile_columnar.q-and-12-more - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_smb_mapjoin_14 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vector_groupby_reduce org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_groupby_reduce 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/5385/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5385/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5385/ 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: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12761745 - PreCommit-HIVE-TRUNK-Build > Vectorized auto_smb_mapjoin_14.q produces different results > ----------------------------------------------------------- > > Key: HIVE-11517 > URL: https://issues.apache.org/jira/browse/HIVE-11517 > Project: Hive > Issue Type: Bug > Reporter: Matt McCline > Assignee: Matt McCline > Priority: Critical > Attachments: HIVE-11517.01.patch > > > Converted Q file to use ORC and turned on vectorization. > The query: > {code} > select count(*) from ( > select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 > b on a.key = b.key > ) subq1 > {code} > produces 10 instead of 22. > The query: > {code} > select src1.key, src1.cnt1, src2.cnt1 from > ( > select key, count(*) as cnt1 from > ( > select a.key as key, a.value as val1, b.value as val2 from tbl1 a join > tbl2 b on a.key = b.key > ) subq1 group by key > ) src1 > join > ( > select key, count(*) as cnt1 from > ( > select a.key as key, a.value as val1, b.value as val2 from tbl1 a join > tbl2 b on a.key = b.key > ) subq2 group by key > ) src2 > {code} > produces: > {code} > 0 3 3 > 2 1 1 > 4 1 1 > 5 3 3 > 8 1 1 > 9 1 1 > {code} > instead of: > {code} > 0 9 9 > 2 1 1 > 4 1 1 > 5 9 9 > 8 1 1 > 9 1 1 > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)