[ https://issues.apache.org/jira/browse/HIVE-16797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037454#comment-16037454 ]
Hive QA commented on HIVE-16797: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12871266/HIVE-16797.02.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 25 failed/errored test(s), 10822 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[create_merge_compressed] (batchId=237) org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[insert_overwrite_local_directory_1] (batchId=237) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_sortmerge_join_2] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[filter_aggr] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union24] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union30] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union34] (batchId=12) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionall_unbalancedppd] (batchId=2) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_union_multiinsert] (batchId=151) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=99) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query33] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query56] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query5] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query60] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query71] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query76] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query77] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query78] (batchId=232) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query80] (batchId=232) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union30] (batchId=134) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5534/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5534/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5534/ 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: 25 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12871266 - PreCommit-HIVE-Build > Enhance HiveFilterSetOpTransposeRule to remove union branches > ------------------------------------------------------------- > > Key: HIVE-16797 > URL: https://issues.apache.org/jira/browse/HIVE-16797 > Project: Hive > Issue Type: Sub-task > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Attachments: HIVE-16797.01.patch, HIVE-16797.02.patch > > > in query4.q, we can see that it creates a CTE with union all of 3 branches. > Then it is going to do a 3 way self-join of the CTE with predicates. The > predicates actually specifies only one of the branch in CTE to participate in > the join. Thus, in some cases, e.g., > {code} > /- filter(false) -----TS0 > union all - filter(false) -----TS1 > \-----TS2 > {code} > we can cut the branches of TS0 and TS1. The union becomes only TS2. -- This message was sent by Atlassian JIRA (v6.3.15#6346)