[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16328484#comment-16328484 ]
Hive QA commented on HIVE-16605: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12906334/HIVE-16605.1.patch {color:green}SUCCESS:{color} +1 due to 3 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 305 failed/errored test(s), 11642 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_merge_orc] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_2] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join25] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_smb_mapjoin_14] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin1] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin2] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin3] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketmapjoin4] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketsortoptimize_insert_6] (batchId=7) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketsortoptimize_insert_7] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_limit] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_udf_udaf] (batchId=18) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_udf_udaf_stats_opt] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_views] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_semijoin] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_subq_in] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_udf_udaf] (batchId=4) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_views] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cluster] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[columnStatsUpdateForStatsOptimizer_1] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[column_access_stats] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[columnstats_part_coltype] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constprog_semijoin] (batchId=64) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer1] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer2] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer3] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer4] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[correlationoptimizer6] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[count] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cross_prod_1] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cross_prod_3] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cross_prod_4] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[database] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[disable_merge_for_bucketing] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[drop_partition_with_stats] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_partition_pruning] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_semijoin_reduction] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_semijoin_reduction_2] (batchId=76) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_semijoin_reduction_3] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_semijoin_reduction_sw] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_opt_vectorization] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_optimization2] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_optimization] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_optimization_acid] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[enforce_constraint_notnull] (batchId=18) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[escape1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[escape2] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[exchgpartition2lel] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explainanalyze_2] (batchId=69) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explainuser_1] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explainuser_4] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[extrapolate_part_stats_partial_ndv] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2] (batchId=48) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_id2] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_resolution] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[infer_bucket_sort_bucketed_table] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input16_cc] (batchId=89) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_dir_distcp] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_into_with_schema] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_values_orig_table] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_values_orig_table_use_metadata] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[is_distinct_from] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[jdbc_handler] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join1] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join32_lessSize] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_acid_non_acid] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_filters] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_is_not_distinct_from] (batchId=86) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_max_hashtable] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_nulls] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_nullsafe] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join_reordering_no_stats] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lateral_view] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[leftsemijoin_mr] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_join_transpose] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown3] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown] (batchId=69) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lineage2] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lineage3] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[list_bucket_dml_10] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[llap_partitioned] (batchId=21) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[llap_vector_nohybridgrace] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[load_dyn_part5] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[lvj_mapjoin] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_decimal] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_emit_interval] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_hint] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mergejoin_3way] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[metadataonly1] (batchId=66) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mrr] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multiMapJoin1] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multiMapJoin2] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multi_column_in] (batchId=19) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multi_column_in_single] (batchId=12) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multi_insert] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[multi_insert_lateral_view] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[non_native_window_udf] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[offset_limit] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[offset_limit_ppd_optimizer] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[optimize_join_ptp] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[optimize_nullscan] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_analyze] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_create] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_llap_nonvector] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_merge7] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_ppd_date] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_ppd_decimal] (batchId=7) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_ppd_timestamp] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_ppd_varchar] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_predicate_pushdown] (batchId=7) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_split_elimination] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[order_null] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_predicate_pushdown] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_types] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partialdhj] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_multilevels] (batchId=21) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_pruning] (batchId=86) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_shared_scan] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_join5] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_union_view] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppr_pushdown] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ptf] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ptf_streaming] (batchId=54) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[quotedid_smb] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[reduce_deduplicate_extended] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[resourceplan] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample10] (batchId=48) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acid_part] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acid_part_update] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acid_table] (batchId=38) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acid_table_update] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acidvec_part] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acidvec_part_update] (batchId=13) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acidvec_table] (batchId=85) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_acidvec_table_update] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_nonvec_part] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_nonvec_part_all_complex] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_nonvec_part_all_primitive] (batchId=87) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_nonvec_table] (batchId=12) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_vec_part] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_vec_part_all_complex] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_vec_part_all_primitive] (batchId=76) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_orc_vec_table] (batchId=42) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_stats] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_nonvec_part] (batchId=18) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_nonvec_part_all_complex] (batchId=69) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_nonvec_part_all_primitive] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_nonvec_table] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vec_part] (batchId=55) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vec_part_all_complex] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vec_part_all_primitive] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vec_table] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vecrow_part] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vecrow_part_all_complex] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vecrow_part_all_primitive] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[schema_evol_text_vecrow_table] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[selectDistinctStar] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin6] (batchId=83) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin7] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[semijoin_hint] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sharedworkext] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_functions] (batchId=73) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[skewjoinopt15] (batchId=11) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[skiphf_aggr] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_cache] (batchId=27) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_14] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_15] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_17] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_18] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_19] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_4] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_5] (batchId=88) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[smb_mapjoin_6] (batchId=32) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[special_character_in_tabnames_1] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sqlmerge] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats11] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stats_based_fetch_decision] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_corr] (batchId=54) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] (batchId=58) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_multi] (batchId=19) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_nested_subquery] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notin] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_null_agg] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_scalar] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_select] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_shared_alias] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_views] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sysdb] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[table_access_keys_stats] (batchId=71) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[temp_table] (batchId=86) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_bmj_schema_evolution] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_dml] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_dynpart_hashjoin_1] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_dynpart_hashjoin_2] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_dynpart_hashjoin_3] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_fsstat] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_insert_overwrite_local_directory_1] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_join] (batchId=39) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_join_result_complex] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_join_tests] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_joins_explain] (batchId=39) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_multi_union] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_nway_join] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_schema_evolution] (batchId=87) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_self_join] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_smb_1] (batchId=73) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_smb_empty] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_smb_main] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_union2] (batchId=5) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_union] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_union_decimal] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_union_group_by] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_union_multiinsert] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_vector_dynpart_hashjoin_1] (batchId=74) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[tez_vector_dynpart_hashjoin_2] (batchId=28) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[uber_reduce] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udaf_all_keyword] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udaf_collect_set_2] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionDistinct_2] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionDistinct_3] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_fast_stats] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_remove_26] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_top_level] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[varchar_udf1] (batchId=21) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_adaptor_usage_mode] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_auto_smb_mapjoin_14] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_between_in] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_complex_all] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_count_distinct] (batchId=24) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_2] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_udf] (batchId=89) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_cube1] (batchId=47) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_id1] (batchId=26) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_id2] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_id3] (batchId=35) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets1] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets2] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets3] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets4] (batchId=29) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets5] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets6] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets_grouping] (batchId=7) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_sets_limit] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_grouping_window] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_rollup1] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_inner_join] (batchId=70) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_interval_2] (batchId=68) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_join30] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_join_filters] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_join_nulls] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_leftsemi_mapjoin] (batchId=11) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_mapjoin_reduce] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_nullsafe_join] (batchId=87) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_number_compare_projection] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_outer_join5] (batchId=84) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_partition_diff_num_cols] (batchId=56) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_partitioned_date_time] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_ptf_part_simple] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_udf1] (batchId=58) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing] (batchId=88) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_expressions] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_gby2] (batchId=66) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_gby] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_multipartitioning] (batchId=44) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_navfn] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_order_null] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_range_multiorder] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_rank] (batchId=58) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_streaming] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_windowspec4] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_windowing_windowspec] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_0] (batchId=82) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_input_format_excludes] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_short_regress] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_dynamic_partition_pruning] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction2] (batchId=42) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=4) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_insert_into_bucketed_table] (batchId=25) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_join46] (batchId=45) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_multi_output_select] (batchId=62) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_nested_mapjoin] (batchId=17) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_parquet] (batchId=51) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_ptf] (batchId=64) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing] (batchId=53) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_gby] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[windowing_windowspec2] (batchId=61) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb] (batchId=151) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez1] (batchId=163) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynpart_sort_optimization2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid] (batchId=162) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid_fast] (batchId=157) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mergejoin] (batchId=160) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[optimize_nullscan] (batchId=162) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_part] (batchId=94) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_with_constraints_enable] (batchId=94) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_with_constraints_enforced] (batchId=94) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[stats_aggregator_error_1] (batchId=94) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ppd_join5] (batchId=121) org.apache.hadoop.hive.cli.control.TestDanglingQOuts.checkDanglingQOut (batchId=212) org.apache.hadoop.hive.ql.io.TestDruidRecordWriter.testWrite (batchId=247) org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=225) org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=225) org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=225) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/8651/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/8651/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-8651/ 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: 305 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12906334 - PreCommit-HIVE-Build > Enforce NOT NULL constraints > ---------------------------- > > Key: HIVE-16605 > URL: https://issues.apache.org/jira/browse/HIVE-16605 > Project: Hive > Issue Type: New Feature > Affects Versions: 3.0.0 > Reporter: Carter Shanklin > Assignee: Vineet Garg > Priority: Major > Attachments: HIVE-16605.1.patch > > > Since NOT NULL is so common it would be great to have tables start to enforce > that. > [~ekoifman] described a possible approach in HIVE-16575: > {quote} > One way to enforce not null constraint is to have the optimizer add > enforce_not_null UDF which throws if it sees a NULL, otherwise it's pass > through. > So if 'b' has not null constraint, > Insert into T select a,b,c... would become > Insert into T select a, enforce_not_null(b), c..... > This would work for any table type. > {quote} -- This message was sent by Atlassian JIRA (v7.6.3#76005)