[ https://issues.apache.org/jira/browse/HIVE-16797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16034092#comment-16034092 ]
Hive QA commented on HIVE-16797: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12870871/HIVE-16797.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 10813 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionall_unbalancedppd] (batchId=2) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype] (batchId=157) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=232) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5506/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5506/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5506/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12870871 - 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 > > > 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)