[ https://issues.apache.org/jira/browse/HIVE-15944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15881555#comment-15881555 ]
Hive QA commented on HIVE-15944: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12854227/HIVE-15944.3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 142 failed/errored test(s), 10258 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[columnstats_partlvl] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[columnstats_partlvl_dp] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[columnstats_tbllvl] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[complex_alias] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constant_prop_3] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer13] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[decimal_udf] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[display_colstats_tbllvl] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[distinct_windowing_no_cbo] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_basic2] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_rdd_cache] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[except_all] (batchId=43) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby9] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_join_pushdown] (batchId=73) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_position] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[having2] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[index_auto_update] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown_negative] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multi_insert_gby3] (batchId=69) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multigroupby_singlemr] (batchId=64) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[nested_column_pruning] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_types_non_dictionary_encoding_vectorization] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_types_vectorization] (batchId=13) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_gby2] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_gby] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_windowing1] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ptfgroupbyjoin] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[reduce_deduplicate_extended2] (batchId=55) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists_having] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notin_having] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_unqualcolumnrefs] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[temp_table_display_colstats_tbllvl] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_aggregate] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_round_2] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_3] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_reduce] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_orderby_5] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_13] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_15] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_limit] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_parquet_types] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_gby2] (batchId=33) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_partition_pruning_2] (batchId=136) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=137) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_stats] (batchId=135) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_schema_evol_3a] (batchId=136) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_groupby] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1] (batchId=145) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lateral_view] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_pushdown3] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_pushdown] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multi_insert_lateral_view] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[offset_limit_ppd_optimizer] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ptf] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_in] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_multi] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_scalar] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_aggregate] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_round_2] (batchId=143) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_udf] (batchId=155) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_groupby_3] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_groupby_reduce] (batchId=149) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_interval_2] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_orderby_5] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_0] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_13] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_15] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_short_regress] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_parquet] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_parquet_types] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_ptf] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[windowing_gby] (batchId=146) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[vectorization_limit] (batchId=93) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query12] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query15] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query16] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query17] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query18] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query19] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query1] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query20] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query22] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query25] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query26] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query29] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query30] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query31] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query38] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query39] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query3] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query42] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query46] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query51] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query52] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query54] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query55] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query58] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query5] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query64] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query65] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query66] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query67] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query68] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query69] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query6] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query70] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query71] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query72] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query79] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query7] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query81] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query83] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query85] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query87] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query89] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query8] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query91] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query92] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query97] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query98] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[dynamic_rdd_cache] (batchId=118) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby9] (batchId=98) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_position] (batchId=111) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[limit_pushdown] (batchId=124) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[multi_insert_gby3] (batchId=127) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[multi_insert_lateral_view] (batchId=117) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[multigroupby_singlemr] (batchId=124) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ptf] (batchId=102) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_in] (batchId=122) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_decimal_aggregate] (batchId=103) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_groupby_3] (batchId=122) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_orderby_5] (batchId=112) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_0] (batchId=130) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_13] (batchId=116) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_15] (batchId=122) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_short_regress] (batchId=115) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_ptf] (batchId=122) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3734/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3734/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3734/ 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: 142 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12854227 - PreCommit-HIVE-Build > The order of cols is error in ColumnPrunerReduceSinkProc because of sort > operator > --------------------------------------------------------------------------------- > > Key: HIVE-15944 > URL: https://issues.apache.org/jira/browse/HIVE-15944 > Project: Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 1.1.0, 2.2.0 > Reporter: wan kun > Assignee: wan kun > Fix For: 2.2.0 > > Attachments: HIVE-15944.1.patch, > HIVE-15944.2-branch-1.1.1.path.erroroutput, HIVE-15944.3-branch-1.1.1.path, > HIVE-15944.3.patch, HIVE-15944-branch-1.1.patch, HIVE-15944.patch, > STAGE_DEPENDENCIES > > Original Estimate: 168h > Remaining Estimate: 168h > > If one sql have two job. > job 1:The order of cols is updated in ColumnPrunerReduceSinkProc because of > sort operator. > job 2 will read error in map operation because the cols order is old. -- This message was sent by Atlassian JIRA (v6.3.15#6346)