HIVE-14553: Remove tez golden files after HIVE-14502 (Prasanth Jayachandran reviewed by Siddharth Seth)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/975a49b6 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/975a49b6 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/975a49b6 Branch: refs/heads/master Commit: 975a49b6f0e52c764ad7c3f9f89038caef4f1446 Parents: 9cb5455 Author: Prasanth Jayachandran <[email protected]> Authored: Wed Aug 24 13:56:40 2016 -0700 Committer: Prasanth Jayachandran <[email protected]> Committed: Wed Aug 24 13:56:40 2016 -0700 ---------------------------------------------------------------------- .../tez/acid_bucket_pruning.q.out | 151 - .../clientpositive/tez/acid_globallimit.q.out | 52 - .../clientpositive/tez/acid_vectorization.q.out | 62 - .../tez/acid_vectorization_missing_cols.q.out | 56 - .../tez/acid_vectorization_partition.q.out | 60 - .../tez/acid_vectorization_project.q.out | 73 - .../clientpositive/tez/alter_merge_2_orc.q.out | 121 - .../clientpositive/tez/alter_merge_orc.q.out | 263 - .../tez/alter_merge_stats_orc.q.out | 382 - .../results/clientpositive/tez/auto_join0.q.out | 166 - .../results/clientpositive/tez/auto_join1.q.out | 124 - .../clientpositive/tez/auto_join21.q.out | 611 - .../clientpositive/tez/auto_join29.q.out | 3523 ---- .../clientpositive/tez/auto_join30.q.out | 1313 -- .../clientpositive/tez/auto_join_filters.q.out | 540 - .../clientpositive/tez/auto_join_nulls.q.out | 217 - .../tez/auto_sortmerge_join_1.q.out | 956 - .../tez/auto_sortmerge_join_10.q.out | 334 - .../tez/auto_sortmerge_join_11.q.out | 1338 -- .../tez/auto_sortmerge_join_12.q.out | 583 - .../tez/auto_sortmerge_join_13.q.out | 689 - .../tez/auto_sortmerge_join_14.q.out | 236 - .../tez/auto_sortmerge_join_15.q.out | 200 - .../tez/auto_sortmerge_join_16.q.out | 256 - .../tez/auto_sortmerge_join_2.q.out | 655 - .../tez/auto_sortmerge_join_3.q.out | 936 - .../tez/auto_sortmerge_join_4.q.out | 952 - .../tez/auto_sortmerge_join_5.q.out | 723 - .../tez/auto_sortmerge_join_6.q.out | 1292 -- .../tez/auto_sortmerge_join_7.q.out | 1119 -- .../tez/auto_sortmerge_join_8.q.out | 1121 -- .../tez/auto_sortmerge_join_9.q.out | 3567 ---- .../results/clientpositive/tez/bucket2.q.out | 466 - .../results/clientpositive/tez/bucket3.q.out | 477 - .../results/clientpositive/tez/bucket4.q.out | 465 - .../tez/bucket_map_join_tez1.q.out | 2009 --- .../tez/bucket_map_join_tez2.q.out | 701 - .../clientpositive/tez/bucketpruning1.q.out | 1643 -- .../results/clientpositive/tez/cbo_gby.q.out | 124 - .../clientpositive/tez/cbo_gby_empty.q.out | 77 - .../results/clientpositive/tez/cbo_join.q.out | 15028 ---------------- .../results/clientpositive/tez/cbo_limit.q.out | 90 - .../clientpositive/tez/cbo_semijoin.q.out | 440 - .../clientpositive/tez/cbo_simple_select.q.out | 755 - .../results/clientpositive/tez/cbo_stats.q.out | 14 - .../clientpositive/tez/cbo_subq_exists.q.out | 297 - .../clientpositive/tez/cbo_subq_in.q.out | 151 - .../clientpositive/tez/cbo_subq_not_in.q.out | 365 - .../clientpositive/tez/cbo_udf_udaf.q.out | 125 - .../results/clientpositive/tez/cbo_union.q.out | 920 - .../results/clientpositive/tez/cbo_views.q.out | 237 - .../clientpositive/tez/cbo_windowing.q.out | 293 - ...names_with_leading_and_trailing_spaces.q.out | 85 - .../clientpositive/tez/constprog_dpp.q.out | 87 - .../tez/constprog_partitioner.q.out | 119 - .../clientpositive/tez/constprog_semijoin.q.out | 494 - .../tez/correlationoptimizer1.q.out | 2967 ---- .../test/results/clientpositive/tez/count.q.out | 877 - .../tez/create_merge_compressed.q.out | 138 - .../results/clientpositive/tez/cross_join.q.out | 398 - .../tez/cross_product_check_1.q.out | 587 - .../tez/cross_product_check_2.q.out | 549 - .../test/results/clientpositive/tez/ctas.q.out | 905 - .../test/results/clientpositive/tez/cte_1.q.out | 111 - .../test/results/clientpositive/tez/cte_2.q.out | 190 - .../test/results/clientpositive/tez/cte_3.q.out | 187 - .../test/results/clientpositive/tez/cte_4.q.out | 220 - .../test/results/clientpositive/tez/cte_5.q.out | 128 - .../results/clientpositive/tez/cte_mat_1.q.out | 43 - .../results/clientpositive/tez/cte_mat_2.q.out | 43 - .../results/clientpositive/tez/cte_mat_3.q.out | 59 - .../results/clientpositive/tez/cte_mat_4.q.out | 301 - .../results/clientpositive/tez/cte_mat_5.q.out | 149 - .../tez/custom_input_output_format.q.out | 102 - .../clientpositive/tez/deleteAnalyze.q.out | 140 - .../tez/delete_all_non_partitioned.q.out | 52 - .../tez/delete_all_partitioned.q.out | 86 - .../clientpositive/tez/delete_tmp_table.q.out | 60 - .../tez/delete_where_no_match.q.out | 62 - .../tez/delete_where_non_partitioned.q.out | 61 - .../tez/delete_where_partitioned.q.out | 105 - .../tez/delete_whole_partition.q.out | 92 - .../tez/disable_merge_for_bucketing.q.out | 494 - .../tez/dynamic_partition_pruning.q.out | 5853 ------ .../tez/dynamic_partition_pruning_2.q.out | 1125 -- .../tez/dynpart_sort_opt_vectorization.q.out | 2595 --- .../tez/dynpart_sort_optimization.q.out | 3205 ---- .../tez/dynpart_sort_optimization2.q.out | 1842 -- .../results/clientpositive/tez/empty_join.q.out | 111 - .../clientpositive/tez/enforce_order.q.out | 80 - .../clientpositive/tez/explainuser_1.q.out | 5930 ------- .../clientpositive/tez/explainuser_2.q.out | 4190 ----- .../clientpositive/tez/explainuser_4.q.out | 482 - .../tez/filter_join_breaktask.q.out | 356 - .../tez/filter_join_breaktask2.q.out | 272 - .../results/clientpositive/tez/groupby1.q.out | 426 - .../results/clientpositive/tez/groupby2.q.out | 131 - .../results/clientpositive/tez/groupby3.q.out | 156 - .../results/clientpositive/tez/having.q.out | 1284 -- .../tez/identity_project_remove_skip.q.out | 120 - .../results/clientpositive/tez/insert1.q.out | 440 - .../tez/insert_acid_dynamic_partition.q.out | 48 - .../tez/insert_acid_not_bucketed.q.out | 36 - .../clientpositive/tez/insert_dir_distcp.q.out | 14 - .../clientpositive/tez/insert_into1.q.out | 632 - .../clientpositive/tez/insert_into2.q.out | 516 - .../clientpositive/tez/insert_orig_table.q.out | 80 - .../tez/insert_update_delete.q.out | 78 - .../tez/insert_values_acid_not_bucketed.q.out | 28 - .../tez/insert_values_dynamic_partitioned.q.out | 45 - .../tez/insert_values_non_partitioned.q.out | 70 - .../tez/insert_values_orig_table.q.out | 82 - .../tez/insert_values_partitioned.q.out | 66 - .../tez/insert_values_tmp_table.q.out | 36 - .../test/results/clientpositive/tez/join0.q.out | 237 - .../test/results/clientpositive/tez/join1.q.out | 1156 -- .../clientpositive/tez/join_nullsafe.q.out | 1651 -- .../clientpositive/tez/leftsemijoin.q.out | 114 - .../clientpositive/tez/limit_pushdown.q.out | 1468 -- .../clientpositive/tez/llap_nullscan.q.out | 446 - .../clientpositive/tez/llapdecider.q.out | 1284 -- .../clientpositive/tez/load_dyn_part1.q.out | 2214 --- .../clientpositive/tez/load_dyn_part2.q.out | 2151 --- .../clientpositive/tez/load_dyn_part3.q.out | 2137 --- .../clientpositive/tez/lvj_mapjoin.q.out | 295 - .../results/clientpositive/tez/mapjoin2.q.out | 95 - .../clientpositive/tez/mapjoin_decimal.q.out | 394 - .../clientpositive/tez/mapjoin_mapjoin.q.out | 772 - .../results/clientpositive/tez/mapreduce1.q.out | 621 - .../results/clientpositive/tez/mapreduce2.q.out | 616 - .../results/clientpositive/tez/merge1.q.out | 593 - .../results/clientpositive/tez/merge2.q.out | 593 - .../results/clientpositive/tez/mergejoin.q.out | 4324 ----- .../clientpositive/tez/mergejoin_3way.q.out | 30 - .../tez/metadata_only_queries.q.out | 719 - .../metadata_only_queries_with_filters.q.out | 224 - .../clientpositive/tez/metadataonly1.q.out | 1948 -- .../test/results/clientpositive/tez/mrr.q.out | 2272 --- .../tez/nonmr_fetch_threshold.q.out | 205 - .../clientpositive/tez/optimize_nullscan.q.out | 1862 -- .../clientpositive/tez/orc_analyze.q.out | 1544 -- .../results/clientpositive/tez/orc_merge1.q.out | 497 - .../clientpositive/tez/orc_merge10.q.out | 737 - .../clientpositive/tez/orc_merge11.q.out | 442 - .../results/clientpositive/tez/orc_merge2.q.out | 230 - .../results/clientpositive/tez/orc_merge3.q.out | 169 - .../results/clientpositive/tez/orc_merge4.q.out | 185 - .../results/clientpositive/tez/orc_merge5.q.out | 342 - .../results/clientpositive/tez/orc_merge6.q.out | 516 - .../results/clientpositive/tez/orc_merge7.q.out | 627 - .../results/clientpositive/tez/orc_merge8.q.out | 130 - .../results/clientpositive/tez/orc_merge9.q.out | 186 - .../clientpositive/tez/orc_merge_diff_fs.q.out | 497 - .../tez/orc_merge_incompat1.q.out | 244 - .../tez/orc_merge_incompat2.q.out | 374 - .../tez/orc_merge_incompat3.q.out | 70 - .../clientpositive/tez/orc_ppd_basic.q.out | 1022 -- .../tez/orc_ppd_schema_evol_1a.q.out | 70 - .../tez/orc_ppd_schema_evol_1b.q.out | 124 - .../tez/orc_ppd_schema_evol_2a.q.out | 70 - .../tez/orc_ppd_schema_evol_2b.q.out | 124 - .../tez/orc_ppd_schema_evol_3a.q.out | 1132 -- .../results/clientpositive/tez/order_null.q.out | 222 - .../results/clientpositive/tez/parallel.q.out | 1442 -- .../test/results/clientpositive/tez/ptf.q.out | 4833 ----- .../clientpositive/tez/ptf_matchpath.q.out | 400 - .../clientpositive/tez/ptf_streaming.q.out | 2604 --- .../results/clientpositive/tez/sample1.q.out | 697 - .../clientpositive/tez/script_env_var1.q.out | 18 - .../clientpositive/tez/script_env_var2.q.out | 16 - .../clientpositive/tez/script_pipe.q.out | 127 - .../clientpositive/tez/scriptfile1.q.out | 59 - .../clientpositive/tez/selectDistinctStar.q.out | 4902 ----- .../tez/select_dummy_source.q.out | 229 - .../tez/show_create_database.q.out | 19 - .../results/clientpositive/tez/skewjoin.q.out | 1153 -- .../results/clientpositive/tez/smb_cache.q.out | 347 - .../clientpositive/tez/stats_noscan_1.q.out | 500 - .../clientpositive/tez/stats_only_null.q.out | 420 - .../clientpositive/tez/subquery_exists.q.out | 308 - .../clientpositive/tez/subquery_in.q.out | 942 - .../results/clientpositive/tez/temp_table.q.out | 576 - .../tez/tez_bmj_schema_evolution.q.out | 2220 --- .../results/clientpositive/tez/tez_dml.q.out | 1526 -- .../tez/tez_dynpart_hashjoin_1.q.out | 797 - .../tez/tez_dynpart_hashjoin_2.q.out | 559 - .../tez/tez_dynpart_hashjoin_3.q.out | 196 - .../results/clientpositive/tez/tez_fsstat.q.out | 102 - ...tez_insert_overwrite_local_directory_1.q.out | 20 - .../results/clientpositive/tez/tez_join.q.out | 141 - .../clientpositive/tez/tez_join_hash.q.out | 628 - .../tez/tez_join_result_complex.q.out | 2073 --- .../clientpositive/tez/tez_join_tests.q.out | 2221 --- .../clientpositive/tez/tez_joins_explain.q.out | 709 - .../clientpositive/tez/tez_multi_union.q.out | 833 - .../tez/tez_schema_evolution.q.out | 114 - .../clientpositive/tez/tez_self_join.q.out | 218 - .../results/clientpositive/tez/tez_smb_1.q.out | 602 - .../clientpositive/tez/tez_smb_empty.q.out | 907 - .../clientpositive/tez/tez_smb_main.q.out | 1463 -- .../results/clientpositive/tez/tez_union.q.out | 1424 -- .../results/clientpositive/tez/tez_union2.q.out | 816 - .../clientpositive/tez/tez_union_decimal.q.out | 101 - .../tez/tez_union_dynamic_partition.q.out | 153 - .../clientpositive/tez/tez_union_group_by.q.out | 402 - .../tez/tez_union_multiinsert.q.out | 4376 ----- .../tez/tez_vector_dynpart_hashjoin_1.q.out | 810 - .../tez/tez_vector_dynpart_hashjoin_2.q.out | 563 - .../results/clientpositive/tez/transform1.q.out | 138 - .../results/clientpositive/tez/transform2.q.out | 11 - .../clientpositive/tez/transform_ppr1.q.out | 496 - .../clientpositive/tez/transform_ppr2.q.out | 402 - .../results/clientpositive/tez/union2.q.out | 98 - .../results/clientpositive/tez/union3.q.out | 247 - .../results/clientpositive/tez/union4.q.out | 168 - .../results/clientpositive/tez/union5.q.out | 150 - .../results/clientpositive/tez/union6.q.out | 166 - .../results/clientpositive/tez/union7.q.out | 147 - .../results/clientpositive/tez/union8.q.out | 1599 -- .../results/clientpositive/tez/union9.q.out | 121 - .../clientpositive/tez/unionDistinct_1.q.out | 15687 ----------------- .../clientpositive/tez/union_fast_stats.q.out | 646 - .../clientpositive/tez/union_stats.q.out | 480 - .../clientpositive/tez/union_type_chk.q.out | 30 - .../results/clientpositive/tez/union_view.q.out | 1171 -- .../tez/update_after_multiple_inserts.q.out | 78 - .../tez/update_all_non_partitioned.q.out | 62 - .../tez/update_all_partitioned.q.out | 106 - .../clientpositive/tez/update_all_types.q.out | 196 - .../clientpositive/tez/update_tmp_table.q.out | 62 - .../clientpositive/tez/update_two_cols.q.out | 63 - .../tez/update_where_no_match.q.out | 62 - .../tez/update_where_non_partitioned.q.out | 62 - .../tez/update_where_partitioned.q.out | 106 - .../clientpositive/tez/vector_acid3.q.out | 31 - .../clientpositive/tez/vector_aggregate_9.q.out | 174 - .../tez/vector_aggregate_without_gby.q.out | 72 - .../tez/vector_auto_smb_mapjoin_14.q.out | 1305 -- .../tez/vector_between_columns.q.out | 270 - .../clientpositive/tez/vector_between_in.q.out | 1039 -- .../tez/vector_binary_join_groupby.q.out | 401 - .../clientpositive/tez/vector_bround.q.out | 66 - .../clientpositive/tez/vector_bucket.q.out | 104 - .../tez/vector_cast_constant.q.out | 215 - .../clientpositive/tez/vector_char_2.q.out | 298 - .../clientpositive/tez/vector_char_4.q.out | 175 - .../clientpositive/tez/vector_char_cast.q.out | 35 - .../tez/vector_char_mapjoin1.q.out | 491 - .../clientpositive/tez/vector_char_simple.q.out | 348 - .../clientpositive/tez/vector_coalesce.q.out | 511 - .../clientpositive/tez/vector_coalesce_2.q.out | 303 - .../clientpositive/tez/vector_complex_all.q.out | 254 - .../tez/vector_complex_join.q.out | 227 - .../clientpositive/tez/vector_count.q.out | 314 - .../tez/vector_count_distinct.q.out | 1382 -- .../clientpositive/tez/vector_data_types.q.out | 287 - .../clientpositive/tez/vector_date_1.q.out | 724 - .../clientpositive/tez/vector_decimal_1.q.out | 600 - .../tez/vector_decimal_10_0.q.out | 114 - .../clientpositive/tez/vector_decimal_2.q.out | 1674 -- .../clientpositive/tez/vector_decimal_3.q.out | 392 - .../clientpositive/tez/vector_decimal_4.q.out | 250 - .../clientpositive/tez/vector_decimal_5.q.out | 239 - .../clientpositive/tez/vector_decimal_6.q.out | 305 - .../tez/vector_decimal_aggregate.q.out | 237 - .../tez/vector_decimal_cast.q.out | 41 - .../tez/vector_decimal_expressions.q.out | 101 - .../tez/vector_decimal_mapjoin.q.out | 268 - .../tez/vector_decimal_math_funcs.q.out | 196 - .../tez/vector_decimal_precision.q.out | 672 - .../tez/vector_decimal_round.q.out | 462 - .../tez/vector_decimal_round_2.q.out | 504 - .../tez/vector_decimal_trailing.q.out | 121 - .../clientpositive/tez/vector_decimal_udf.q.out | 2757 --- .../tez/vector_decimal_udf2.q.out | 188 - .../clientpositive/tez/vector_distinct_2.q.out | 1871 -- .../results/clientpositive/tez/vector_elt.q.out | 121 - .../clientpositive/tez/vector_groupby4.q.out | 137 - .../clientpositive/tez/vector_groupby6.q.out | 137 - .../clientpositive/tez/vector_groupby_3.q.out | 1874 -- .../tez/vector_groupby_mapjoin.q.out | 87 - .../tez/vector_groupby_reduce.q.out | 1875 -- .../tez/vector_grouping_sets.q.out | 297 - .../clientpositive/tez/vector_if_expr.q.out | 83 - .../tez/vector_include_no_sel.q.out | 284 - .../clientpositive/tez/vector_inner_join.q.out | 875 - .../clientpositive/tez/vector_interval_1.q.out | 830 - .../clientpositive/tez/vector_interval_2.q.out | 1630 -- .../tez/vector_interval_arithmetic.q.out | 1085 -- .../tez/vector_interval_mapjoin.q.out | 302 - .../clientpositive/tez/vector_join30.q.out | 1377 -- .../tez/vector_join_filters.q.out | 224 - .../clientpositive/tez/vector_join_nulls.q.out | 197 - .../tez/vector_left_outer_join.q.out | 142 - .../tez/vector_left_outer_join2.q.out | 609 - .../tez/vector_leftsemi_mapjoin.q.out | 13965 --------------- .../tez/vector_mapjoin_reduce.q.out | 316 - .../tez/vector_mr_diff_schema_alias.q.out | 393 - .../tez/vector_multi_insert.q.out | 234 - .../tez/vector_null_projection.q.out | 183 - .../tez/vector_nullsafe_join.q.out | 1222 -- .../results/clientpositive/tez/vector_nvl.q.out | 194 - .../vector_orc_string_reader_empty_dict.q.out | 62 - .../clientpositive/tez/vector_orderby_5.q.out | 190 - .../clientpositive/tez/vector_outer_join0.q.out | 242 - .../clientpositive/tez/vector_outer_join1.q.out | 676 - .../clientpositive/tez/vector_outer_join2.q.out | 377 - .../clientpositive/tez/vector_outer_join3.q.out | 672 - .../clientpositive/tez/vector_outer_join4.q.out | 1045 -- .../clientpositive/tez/vector_outer_join5.q.out | 1346 -- .../clientpositive/tez/vector_outer_join6.q.out | 371 - .../tez/vector_partition_diff_num_cols.q.out | 619 - .../tez/vector_partitioned_date_time.q.out | 2065 --- .../clientpositive/tez/vector_reduce1.q.out | 2168 --- .../clientpositive/tez/vector_reduce2.q.out | 2168 --- .../clientpositive/tez/vector_reduce3.q.out | 2168 --- .../tez/vector_reduce_groupby_decimal.q.out | 208 - .../tez/vector_select_null2.q.out | 95 - .../tez/vector_string_concat.q.out | 418 - .../clientpositive/tez/vector_struct_in.q.out | 645 - .../tez/vector_tablesample_rows.q.out | 307 - .../clientpositive/tez/vector_varchar_4.q.out | 175 - .../tez/vector_varchar_mapjoin1.q.out | 475 - .../tez/vector_varchar_simple.q.out | 348 - .../tez/vector_when_case_null.q.out | 98 - .../clientpositive/tez/vectorization_0.q.out | 1105 -- .../clientpositive/tez/vectorization_1.q.out | 49 - .../clientpositive/tez/vectorization_10.q.out | 298 - .../clientpositive/tez/vectorization_11.q.out | 80 - .../clientpositive/tez/vectorization_12.q.out | 602 - .../clientpositive/tez/vectorization_13.q.out | 512 - .../clientpositive/tez/vectorization_14.q.out | 836 - .../clientpositive/tez/vectorization_15.q.out | 253 - .../clientpositive/tez/vectorization_16.q.out | 671 - .../clientpositive/tez/vectorization_17.q.out | 508 - .../clientpositive/tez/vectorization_2.q.out | 53 - .../clientpositive/tez/vectorization_3.q.out | 58 - .../clientpositive/tez/vectorization_4.q.out | 53 - .../clientpositive/tez/vectorization_5.q.out | 47 - .../clientpositive/tez/vectorization_6.q.out | 1624 -- .../clientpositive/tez/vectorization_7.q.out | 384 - .../clientpositive/tez/vectorization_8.q.out | 358 - .../clientpositive/tez/vectorization_9.q.out | 671 - .../tez/vectorization_decimal_date.q.out | 55 - .../tez/vectorization_nested_udf.q.out | 9 - .../clientpositive/tez/vectorization_not.q.out | 58 - .../clientpositive/tez/vectorization_part.q.out | 72 - .../tez/vectorization_part_project.q.out | 125 - .../tez/vectorization_part_varchar.q.out | 72 - .../tez/vectorization_pushdown.q.out | 71 - .../tez/vectorization_short_regress.q.out | 3452 ---- .../tez/vectorized_bucketmapjoin1.q.out | 374 - .../clientpositive/tez/vectorized_case.q.out | 186 - .../clientpositive/tez/vectorized_casts.q.out | 370 - .../clientpositive/tez/vectorized_context.q.out | 345 - .../tez/vectorized_date_funcs.q.out | 1020 -- .../tez/vectorized_distinct_gby.q.out | 173 - .../vectorized_dynamic_partition_pruning.q.out | 5588 ------ .../clientpositive/tez/vectorized_mapjoin.q.out | 114 - .../tez/vectorized_mapjoin2.q.out | 135 - .../tez/vectorized_math_funcs.q.out | 247 - .../tez/vectorized_nested_mapjoin.q.out | 137 - .../clientpositive/tez/vectorized_parquet.q.out | 324 - .../tez/vectorized_parquet_types.q.out | 298 - .../clientpositive/tez/vectorized_ptf.q.out | 7035 -------- .../tez/vectorized_rcfile_columnar.q.out | 62 - .../tez/vectorized_shufflejoin.q.out | 131 - .../tez/vectorized_string_funcs.q.out | 123 - .../tez/vectorized_timestamp.q.out | 157 - .../tez/vectorized_timestamp_funcs.q.out | 888 - .../tez/vectorized_timestamp_ints_casts.q.out | 224 - .../clientpositive/tez/windowing_gby.q.out | 66 - 372 files changed, 287365 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_bucket_pruning.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_bucket_pruning.q.out b/ql/src/test/results/clientpositive/tez/acid_bucket_pruning.q.out deleted file mode 100644 index e71bc12..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_bucket_pruning.q.out +++ /dev/null @@ -1,151 +0,0 @@ -PREHOOK: query: -- Bucket pruning only works for ACID when split-update (U=D+I) has been enabled for the table. --- For e.g., this can be done by setting 'transactional_properties' = 'default'. --- This also means that bucket pruning will not work for ACID tables with legacy behaviour. - -CREATE TABLE acidTblDefault(a INT) CLUSTERED BY(a) INTO 16 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acidTblDefault -POSTHOOK: query: -- Bucket pruning only works for ACID when split-update (U=D+I) has been enabled for the table. --- For e.g., this can be done by setting 'transactional_properties' = 'default'. --- This also means that bucket pruning will not work for ACID tables with legacy behaviour. - -CREATE TABLE acidTblDefault(a INT) CLUSTERED BY(a) INTO 16 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acidTblDefault -PREHOOK: query: INSERT INTO TABLE acidTblDefault SELECT cint FROM alltypesorc WHERE cint IS NOT NULL ORDER BY cint -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acidtbldefault -POSTHOOK: query: INSERT INTO TABLE acidTblDefault SELECT cint FROM alltypesorc WHERE cint IS NOT NULL ORDER BY cint -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acidtbldefault -POSTHOOK: Lineage: acidtbldefault.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -PREHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1) -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@acidtbldefault -POSTHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@acidtbldefault -POSTHOOK: Lineage: acidtbldefault.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: -- Exactly one of the buckets should be selected out of the 16 buckets --- by the following selection query. -EXPLAIN EXTENDED -SELECT * FROM acidTblDefault WHERE a = 1 -PREHOOK: type: QUERY -POSTHOOK: query: -- Exactly one of the buckets should be selected out of the 16 buckets --- by the following selection query. -EXPLAIN EXTENDED -SELECT * FROM acidTblDefault WHERE a = 1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: acidtbldefault - filterExpr: (a = 1) (type: boolean) - buckets included: [1,] of 16 - Statistics: Num rows: 8983 Data size: 35932 Basic stats: COMPLETE Column stats: NONE - GatherStats: false - Filter Operator - isSamplingPred: false - predicate: (a = 1) (type: boolean) - Statistics: Num rows: 4491 Data size: 17964 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: 1 (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 4491 Data size: 17964 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - GlobalTableId: 0 -#### A masked pattern was here #### - NumFilesPerFileSink: 1 - Statistics: Num rows: 4491 Data size: 17964 Basic stats: COMPLETE Column stats: NONE -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - properties: - columns _col0 - columns.types int - escape.delim \ - hive.serialization.extend.additional.nesting.levels true - serialization.escape.crlf true - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - TotalFiles: 1 - GatherStats: false - MultiFileSpray: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: acidtbldefault - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count 16 - bucket_field_name a - columns a - columns.comments - columns.types int -#### A masked pattern was here #### - name default.acidtbldefault - numFiles 17 - numRows 0 - rawDataSize 0 - serialization.ddl struct acidtbldefault { i32 a} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 35932 - transactional true - transactional_properties default -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - properties: - bucket_count 16 - bucket_field_name a - columns a - columns.comments - columns.types int -#### A masked pattern was here #### - name default.acidtbldefault - numFiles 17 - numRows 0 - rawDataSize 0 - serialization.ddl struct acidtbldefault { i32 a} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde - totalSize 35932 - transactional true - transactional_properties default -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.acidtbldefault - name: default.acidtbldefault - Truncated Path -> Alias: - /acidtbldefault [acidtbldefault] - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out b/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out deleted file mode 100644 index 6f0e46e..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_globallimit.q.out +++ /dev/null @@ -1,52 +0,0 @@ -PREHOOK: query: -- Global Limit optimization does not work with ACID table. Make sure to skip it for ACID table. -CREATE TABLE acidtest1(c1 INT, c2 STRING) -CLUSTERED BY (c1) INTO 3 BUCKETS -STORED AS ORC -TBLPROPERTIES ("transactional"="true") -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acidtest1 -POSTHOOK: query: -- Global Limit optimization does not work with ACID table. Make sure to skip it for ACID table. -CREATE TABLE acidtest1(c1 INT, c2 STRING) -CLUSTERED BY (c1) INTO 3 BUCKETS -STORED AS ORC -TBLPROPERTIES ("transactional"="true") -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acidtest1 -PREHOOK: query: insert into table acidtest1 select cint, cstring1 from alltypesorc where cint is not null order by cint -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acidtest1 -POSTHOOK: query: insert into table acidtest1 select cint, cstring1 from alltypesorc where cint is not null order by cint -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acidtest1 -POSTHOOK: Lineage: acidtest1.c1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acidtest1.c2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select cast (c1 as string) from acidtest1 limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@acidtest1 -#### A masked pattern was here #### -POSTHOOK: query: select cast (c1 as string) from acidtest1 limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acidtest1 -#### A masked pattern was here #### --340178543 --339581189 --339244391 -356535438 --338184935 --338131778 -356416560 -844686816 -355274340 --821957276 -PREHOOK: query: drop table acidtest1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@acidtest1 -PREHOOK: Output: default@acidtest1 -POSTHOOK: query: drop table acidtest1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@acidtest1 -POSTHOOK: Output: default@acidtest1 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_vectorization.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization.q.out deleted file mode 100644 index 1792979..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_vectorization.q.out +++ /dev/null @@ -1,62 +0,0 @@ -PREHOOK: query: CREATE TABLE acid_vectorized(a INT, b STRING) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: CREATE TABLE acid_vectorized(a INT, b STRING) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_vectorized -PREHOOK: query: insert into table acid_vectorized select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: insert into table acid_vectorized select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_vectorized -POSTHOOK: Lineage: acid_vectorized.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_vectorized values (1, 'bar') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: insert into table acid_vectorized values (1, 'bar') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@acid_vectorized -POSTHOOK: Lineage: acid_vectorized.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: update acid_vectorized set b = 'foo' where b = 'bar' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: update acid_vectorized set b = 'foo' where b = 'bar' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -POSTHOOK: Output: default@acid_vectorized -PREHOOK: query: delete from acid_vectorized where b = 'foo' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: delete from acid_vectorized where b = 'foo' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -POSTHOOK: Output: default@acid_vectorized -PREHOOK: query: select a, b from acid_vectorized order by a, b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### -POSTHOOK: query: select a, b from acid_vectorized order by a, b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_vectorization_missing_cols.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization_missing_cols.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization_missing_cols.q.out deleted file mode 100644 index 6acc6e3..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_vectorization_missing_cols.q.out +++ /dev/null @@ -1,56 +0,0 @@ -PREHOOK: query: drop table if exists newtable -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists newtable -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table newtable( - a string, - b int, - c double) -row format delimited -fields terminated by '\t' -stored as textfile -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@newtable -POSTHOOK: query: create table newtable( - a string, - b int, - c double) -row format delimited -fields terminated by '\t' -stored as textfile -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@newtable -PREHOOK: query: drop table if exists newtable_acid -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists newtable_acid -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table newtable_acid (b int, a varchar(50),c decimal(3,2), d int) -clustered by (b) into 2 buckets -stored as orc -tblproperties ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@newtable_acid -POSTHOOK: query: create table newtable_acid (b int, a varchar(50),c decimal(3,2), d int) -clustered by (b) into 2 buckets -stored as orc -tblproperties ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@newtable_acid -PREHOOK: query: insert into newtable_acid(a,b,c) -select * from newtable -PREHOOK: type: QUERY -PREHOOK: Input: default@newtable -PREHOOK: Output: default@newtable_acid -POSTHOOK: query: insert into newtable_acid(a,b,c) -select * from newtable -POSTHOOK: type: QUERY -POSTHOOK: Input: default@newtable -POSTHOOK: Output: default@newtable_acid -POSTHOOK: Lineage: newtable_acid.a EXPRESSION [(newtable)newtable.FieldSchema(name:a, type:string, comment:null), ] -POSTHOOK: Lineage: newtable_acid.b SIMPLE [(newtable)newtable.FieldSchema(name:b, type:int, comment:null), ] -POSTHOOK: Lineage: newtable_acid.c EXPRESSION [(newtable)newtable.FieldSchema(name:c, type:double, comment:null), ] -POSTHOOK: Lineage: newtable_acid.d SIMPLE [] http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out deleted file mode 100644 index f608b10..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_vectorization_partition.q.out +++ /dev/null @@ -1,60 +0,0 @@ -PREHOOK: query: CREATE TABLE acid_vectorized_part(a INT, b STRING) partitioned by (ds string) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_vectorized_part -POSTHOOK: query: CREATE TABLE acid_vectorized_part(a INT, b STRING) partitioned by (ds string) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_vectorized_part -PREHOOK: query: insert into table acid_vectorized_part partition (ds = 'today') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_vectorized_part@ds=today -POSTHOOK: query: insert into table acid_vectorized_part partition (ds = 'today') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_vectorized_part@ds=today -POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=today).b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_vectorized_part partition (ds = 'tomorrow') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_vectorized_part@ds=tomorrow -POSTHOOK: query: insert into table acid_vectorized_part partition (ds = 'tomorrow') select cint, cstring1 from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_vectorized_part@ds=tomorrow -POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_vectorized_part PARTITION(ds=tomorrow).b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_vectorized_part order by a, b, ds -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized_part -PREHOOK: Input: default@acid_vectorized_part@ds=today -PREHOOK: Input: default@acid_vectorized_part@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_vectorized_part order by a, b, ds -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized_part -POSTHOOK: Input: default@acid_vectorized_part@ds=today -POSTHOOK: Input: default@acid_vectorized_part@ds=tomorrow -#### A masked pattern was here #### --1073279343 oj1YrV5Wa today --1073279343 oj1YrV5Wa tomorrow --1073051226 A34p7oRr2WvUJNf today --1073051226 A34p7oRr2WvUJNf tomorrow --1072910839 0iqrc5 today --1072910839 0iqrc5 tomorrow --1072081801 dPkN74F7 today --1072081801 dPkN74F7 tomorrow --1072076362 2uLyD28144vklju213J1mr today --1072076362 2uLyD28144vklju213J1mr tomorrow --1071480828 aw724t8c5558x2xneC624 today --1071480828 aw724t8c5558x2xneC624 tomorrow --1071363017 Anj0oF today --1071363017 Anj0oF tomorrow --1070883071 0ruyd6Y50JpdGRf6HqD today --1070883071 0ruyd6Y50JpdGRf6HqD tomorrow --1070551679 iUR3Q today --1070551679 iUR3Q tomorrow --1069736047 k17Am8uPHWk02cEf1jet today --1069736047 k17Am8uPHWk02cEf1jet tomorrow http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/acid_vectorization_project.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/acid_vectorization_project.q.out b/ql/src/test/results/clientpositive/tez/acid_vectorization_project.q.out deleted file mode 100644 index 1bdacb9..0000000 --- a/ql/src/test/results/clientpositive/tez/acid_vectorization_project.q.out +++ /dev/null @@ -1,73 +0,0 @@ -PREHOOK: query: CREATE TABLE acid_vectorized(a INT, b STRING, c float) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: CREATE TABLE acid_vectorized(a INT, b STRING, c float) CLUSTERED BY(a) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_vectorized -PREHOOK: query: insert into table acid_vectorized select cint, cstring1, cfloat from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_vectorized -POSTHOOK: query: insert into table acid_vectorized select cint, cstring1, cfloat from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_vectorized -POSTHOOK: Lineage: acid_vectorized.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_vectorized.c SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ] -PREHOOK: query: select a,b from acid_vectorized order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_vectorized order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet -PREHOOK: query: select a,c from acid_vectorized order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### -POSTHOOK: query: select a,c from acid_vectorized order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### --1073279343 11.0 --1073051226 NULL --1072910839 11.0 --1072081801 NULL --1072076362 NULL --1071480828 -51.0 --1071363017 8.0 --1070883071 NULL --1070551679 NULL --1069736047 11.0 -PREHOOK: query: select b,c from acid_vectorized order by b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### -POSTHOOK: query: select b,c from acid_vectorized order by b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_vectorized -#### A masked pattern was here #### -0iqrc5 11.0 -0ruyd6Y50JpdGRf6HqD NULL -2uLyD28144vklju213J1mr NULL -A34p7oRr2WvUJNf NULL -Anj0oF 8.0 -aw724t8c5558x2xneC624 -51.0 -dPkN74F7 NULL -iUR3Q NULL -k17Am8uPHWk02cEf1jet 11.0 -oj1YrV5Wa 11.0 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out b/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out deleted file mode 100644 index caa41b2..0000000 --- a/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out +++ /dev/null @@ -1,121 +0,0 @@ -PREHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string, ts string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string, ts string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src_orc_merge_test_part -PREHOOK: query: alter table src_orc_merge_test_part add partition (ds='2012-01-03', ts='2012-01-03+14:46:31') -PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: alter table src_orc_merge_test_part add partition (ds='2012-01-03', ts='2012-01-03+14:46:31') -POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -PREHOOK: query: desc extended src_orc_merge_test_part partition (ds='2012-01-03', ts='2012-01-03+14:46:31') -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: query: desc extended src_orc_merge_test_part partition (ds='2012-01-03', ts='2012-01-03+14:46:31') -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_part -key int -value string -ds string -ts string - -# Partition Information -# col_name data_type comment - -ds string -ts string - -#### A masked pattern was here #### -PREHOOK: query: insert overwrite table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: query: insert overwrite table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value limit 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: query: insert into table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value limit 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: query: insert into table src_orc_merge_test_part partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src order by key, value limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2012-01-03,ts=2012-01-03+14:46:31).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select count(1) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -#### A masked pattern was here #### -610 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -143807 50348357904 -PREHOOK: query: alter table src_orc_merge_test_part partition (ds='2012-01-03', ts='2012-01-03+14:46:31') concatenate -PREHOOK: type: ALTER_PARTITION_MERGE -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -POSTHOOK: query: alter table src_orc_merge_test_part partition (ds='2012-01-03', ts='2012-01-03+14:46:31') concatenate -POSTHOOK: type: ALTER_PARTITION_MERGE -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -PREHOOK: query: select count(1) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -610 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2012-01-03/ts=2012-01-03+14%3A46%3A31 -#### A masked pattern was here #### -143807 50348357904 -PREHOOK: query: drop table src_orc_merge_test_part -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: drop table src_orc_merge_test_part -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out b/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out deleted file mode 100644 index b5a6d04..0000000 --- a/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out +++ /dev/null @@ -1,263 +0,0 @@ -PREHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src_orc_merge_test -PREHOOK: query: insert overwrite table src_orc_merge_test select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: insert overwrite table src_orc_merge_test select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test -POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: insert into table src_orc_merge_test select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test -POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: insert into table src_orc_merge_test select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test -POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: show table extended like `src_orc_merge_test` -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test` -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:false -partitionColumns: -totalNumberFiles:3 -totalFileSize:7545 -maxFileSize:2515 -minFileSize:2515 -#### A masked pattern was here #### - -PREHOOK: query: select count(1) from src_orc_merge_test -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -1500 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -390273 108631194210 -PREHOOK: query: alter table src_orc_merge_test concatenate -PREHOOK: type: ALTER_TABLE_MERGE -PREHOOK: Input: default@src_orc_merge_test -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: alter table src_orc_merge_test concatenate -POSTHOOK: type: ALTER_TABLE_MERGE -POSTHOOK: Input: default@src_orc_merge_test -POSTHOOK: Output: default@src_orc_merge_test -PREHOOK: query: show table extended like `src_orc_merge_test` -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test` -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:false -partitionColumns: -totalNumberFiles:1 -totalFileSize:7198 -maxFileSize:7198 -minFileSize:7198 -#### A masked pattern was here #### - -PREHOOK: query: select count(1) from src_orc_merge_test -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -1500 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test -#### A masked pattern was here #### -390273 108631194210 -PREHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src_orc_merge_test_part -PREHOOK: query: alter table src_orc_merge_test_part add partition (ds='2011') -PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: alter table src_orc_merge_test_part add partition (ds='2011') -POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 -PREHOOK: query: insert overwrite table src_orc_merge_test_part partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: query: insert overwrite table src_orc_merge_test_part partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test_part -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:true -partitionColumns:struct partition_columns { string ds} -totalNumberFiles:3 -totalFileSize:7545 -maxFileSize:2515 -minFileSize:2515 -#### A masked pattern was here #### - -PREHOOK: query: select count(1) from src_orc_merge_test_part -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test_part -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -1500 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -390273 108631194210 -PREHOOK: query: alter table src_orc_merge_test_part partition (ds='2011') concatenate -PREHOOK: type: ALTER_PARTITION_MERGE -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 -POSTHOOK: query: alter table src_orc_merge_test_part partition (ds='2011') concatenate -POSTHOOK: type: ALTER_PARTITION_MERGE -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 -PREHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test_part -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:true -partitionColumns:struct partition_columns { string ds} -totalNumberFiles:1 -totalFileSize:7198 -maxFileSize:7198 -minFileSize:7198 -#### A masked pattern was here #### - -PREHOOK: query: select count(1) from src_orc_merge_test_part -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -POSTHOOK: query: select count(1) from src_orc_merge_test_part -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -1500 -PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 -#### A masked pattern was here #### -390273 108631194210 -PREHOOK: query: drop table src_orc_merge_test -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_orc_merge_test -PREHOOK: Output: default@src_orc_merge_test -POSTHOOK: query: drop table src_orc_merge_test -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_orc_merge_test -POSTHOOK: Output: default@src_orc_merge_test -PREHOOK: query: drop table src_orc_merge_test_part -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_orc_merge_test_part -PREHOOK: Output: default@src_orc_merge_test_part -POSTHOOK: query: drop table src_orc_merge_test_part -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_orc_merge_test_part -POSTHOOK: Output: default@src_orc_merge_test_part http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out b/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out deleted file mode 100644 index 0d5ba01..0000000 --- a/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out +++ /dev/null @@ -1,382 +0,0 @@ -PREHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src_orc_merge_test_stat -PREHOOK: query: insert overwrite table src_orc_merge_test_stat select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: insert overwrite table src_orc_merge_test_stat select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_stat select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: insert into table src_orc_merge_test_stat select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_stat select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: insert into table src_orc_merge_test_stat select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: show table extended like `src_orc_merge_test_stat` -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test_stat` -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test_stat -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:false -partitionColumns: -totalNumberFiles:3 -totalFileSize:7545 -maxFileSize:2515 -minFileSize:2515 -#### A masked pattern was here #### - -PREHOOK: query: desc extended src_orc_merge_test_stat -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: query: desc extended src_orc_merge_test_stat -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_stat -key int -value string - -#### A masked pattern was here #### -PREHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_stat -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: Output: default@src_orc_merge_test_stat -PREHOOK: query: desc formatted src_orc_merge_test_stat -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: query: desc formatted src_orc_merge_test_stat -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_stat -# col_name data_type comment - -key int -value string - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 3 - numRows 1500 - rawDataSize 141000 - totalSize 7545 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: alter table src_orc_merge_test_stat concatenate -PREHOOK: type: ALTER_TABLE_MERGE -PREHOOK: Input: default@src_orc_merge_test_stat -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: alter table src_orc_merge_test_stat concatenate -POSTHOOK: type: ALTER_TABLE_MERGE -POSTHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: Output: default@src_orc_merge_test_stat -PREHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_stat -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: Output: default@src_orc_merge_test_stat -PREHOOK: query: desc formatted src_orc_merge_test_stat -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: query: desc formatted src_orc_merge_test_stat -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_stat -# col_name data_type comment - -key int -value string - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 1 - numRows 1500 - rawDataSize 141000 - totalSize 7198 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src_orc_merge_test_part_stat -PREHOOK: query: alter table src_orc_merge_test_part_stat add partition (ds='2011') -PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: query: alter table src_orc_merge_test_part_stat add partition (ds='2011') -POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -PREHOOK: query: insert overwrite table src_orc_merge_test_part_stat partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: insert overwrite table src_orc_merge_test_part_stat partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: show table extended like `src_orc_merge_test_part_stat` partition (ds='2011') -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like `src_orc_merge_test_part_stat` partition (ds='2011') -POSTHOOK: type: SHOW_TABLESTATUS -tableName:src_orc_merge_test_part_stat -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 key, string value} -partitioned:true -partitionColumns:struct partition_columns { string ds} -totalNumberFiles:3 -totalFileSize:7545 -maxFileSize:2515 -minFileSize:2515 -#### A masked pattern was here #### - -PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_part_stat -# col_name data_type comment - -key int -value string - -# Partition Information -# col_name data_type comment - -ds string - -# Detailed Partition Information -Partition Value: [2011] -Database: default -Table: src_orc_merge_test_part_stat -#### A masked pattern was here #### -Partition Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 3 - numRows 1500 - rawDataSize 141000 - totalSize 7545 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_part_stat -# col_name data_type comment - -key int -value string - -# Partition Information -# col_name data_type comment - -ds string - -# Detailed Partition Information -Partition Value: [2011] -Database: default -Table: src_orc_merge_test_part_stat -#### A masked pattern was here #### -Partition Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 3 - numRows 1500 - rawDataSize 141000 - totalSize 7545 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: alter table src_orc_merge_test_part_stat partition (ds='2011') concatenate -PREHOOK: type: ALTER_PARTITION_MERGE -PREHOOK: Input: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: alter table src_orc_merge_test_part_stat partition (ds='2011') concatenate -POSTHOOK: type: ALTER_PARTITION_MERGE -POSTHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -PREHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan -PREHOOK: type: QUERY -PREHOOK: Input: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -POSTHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 -PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src_orc_merge_test_part_stat -# col_name data_type comment - -key int -value string - -# Partition Information -# col_name data_type comment - -ds string - -# Detailed Partition Information -Partition Value: [2011] -Database: default -Table: src_orc_merge_test_part_stat -#### A masked pattern was here #### -Partition Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - numFiles 1 - numRows 1500 - rawDataSize 141000 - totalSize 7198 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -PREHOOK: query: drop table src_orc_merge_test_stat -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_orc_merge_test_stat -PREHOOK: Output: default@src_orc_merge_test_stat -POSTHOOK: query: drop table src_orc_merge_test_stat -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_orc_merge_test_stat -POSTHOOK: Output: default@src_orc_merge_test_stat -PREHOOK: query: drop table src_orc_merge_test_part_stat -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_orc_merge_test_part_stat -PREHOOK: Output: default@src_orc_merge_test_part_stat -POSTHOOK: query: drop table src_orc_merge_test_part_stat -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_orc_merge_test_part_stat -POSTHOOK: Output: default@src_orc_merge_test_part_stat
