[ https://issues.apache.org/jira/browse/HIVE-15227?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15704097#comment-15704097 ]
Hive QA commented on HIVE-15227: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12840766/HIVE-15227.3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 10735 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample2] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample4] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample6] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample7] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample9] (batchId=38) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] (batchId=134) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_4] (batchId=92) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=131) org.apache.hive.hcatalog.api.TestHCatClientNotification.createTable (batchId=218) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2316/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2316/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2316/ 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: 9 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12840766 - PreCommit-HIVE-Build > Optimize join + gby into semijoin > --------------------------------- > > Key: HIVE-15227 > URL: https://issues.apache.org/jira/browse/HIVE-15227 > Project: Hive > Issue Type: Bug > Components: Logical Optimizer > Reporter: Ashutosh Chauhan > Assignee: Ashutosh Chauhan > Attachments: HIVE-15227.2.patch, HIVE-15227.3.patch, HIVE-15227.patch > > > Calcite has a rule which can do this transformation. Lets take advantage of > this since Hive has native Left semi join operator. -- This message was sent by Atlassian JIRA (v6.3.4#6332)