[ https://issues.apache.org/jira/browse/HIVE-23082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17071360#comment-17071360 ]
Hive QA commented on HIVE-23082: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12998230/HIVE-23082.01.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 218 failed/errored test(s), 18142 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[annotate_stats_join_pkfk] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[convert_decimal64_to_decimal] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[filter_join_breaktask] (batchId=87) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_join_pushdown] (batchId=92) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join46] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin46] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[named_column_join] (batchId=89) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_left_outer_join] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join0] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join1] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join2] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join3] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join4] (batchId=100) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_join46_mr] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_mapjoin] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_shufflejoin] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_gby2] (batchId=41) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[convert_decimal64_to_decimal] (batchId=181) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1] (batchId=176) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[filter_join_breaktask] (batchId=189) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_1] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[join46] (batchId=166) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mapjoin46] (batchId=184) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[orc_llap] (batchId=180) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[semijoin6] (batchId=192) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[semijoin7] (batchId=166) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[semijoin] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[semijoin_hint] (batchId=174) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_left_outer_join] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_leftsemi_mapjoin] (batchId=169) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_nullsafe_join] (batchId=193) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_outer_join0] (batchId=184) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_outer_join1] (batchId=179) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_outer_join2] (batchId=174) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_windowing_gby2] (batchId=186) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_windowing_gby] (batchId=190) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_join46] (batchId=180) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_mapjoin] (batchId=188) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_nested_mapjoin] (batchId=170) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_shufflejoin] (batchId=188) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[windowing_gby] (batchId=178) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_explainuser_1] (batchId=201) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[hybridgrace_hashjoin_1] (batchId=116) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[cbo_query23] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query10] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query11] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query12] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query13] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query14] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query15] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query16] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query17] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query18] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query19] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query1] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query1b] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query20] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query23] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query25] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query26] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query27] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query29] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query30] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query31] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query32] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query33] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query34] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query35] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query36] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query38] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query3] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query40] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query42] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query43] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query45] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query46] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query47] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query48] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query49] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query4] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query50] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query51] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query52] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query53] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query54] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query55] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query56] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query57] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query58] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query59] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query5] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query60] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query61] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query63] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query64] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query65] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query66] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query67] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query68] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query69] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query6] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query70] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query71] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query72] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query73] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query74] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query75] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query77] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query78] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query79] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query7] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query80] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query81] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query83] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query84] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query85] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query86] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query87] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query88] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query89] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query8] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query90] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query91] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query92] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query93] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query94] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query96] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query97] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query98] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query99] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[cbo_query23] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query10] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query11] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query12] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query13] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query14] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query15] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query16] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query17] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query18] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query19] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query1] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query1b] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query20] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query23] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query25] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query26] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query27] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query29] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query30] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query31] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query32] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query33] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query34] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query35] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query36] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query38] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query3] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query40] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query42] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query43] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query45] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query46] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query47] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query48] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query49] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query4] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query50] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query51] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query52] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query53] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query54] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query55] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query56] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query57] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query58] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query59] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query5] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query60] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query61] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query63] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query64] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query65] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query66] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query67] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query68] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query69] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query70] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query71] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query72] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query73] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query74] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query75] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query77] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query78] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query79] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query7] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query80] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query81] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query83] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query84] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query85] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query86] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query87] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query88] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query89] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query8] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query90] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query91] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query92] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query93] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query94] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query95] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query96] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query97] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query98] (batchId=307) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query99] (batchId=307) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/21342/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21342/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21342/ 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: 218 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12998230 - PreCommit-HIVE-Build > PK/FK stat rescale doesn't work in some cases > --------------------------------------------- > > Key: HIVE-23082 > URL: https://issues.apache.org/jira/browse/HIVE-23082 > Project: Hive > Issue Type: Bug > Components: Statistics > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Attachments: HIVE-23082.01.patch > > > As a result in Joins may retain the original estimate; see MAPJOIN_33 in this > plan ; which retained the estimate of SEL_32 > {code} > +----------------------------------------------------+ > | Explain | > +----------------------------------------------------+ > | Plan optimized by CBO. | > | | > | Vertex dependency in root stage | > | Map 1 <- Map 2 (BROADCAST_EDGE) | > | | > | Stage-0 | > | Fetch Operator | > | limit:12 | > | Stage-1 | > | Map 1 vectorized | > | File Output Operator [FS_36] | > | Limit [LIM_35] (rows=12 width=4) | > | Number of rows:12 | > | Select Operator [SEL_34] (rows=5040 width=4) | > | Output:["_col0"] | > | Map Join Operator [MAPJOIN_33] (rows=5040 width=8) | > | Conds:SEL_32._col0=RS_30._col0(Inner) | > | <-Map 2 [BROADCAST_EDGE] vectorized | > | BROADCAST [RS_30] | > | PartitionCols:_col0 | > | Select Operator [SEL_29] (rows=1 width=8) | > | Output:["_col0"] | > | Filter Operator [FIL_28] (rows=1 width=108) | > | predicate:((r_reason_id = 'reason 66') and r_reason_sk > is not null) | > | TableScan [TS_3] (rows=2 width=108) | > | > default@rx0,reason,Tbl:COMPLETE,Col:COMPLETE,Output:["r_reason_id","r_reason_sk"] > | > | <-Select Operator [SEL_32] (rows=5040 width=7) | > | Output:["_col0"] | > | Filter Operator [FIL_31] (rows=5040 width=7) | > | predicate:sr_reason_sk is not null | > | TableScan [TS_0] (rows=5112 width=7) | > | > default@sr0,store_returns,Tbl:COMPLETE,Col:COMPLETE,Output:["sr_reason_sk"] | > | | > +----------------------------------------------------+ > {code} > repro: > {code} > set hive.query.results.cache.enabled=false; > set hive.explain.user=true; > drop table if exists default.rx0; > drop table if exists default.sr0; > create table rx0 (r_reason_id string, r_reason_sk bigint); > create table sr0 (sr_reason_sk bigint); > insert into rx0 values ('AAAAAAAAAAAAAAAA',1),('AAAAAAAAGEAAAAAA',70); > insert into sr0 values (NULL),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10), > (11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25), > (26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),(40), > (41),(42),(43),(44),(45),(46),(47),(48),(49),(50),(51),(52),(53),(54),(55), > (56),(57),(58),(59),(60),(61),(62),(63),(64),(65),(66),(67),(68),(69),(70); > insert into sr0 select a.* from sr0 a,sr0 b; > -- |sr0| ~ 5112 > explain select 1 > from default.sr0 store_returns , default.rx0 reason > where sr_reason_sk = r_reason_sk > and r_reason_id = 'reason 66' > limit 12; > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)