[ https://issues.apache.org/jira/browse/HIVE-21867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16866251#comment-16866251 ]
Hive QA commented on HIVE-21867: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12972030/HIVE-21867.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 172 failed/errored test(s), 16164 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_semijoin_user_level] (batchId=157) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction_2] (batchId=181) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction_4] (batchId=169) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction_on_aggcol] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction_sw2] (batchId=181) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction_sw] (batchId=162) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_2] (batchId=167) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mapjoin_hint] (batchId=169) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mergejoin] (batchId=177) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[reopt_semijoin] (batchId=184) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[semijoin_hint] (batchId=167) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction2] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=161) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[hybridgrace_hashjoin_2] (batchId=110) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query10] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query11] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query12] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query13] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query14] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query15] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query16] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query17] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query18] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query19] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query20] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query23] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query24] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query25] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query26] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query27] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query29] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query31] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query33] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query34] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query35] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query36] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query37] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query38] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query3] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query40] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query42] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query43] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query45] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query46] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query47] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query48] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query49] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query4] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query50] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query51] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query52] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query53] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query54] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query55] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query56] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query57] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query58] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query5] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query60] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query61] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query63] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query64] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query65] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query66] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query67] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query68] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query69] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query6] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query70] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query71] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query72] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query73] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query74] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query75] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query77] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query78] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query79] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query7] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query80] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query82] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query85] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query86] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query87] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query88] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query89] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query8] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query90] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query93] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query94] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query96] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query97] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query98] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query99] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query10] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query11] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query12] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query13] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query14] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query15] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query16] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query17] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query18] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query19] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query20] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query23] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query24] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query25] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query26] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query27] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query29] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query31] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query33] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query34] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query35] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query36] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query38] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query3] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query40] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query42] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query43] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query45] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query46] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query47] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query48] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query49] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query4] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query50] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query51] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query52] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query53] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query54] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query55] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query56] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query57] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query58] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query5] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query60] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query61] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query63] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query64] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query65] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query66] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query67] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query68] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query69] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query6] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query70] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query71] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query72] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query73] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query74] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query75] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query77] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query78] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query79] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query7] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query80] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query85] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query86] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query87] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query88] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query89] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query8] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query90] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query94] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query95] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query96] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query97] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query98] (batchId=287) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query99] (batchId=287) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/17621/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/17621/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-17621/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 172 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12972030 - PreCommit-HIVE-Build > Sort semijoin conditions to accelerate query processing > ------------------------------------------------------- > > Key: HIVE-21867 > URL: https://issues.apache.org/jira/browse/HIVE-21867 > Project: Hive > Issue Type: New Feature > Components: Physical Optimizer > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-21867.patch > > > The problem was tackled for CBO in HIVE-21857. Semijoin filters are > introduced later in the planning phase. Follow similar approach to sort them, > trying to accelerate filter evaluation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)