You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by Miklos Gergely <mg...@hortonworks.com> on 2020/04/22 20:46:20 UTC

Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/
-----------------------------------------------------------

Review request for hive.


Bugs: HIVE-23274
    https://issues.apache.org/jira/browse/HIVE-23274


Repository: hive-git


Description
-------

Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1


Diffs
-----

  ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
  ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
  ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
  ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
  ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
  ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
  ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
  ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
  ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
  ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
  ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
  ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
  ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
  ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
  ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
  ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
  ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
  ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
  ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
  ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
  ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
  ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
  ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
  ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
  ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
  ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
  ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
  ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
  ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
  ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
  ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
  ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
  ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
  ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
  ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
  ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
  ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
  ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
  ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
  ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
  ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
  ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
  ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
  ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
  ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
  ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
  ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
  ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
  ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
  ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
  ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
  ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
  ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
  ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
  ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
  ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
  ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
  ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
  ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
  ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
  ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
  ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
  ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
  ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
  ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
  ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
  ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
  ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
  ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
  ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
  ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
  ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
  ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
  ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
  ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
  ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
  ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
  ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
  ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
  ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
  ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
  ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
  ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
  ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
  ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
  ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
  ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
  ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
  ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
  ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
  ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
  ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
  ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
  ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
  ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
  ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
  ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
  ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
  ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
  ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
  ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
  ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
  ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
  ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
  ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
  ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
  ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
  ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
  ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
  ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
  ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
  ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
  ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
  ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
  ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
  ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
  ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
  ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
  ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
  ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
  ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
  ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
  ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
  ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
  ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
  ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
  ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
  ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
  ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
  ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
  ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
  ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
  ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
  ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
  ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
  ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
  ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
  ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
  ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
  ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
  ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
  ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
  ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
  ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
  ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
  ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
  ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
  ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
  ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
  ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
  ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
  ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
  ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
  ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
  ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
  ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
  ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
  ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
  ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
  ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
  ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
  ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
  ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
  ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
  ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
  ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
  ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
  ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
  ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
  ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
  ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
  ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
  ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
  ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
  ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
  ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
  ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
  ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
  ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
  ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
  ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
  ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
  ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
  ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
  ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
  ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
  ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
  ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
  ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
  ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
  ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
  ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
  ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
  ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
  ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
  ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
  ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
  ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
  ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
  ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
  ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
  ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
  ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
  ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
  ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
  ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
  ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
  ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
  ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
  ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
  ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
  ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
  ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
  ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
  ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
  ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
  ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
  ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
  ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
  ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
  ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
  ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
  ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
  ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
  ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
  ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
  ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
  ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
  ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
  ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
  ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
  ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
  ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
  ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
  ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
  ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
  ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
  ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
  ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
  ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
  ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
  ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
  ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
  ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
  ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
  ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
  ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
  ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
  ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
  ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
  ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
  ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
  ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
  ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
  ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
  ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
  ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
  ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
  ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
  ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
  ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
  ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
  ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
  ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
  ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
  ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
  ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
  ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
  ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
  ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
  ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
  ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
  ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
  ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
  ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
  ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
  ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
  ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
  ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
  ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 


Diff: https://reviews.apache.org/r/72421/diff/1/


Testing
-------


Thanks,

Miklos Gergely

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Miklos Gergely <mg...@hortonworks.com>.


> On April 23, 2020, 3:22 p.m., Zoltan Haindrich wrote:
> > ql/src/test/results/clientpositive/llap/constantfolding.q.out
> > Line 201 (original)
> > <https://reviews.apache.org/r/72421/diff/1/?file=2227170#file2227170line201>
> >
> >     this is weird - where these have gone!? :D
> >     
> >     In HIVE-21304 I see Statistics rows appear magically...

https://github.com/apache/hive/blob/014dafcd7ac4260f7038f969d7c8218682029b86/ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java#L217 this is the reason why statistics are disappearing. The executioin engine is TEZ now.


- Miklos


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220457
-----------------------------------------------------------


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Zoltan Haindrich <ki...@rxd.hu>.

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220457
-----------------------------------------------------------




ql/src/test/results/clientpositive/llap/acid_nullscan.q.out
Line 63 (original), 69 (patched)
<https://reviews.apache.org/r/72421/#comment308835>

    is this change expected?



ql/src/test/results/clientpositive/llap/acid_stats2.q.out
Line 647 (original), 647 (patched)
<https://reviews.apache.org/r/72421/#comment308836>

    I'm wondering why llap writes files with a different size...



ql/src/test/results/clientpositive/llap/constantfolding.q.out
Line 201 (original)
<https://reviews.apache.org/r/72421/#comment308837>

    this is weird - where these have gone!? :D
    
    In HIVE-21304 I see Statistics rows appear magically...



ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out
Lines 287 (patched)
<https://reviews.apache.org/r/72421/#comment308843>

    earlier we had the GBY in `complete` mode ; right now it seems like its doing the full job...
    
    I wonder why ReducesinkDedup haven't kicked in...



ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out
Lines 1464 (patched)
<https://reviews.apache.org/r/72421/#comment308844>

    resultset change - is this expected?



ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out
Line 485 (original), 398 (patched)
<https://reviews.apache.org/r/72421/#comment308846>

    minRed goes to 0.0



ql/src/test/results/clientpositive/llap/cp_sel.q.out
Line 232 (original), 250 (patched)
<https://reviews.apache.org/r/72421/#comment308847>

    resultset change: seems like the query doesn't have an order defined but it has a limit



ql/src/test/results/clientpositive/llap/database_location.q.out
Line 13 (original), 13 (patched)
<https://reviews.apache.org/r/72421/#comment308848>

    what is the differenece here?
    `\r`? do we have rules about keeping '\r' -s ?
    
    or this is just too much for the "reviewboard?" :D



ql/src/test/results/clientpositive/llap/decimal_precision2.q.out
Line 20 (original)
<https://reviews.apache.org/r/72421/#comment308849>

    statistics rows disappearing...



ql/src/test/results/clientpositive/llap/decimal_udf.q.out
Lines 1979 (patched)
<https://reviews.apache.org/r/72421/#comment308850>

    resultset change!
    since the query doesn't have limit or anything like that - this could be a serious issue



ql/src/test/results/clientpositive/llap/decimal_udf.q.out
Lines 2076 (patched)
<https://reviews.apache.org/r/72421/#comment308851>

    resultest change


- Zoltan Haindrich


On April 22, 2020, 10:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 10:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Miklos Gergely <mg...@hortonworks.com>.


> On April 23, 2020, 4:16 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/alias_casted_column.q.out
> > Line 19 (original)
> > <https://reviews.apache.org/r/72421/diff/1/?file=2227017#file2227017line20>
> >
> >     Stats are gone. Is this expected since FetchOptimizer kicked in (we can verify with other q files where fetch optimization is applied).

https://github.com/apache/hive/blob/014dafcd7ac4260f7038f969d7c8218682029b86/ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java#L217 this is the reason why statistics are disappearing. The executioin engine is TEZ now.


- Miklos


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220460
-----------------------------------------------------------


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.


> On April 23, 2020, 4:16 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/alias_casted_column.q.out
> > Line 19 (original)
> > <https://reviews.apache.org/r/72421/diff/1/?file=2227017#file2227017line20>
> >
> >     Stats are gone. Is this expected since FetchOptimizer kicked in (we can verify with other q files where fetch optimization is applied).
> 
> Miklos Gergely wrote:
>     https://github.com/apache/hive/blob/014dafcd7ac4260f7038f969d7c8218682029b86/ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java#L217 this is the reason why statistics are disappearing. The executioin engine is TEZ now.

I guess this is done for latency (no need to annotate with stats in this case), which makes sense.
If we wanted to print them, we could always add a check on whether we are running on test mode or not. However, I do not see any value on printing them...  Thoughts? Zoltan, Vineet?


- Jesús


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220460
-----------------------------------------------------------


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220460
-----------------------------------------------------------




ql/src/test/results/clientpositive/llap/alias_casted_column.q.out
Line 19 (original)
<https://reviews.apache.org/r/72421/#comment308838>

    Stats are gone. Is this expected since FetchOptimizer kicked in (we can verify with other q files where fetch optimization is applied).



ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out
Line 22 (original)
<https://reviews.apache.org/r/72421/#comment308839>

    Same as above, stats are gone. It may be because fetch optimization kicked in. We would just need to verify that.



ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out
Line 357 (original)
<https://reviews.apache.org/r/72421/#comment308840>

    Stats are gone. But here plan has not changed.



ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out
Line 66 (original)
<https://reviews.apache.org/r/72421/#comment308842>

    Maybe we want to add `order by key` to have same order as before (and some kind of determinism, this looks like a test that may become flaky).



ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out
Lines 1777 (patched)
<https://reviews.apache.org/r/72421/#comment308853>

    SJ reduction... cool! :)



ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out
Line 83 (original)
<https://reviews.apache.org/r/72421/#comment308854>

    Same as with my previous comments... Stats dissapear. This is an issue all over, at least in this block of tests. I think we should still print the stats in this case and those above, this looks like a bug. Let's create a follow-up JIRA.



ql/src/test/results/clientpositive/llap/authorization_9.q.out
Lines 58 (patched)
<https://reviews.apache.org/r/72421/#comment308855>

    There are additional grants. Why is this different? Does it have to do with the tests(driver) setup?



ql/src/test/results/clientpositive/llap/authorization_view_1.q.out
Line 224 (original), 224 (patched)
<https://reviews.apache.org/r/72421/#comment308856>

    add `order by key` to have determinism?



ql/src/test/results/clientpositive/llap/authorization_view_1.q.out
Line 252 (original), 252 (patched)
<https://reviews.apache.org/r/72421/#comment308858>

    add `order by`?



ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out
Line 224 (original), 224 (patched)
<https://reviews.apache.org/r/72421/#comment308859>

    `order by`?



ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out
Line 252 (original), 252 (patched)
<https://reviews.apache.org/r/72421/#comment308860>

    `order by`?



ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out
Line 296 (original)
<https://reviews.apache.org/r/72421/#comment308861>

    `order by`?


- Jesús Camacho Rodríguez


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Miklos Gergely <mg...@hortonworks.com>.

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220469
-----------------------------------------------------------




ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out
Line 180 (original)
<https://reviews.apache.org/r/72421/#comment308875>

    Statstics are gone, as the execution engine is no longer MR.



ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out
Line 73 (original)
<https://reviews.apache.org/r/72421/#comment308876>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out
Line 765 (original)
<https://reviews.apache.org/r/72421/#comment308877>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out
Line 307 (original), 307 (patched)
<https://reviews.apache.org/r/72421/#comment308878>

    This output should not have changed, there is a bug here (or in the original). Multiple cases of the same issue in this q fle.



ql/src/test/results/clientpositive/llap/char_serde.q.out
Line 65 (original), 65 (patched)
<https://reviews.apache.org/r/72421/#comment308879>

    Order by is required to ensure deterministic result. Multiple cases of the same thing in this q file.



ql/src/test/results/clientpositive/llap/char_udf1.q.out
Line 43 (original), 43 (patched)
<https://reviews.apache.org/r/72421/#comment308880>

    White space changes in the result formattinig. Multiple instances of the same issue in this q file. Actually I believe it was fixed, with TestMiniLlapLocalCliDriver they are all tabs, while before it was a mixture of tabs and spaces.



ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out
Line 42 (original)
<https://reviews.apache.org/r/72421/#comment308881>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out
Line 625 (original), 665 (patched)
<https://reviews.apache.org/r/72421/#comment308882>

    Result has changed, it's a bug (or it was a bug before). Multiple instances of the same issue are in this q file.



ql/src/test/results/clientpositive/llap/combine2.q.out
Line 101 (original)
<https://reviews.apache.org/r/72421/#comment308883>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/complex_alias.q.out
Line 189 (original)
<https://reviews.apache.org/r/72421/#comment308884>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/concat_op.q.out
Line 19 (original)
<https://reviews.apache.org/r/72421/#comment308885>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/constantPropWhen.q.out
Line 41 (original)
<https://reviews.apache.org/r/72421/#comment308886>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/constant_prop.q.out
Line 38 (original)
<https://reviews.apache.org/r/72421/#comment308887>

    Statistics are gone.



ql/src/test/results/clientpositive/llap/constant_prop_1.q.out
Line 29 (original)
<https://reviews.apache.org/r/72421/#comment308888>

    Statistics are gone.


- Miklos Gergely


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>

Re: Review Request 72421: Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1

Posted by Steve Carlin via Review Board <no...@reviews.apache.org>.

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72421/#review220464
-----------------------------------------------------------




ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out
Line 183 (original), 164 (patched)
<https://reviews.apache.org/r/72421/#comment308865>

    not sure what to make of this



ql/src/test/results/clientpositive/llap/auto_join19.q.out
Line 70 (original), 52 (patched)
<https://reviews.apache.org/r/72421/#comment308864>

    Not sure what to make of this



ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out
Line 70 (original), 52 (patched)
<https://reviews.apache.org/r/72421/#comment308866>

    same, not sure what to make of this



ql/src/test/results/clientpositive/llap/auto_join2.q.out
Lines 114 (patched)
<https://reviews.apache.org/r/72421/#comment308867>

    Is this ok?



ql/src/test/results/clientpositive/llap/auto_join20.q.out
Lines 60 (patched)
<https://reviews.apache.org/r/72421/#comment308868>

    Is this ok?



ql/src/test/results/clientpositive/llap/auto_join25.q.out
Line 68 (original)
<https://reviews.apache.org/r/72421/#comment308869>

    I assume this is a good thing, right?



ql/src/test/results/clientpositive/llap/auto_join27.q.out
Line 170 (original), 175 (patched)
<https://reviews.apache.org/r/72421/#comment308870>

    Can you have a look at this one?


- Steve Carlin


On April 22, 2020, 8:46 p.m., Miklos Gergely wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72421/
> -----------------------------------------------------------
> 
> (Updated April 22, 2020, 8:46 p.m.)
> 
> 
> Review request for hive.
> 
> 
> Bugs: HIVE-23274
>     https://issues.apache.org/jira/browse/HIVE-23274
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Move q tests to TestMiniLlapLocal from TestCliDriver where the output is different, batch 1
> 
> 
> Diffs
> -----
> 
>   ql/src/test/results/clientpositive/llap/acid_mapjoin.q.out f66e978a01 
>   ql/src/test/results/clientpositive/llap/acid_nullscan.q.out 0e5c2418d0 
>   ql/src/test/results/clientpositive/llap/acid_stats2.q.out 45c903fb87 
>   ql/src/test/results/clientpositive/llap/acid_stats3.q.out f9b0c57522 
>   ql/src/test/results/clientpositive/llap/acid_stats4.q.out 279701d786 
>   ql/src/test/results/clientpositive/llap/acid_stats5.q.out 4ae023fc4e 
>   ql/src/test/results/clientpositive/llap/acid_table_stats.q.out c4bc80ee12 
>   ql/src/test/results/clientpositive/llap/acid_view_delete.q.out a1de850a17 
>   ql/src/test/results/clientpositive/llap/alias_casted_column.q.out 7a6620c799 
>   ql/src/test/results/clientpositive/llap/allcolref_in_udf.q.out 87713544f5 
>   ql/src/test/results/clientpositive/llap/alterColumnStatsPart.q.out fe17d00211 
>   ql/src/test/results/clientpositive/llap/alter_change_db_location.q.out 4c2115334b 
>   ql/src/test/results/clientpositive/llap/alter_db_owner.q.out a6118f279a 
>   ql/src/test/results/clientpositive/llap/alter_partition_coltype.q.out 183cc4f8be 
>   ql/src/test/results/clientpositive/llap/ambiguitycheck.q.out 3de3d68118 
>   ql/src/test/results/clientpositive/llap/ambiguous_col.q.out bcc36a936b 
>   ql/src/test/results/clientpositive/llap/analyze_table_null_partition.q.out ab05bd9f1a 
>   ql/src/test/results/clientpositive/llap/analyze_tbl_date.q.out 9ce5f589ce 
>   ql/src/test/results/clientpositive/llap/annotate_stats_deep_filters.q.out e721eacdcc 
>   ql/src/test/results/clientpositive/llap/annotate_stats_filter.q.out 6f8fad3971 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby.q.out 4443a0e079 
>   ql/src/test/results/clientpositive/llap/annotate_stats_groupby2.q.out e604e13ee8 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join.q.out f054af2a24 
>   ql/src/test/results/clientpositive/llap/annotate_stats_join_pkfk.q.out 21a1b12feb 
>   ql/src/test/results/clientpositive/llap/annotate_stats_limit.q.out ec1dc8bb25 
>   ql/src/test/results/clientpositive/llap/annotate_stats_part.q.out 31fa1426a2 
>   ql/src/test/results/clientpositive/llap/annotate_stats_select.q.out dba27998a4 
>   ql/src/test/results/clientpositive/llap/annotate_stats_table.q.out 9b9e31b214 
>   ql/src/test/results/clientpositive/llap/annotate_stats_udtf.q.out c094fc1fea 
>   ql/src/test/results/clientpositive/llap/annotate_stats_union.q.out 92108f21b3 
>   ql/src/test/results/clientpositive/llap/ansi_sql_arithmetic.q.out 4760e986e1 
>   ql/src/test/results/clientpositive/llap/array_map_access_nonconstant.q.out 528e98ffe4 
>   ql/src/test/results/clientpositive/llap/array_size_estimation.q.out 00166721ef 
>   ql/src/test/results/clientpositive/llap/authorization_9.q.out 5a22a8879a 
>   ql/src/test/results/clientpositive/llap/authorization_explain.q.out 61551f4ecb 
>   ql/src/test/results/clientpositive/llap/authorization_owner_actions_db.q.out bc4805143f 
>   ql/src/test/results/clientpositive/llap/authorization_view_1.q.out eac3fdcedd 
>   ql/src/test/results/clientpositive/llap/authorization_view_disable_cbo_1.q.out 0b50d93acf 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_11.q.out c7a97865e8 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_4.q.out a9b5ad0c48 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5.q.out 01793458a5 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_5a.q.out 4bc9df4b80 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_7.q.out 902a48fb4e 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_8.q.out de7352c36d 
>   ql/src/test/results/clientpositive/llap/autoColumnStats_9.q.out 0d3eb2cf7c 
>   ql/src/test/results/clientpositive/llap/auto_join10.q.out 3f750166ef 
>   ql/src/test/results/clientpositive/llap/auto_join11.q.out 6cdfa34d5e 
>   ql/src/test/results/clientpositive/llap/auto_join12.q.out 60a8f4732f 
>   ql/src/test/results/clientpositive/llap/auto_join13.q.out 5f83b393fe 
>   ql/src/test/results/clientpositive/llap/auto_join14.q.out 238befeb5c 
>   ql/src/test/results/clientpositive/llap/auto_join15.q.out 15fa1d263d 
>   ql/src/test/results/clientpositive/llap/auto_join16.q.out f13105665c 
>   ql/src/test/results/clientpositive/llap/auto_join17.q.out 88185e790c 
>   ql/src/test/results/clientpositive/llap/auto_join18.q.out 0473494c2a 
>   ql/src/test/results/clientpositive/llap/auto_join18_multi_distinct.q.out 961a320982 
>   ql/src/test/results/clientpositive/llap/auto_join19.q.out cad3e0971e 
>   ql/src/test/results/clientpositive/llap/auto_join19_inclause.q.out f42743a39f 
>   ql/src/test/results/clientpositive/llap/auto_join2.q.out c694679e6f 
>   ql/src/test/results/clientpositive/llap/auto_join20.q.out 6475ad2ee0 
>   ql/src/test/results/clientpositive/llap/auto_join22.q.out 5a98716fed 
>   ql/src/test/results/clientpositive/llap/auto_join23.q.out e91161ad5c 
>   ql/src/test/results/clientpositive/llap/auto_join24.q.out 56168c3c48 
>   ql/src/test/results/clientpositive/llap/auto_join25.q.out 11288ff31f 
>   ql/src/test/results/clientpositive/llap/auto_join26.q.out dcd65a0e72 
>   ql/src/test/results/clientpositive/llap/auto_join27.q.out 52d41bb6fb 
>   ql/src/test/results/clientpositive/llap/auto_join28.q.out e64539efd4 
>   ql/src/test/results/clientpositive/llap/auto_join3.q.out 7029bc4178 
>   ql/src/test/results/clientpositive/llap/auto_join31.q.out 0c0e474220 
>   ql/src/test/results/clientpositive/llap/auto_join32.q.out f215592bac 
>   ql/src/test/results/clientpositive/llap/auto_join33.q.out fb6ddab51e 
>   ql/src/test/results/clientpositive/llap/auto_join4.q.out 675dac765a 
>   ql/src/test/results/clientpositive/llap/auto_join5.q.out 6da8d4aab4 
>   ql/src/test/results/clientpositive/llap/auto_join6.q.out 8996b2d6c5 
>   ql/src/test/results/clientpositive/llap/auto_join7.q.out 83a46056b2 
>   ql/src/test/results/clientpositive/llap/auto_join8.q.out 5879fbc74b 
>   ql/src/test/results/clientpositive/llap/auto_join9.q.out 41a7bc23dd 
>   ql/src/test/results/clientpositive/llap/auto_join_reordering_values.q.out 0378c65eae 
>   ql/src/test/results/clientpositive/llap/auto_join_stats.q.out d2ca52f75b 
>   ql/src/test/results/clientpositive/llap/auto_join_stats2.q.out 235a2bacc5 
>   ql/src/test/results/clientpositive/llap/auto_join_without_localtask.q.out d64581c66c 
>   ql/src/test/results/clientpositive/llap/avro_date.q.out ff969a1ffe 
>   ql/src/test/results/clientpositive/llap/avro_schema_evolution_native.q.out cd401becad 
>   ql/src/test/results/clientpositive/llap/avro_timestamp.q.out 0ac216a180 
>   ql/src/test/results/clientpositive/llap/avrotblsjoin.q.out 3e6969abb8 
>   ql/src/test/results/clientpositive/llap/binarysortable_1.q.out 29faaf3f3a 
>   ql/src/test/results/clientpositive/llap/bool_unknown.q.out 8e9b48ccaf 
>   ql/src/test/results/clientpositive/llap/bucket1.q.out 6e8965ff79 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_1.q.out 98c0aa41ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_2.q.out 01d0999157 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark1.q.out 8006d5c5b5 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark2.q.out 23d704a3ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark3.q.out 5d59a53bd3 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_spark4.q.out 5bf5c1e24c 
>   ql/src/test/results/clientpositive/llap/bucketcontext_1.q.out b136f293a7 
>   ql/src/test/results/clientpositive/llap/bucketcontext_2.q.out 139b04bd18 
>   ql/src/test/results/clientpositive/llap/bucketcontext_3.q.out dbe68ee125 
>   ql/src/test/results/clientpositive/llap/bucketcontext_4.q.out 0cc4d7e9fa 
>   ql/src/test/results/clientpositive/llap/bucketcontext_5.q.out 25f89a89d0 
>   ql/src/test/results/clientpositive/llap/bucketcontext_6.q.out 0a5baeba6d 
>   ql/src/test/results/clientpositive/llap/bucketcontext_7.q.out 734dd0f3b2 
>   ql/src/test/results/clientpositive/llap/bucketcontext_8.q.out 8260858cd7 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin10.q.out fcf056d8cf 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin11.q.out 7032fb59ce 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin12.q.out 2ef7cb7789 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin13.q.out b6e55b3c33 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin5.q.out 5ada6e73b2 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin8.q.out 5c0ac98fd5 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin9.q.out 61be706611 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative.q.out cb9d5d04d4 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative2.q.out b5aceed3ef 
>   ql/src/test/results/clientpositive/llap/bucketmapjoin_negative3.q.out 7b2176a283 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_1.q.out 6b4ac4cdbc 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_3.q.out 0c7826a7a1 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_4.q.out eda8215d4c 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_5.q.out 9208b93482 
>   ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_8.q.out d5d7f4b391 
>   ql/src/test/results/clientpositive/llap/case_sensitivity.q.out fdcf86b1da 
>   ql/src/test/results/clientpositive/llap/cast1.q.out c4e76f59ec 
>   ql/src/test/results/clientpositive/llap/cast_datetime_with_sql_2016_format.q.out f245121c48 
>   ql/src/test/results/clientpositive/llap/cast_on_constant.q.out 0279796f03 
>   ql/src/test/results/clientpositive/llap/cbo_SortUnionTransposeRule.q.out 68a885026c 
>   ql/src/test/results/clientpositive/llap/cbo_const.q.out 33e6f97f2d 
>   ql/src/test/results/clientpositive/llap/cbo_input26.q.out 770583505d 
>   ql/src/test/results/clientpositive/llap/cbo_ppd_non_deterministic.q.out d90ce88bf0 
>   ql/src/test/results/clientpositive/llap/cbo_rp_annotate_stats_groupby.q.out 8aeafc2c8e 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join0.q.out 0035b52311 
>   ql/src/test/results/clientpositive/llap/cbo_rp_auto_join17.q.out 2e037fdee9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_cross_product_check_2.q.out f445ba3d3d 
>   ql/src/test/results/clientpositive/llap/cbo_rp_gby2_map_multi_distinct.q.out c813456373 
>   ql/src/test/results/clientpositive/llap/cbo_rp_groupby3_noskew_multi_distinct.q.out c1e30130b9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join0.q.out aca2f517d9 
>   ql/src/test/results/clientpositive/llap/cbo_rp_join1.q.out d75b040e4f 
>   ql/src/test/results/clientpositive/llap/cbo_rp_outer_join_ppr.q.out 5bb0f03875 
>   ql/src/test/results/clientpositive/llap/cbo_rp_simple_select.q.out 5ca758efe2 
>   ql/src/test/results/clientpositive/llap/cbo_rp_udaf_percentile_approx_23.q.out 893f689d85 
>   ql/src/test/results/clientpositive/llap/cbo_stats_estimation.q.out 389a9bc1cc 
>   ql/src/test/results/clientpositive/llap/cbo_union_view.q.out 4d2e28ca04 
>   ql/src/test/results/clientpositive/llap/char_serde.q.out 03213b64b7 
>   ql/src/test/results/clientpositive/llap/char_udf1.q.out a2b4bed275 
>   ql/src/test/results/clientpositive/llap/clusterctas.q.out 9d76bc5903 
>   ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_2.q.out ac2e48f54c 
>   ql/src/test/results/clientpositive/llap/column_pruner_multiple_children.q.out b72c13ad22 
>   ql/src/test/results/clientpositive/llap/column_pruning_partitioned_view.q.out e9c0d424f0 
>   ql/src/test/results/clientpositive/llap/columnarserde_create_shortcut.q.out 09ebed0c0a 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl.q.out f12577c3c2 
>   ql/src/test/results/clientpositive/llap/columnstats_partlvl_dp.q.out e2946a227e 
>   ql/src/test/results/clientpositive/llap/columnstats_quoting.q.out 222c0478ca 
>   ql/src/test/results/clientpositive/llap/columnstats_tbllvl.q.out f22d15c2d3 
>   ql/src/test/results/clientpositive/llap/combine2.q.out 8e4a92be36 
>   ql/src/test/results/clientpositive/llap/comments.q.out b94e2cea49 
>   ql/src/test/results/clientpositive/llap/complex_alias.q.out e8cdc218ed 
>   ql/src/test/results/clientpositive/llap/compute_stats_date.q.out fe36adb1cd 
>   ql/src/test/results/clientpositive/llap/concat_op.q.out 4442658387 
>   ql/src/test/results/clientpositive/llap/constGby.q.out dc2ecdced0 
>   ql/src/test/results/clientpositive/llap/constantPropWhen.q.out 3c42b68e9f 
>   ql/src/test/results/clientpositive/llap/constantPropagateForSubQuery.q.out 34502947c3 
>   ql/src/test/results/clientpositive/llap/constant_prop.q.out 43dfac86f1 
>   ql/src/test/results/clientpositive/llap/constant_prop_1.q.out 5b7cd95e7d 
>   ql/src/test/results/clientpositive/llap/constant_prop_2.q.out 5b30263bf7 
>   ql/src/test/results/clientpositive/llap/constant_prop_3.q.out 6c47f613d1 
>   ql/src/test/results/clientpositive/llap/constant_prop_timestamp_date_cast.q.out cf04d306a3 
>   ql/src/test/results/clientpositive/llap/constantfolding.q.out 3a44344ceb 
>   ql/src/test/results/clientpositive/llap/constprog1.q.out 937b9ecb77 
>   ql/src/test/results/clientpositive/llap/constprog2.q.out b1d99e404d 
>   ql/src/test/results/clientpositive/llap/constprog3.q.out b4d2e05a05 
>   ql/src/test/results/clientpositive/llap/constprog_dp.q.out e3f74c2f06 
>   ql/src/test/results/clientpositive/llap/constprog_partitioner.q.out 13934fb4a6 
>   ql/src/test/results/clientpositive/llap/constprog_type.q.out 66711dfbae 
>   ql/src/test/results/clientpositive/llap/constprog_when_case.q.out 8d3dd98e6d 
>   ql/src/test/results/clientpositive/llap/correlated_join_keys.q.out 3fccaff67b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer10.q.out 3da383f2b0 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer11.q.out b2c4c6f187 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer12.q.out 713fb63fdf 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer13.q.out 1930687207 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer14.q.out 2962ea9a7b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer15.q.out 607b617da1 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer5.q.out 2e9e6027ae 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer7.q.out bd0f301a4b 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer8.q.out c9c1e921b2 
>   ql/src/test/results/clientpositive/llap/correlationoptimizer9.q.out 20a0bc08b6 
>   ql/src/test/results/clientpositive/llap/cp_sel.q.out 471ff8067c 
>   ql/src/test/results/clientpositive/llap/create_view_disable_cbo.q.out 800d2fc149 
>   ql/src/test/results/clientpositive/llap/cross_join_merge.q.out 54e68cce20 
>   ql/src/test/results/clientpositive/llap/ctas_colname.q.out 213a80986a 
>   ql/src/test/results/clientpositive/llap/ctas_uses_database_location.q.out a497af69e9 
>   ql/src/test/results/clientpositive/llap/cte_6.q.out f5bc5606d2 
>   ql/src/test/results/clientpositive/llap/cte_join.q.out 4211b8b1b9 
>   ql/src/test/results/clientpositive/llap/database_location.q.out f0567076a7 
>   ql/src/test/results/clientpositive/llap/database_properties.q.out 5b0c85734a 
>   ql/src/test/results/clientpositive/llap/date_2.q.out 402dae8e05 
>   ql/src/test/results/clientpositive/llap/date_serde.q.out f3985b0bf2 
>   ql/src/test/results/clientpositive/llap/db_ddl_explain.q.out ae8982c5e7 
>   ql/src/test/results/clientpositive/llap/decimal_join2.q.out 59d0672132 
>   ql/src/test/results/clientpositive/llap/decimal_precision.q.out 8aea2dca3f 
>   ql/src/test/results/clientpositive/llap/decimal_precision2.q.out 3cba039026 
>   ql/src/test/results/clientpositive/llap/decimal_stats.q.out 0571fae33d 
>   ql/src/test/results/clientpositive/llap/decimal_udf.q.out f00ef023e4 
>   ql/src/test/results/clientpositive/llap/decimal_udf2.q.out eb98a07c8e 
>   ql/src/test/results/clientpositive/llap/describe_database.q.out 8d1e44a851 
>   ql/src/test/results/clientpositive/llap/display_colstats_tbllvl.q.out ca7ce6f0e4 
>   ql/src/test/results/clientpositive/llap/distinct_groupby.q.out b5c49770cb 
>   ql/src/test/results/clientpositive/llap/distinct_stats.q.out c1ebfc3d57 
>   ql/src/test/results/clientpositive/llap/distinct_windowing.q.out 9fefb501b8 
>   ql/src/test/results/clientpositive/llap/distinct_windowing_no_cbo.q.out b08dd014c4 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_insert.q.out 2fab374433 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_skip_default.q.out cd8e9c0553 
>   ql/src/test/results/clientpositive/llap/dynpart_merge.q.out 1c6f556052 
>   ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out 7811f7cbd6 
>   ql/src/test/results/clientpositive/llap/escape_clusterby1.q.out 84cf1e5d78 
>   ql/src/test/results/clientpositive/llap/escape_distributeby1.q.out ef9aec337c 
>   ql/src/test/results/clientpositive/llap/escape_orderby1.q.out 5a4e6f175a 
>   ql/src/test/results/clientpositive/llap/escape_sortby1.q.out 182e1e72ba 
>   ql/src/test/results/clientpositive/llap/except_all.q.out 5d1dc2211a 
>   ql/src/test/results/clientpositive/llap/exec_parallel_column_stats.q.out 736d59a9b6 
>   ql/src/test/results/clientpositive/llap/explain_ddl.q.out aea46d304f 
>   ql/src/test/results/clientpositive/llap/explain_logical.q.out 56c47d6025 
>   ql/src/test/results/clientpositive/llap/explaindenpendencydiffengs.q.out a31317bf99 
>   ql/src/test/results/clientpositive/llap/extract.q.out 536dc4e2c9 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_date.q.out e6710d57b1 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_full.q.out 97f31bfdb6 
>   ql/src/test/results/clientpositive/llap/extrapolate_part_stats_partial.q.out 36251dea7a 
>   ql/src/test/results/clientpositive/llap/fetch_aggregation.q.out 8949995258 
>   ql/src/test/results/clientpositive/llap/filter_aggr.q.out e3fe160545 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown.q.out 74a7aa89e7 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown2.q.out 07dec3c5fa 
>   ql/src/test/results/clientpositive/llap/filter_cond_pushdown_HIVE_15647.q.out 54f28df314 
>   ql/src/test/results/clientpositive/llap/filter_in_or_dup.q.out 7bb40461c8 
>   ql/src/test/results/clientpositive/llap/filter_numeric.q.out 2b3c586874 
>   ql/src/test/results/clientpositive/llap/flatten_and_or.q.out f39a1a1c33 
>   ql/src/test/results/clientpositive/llap/floor_time.q.out 010d437778 
>   ql/src/test/results/clientpositive/llap/fm-sketch.q.out 921546eb64 
>   ql/src/test/results/clientpositive/llap/fold_case.q.out 5939a034ce 
>   ql/src/test/results/clientpositive/llap/fold_eq_with_case_when.q.out dda4be8eb1 
>   ql/src/test/results/clientpositive/llap/fold_to_null.q.out eaba925a42 
>   ql/src/test/results/clientpositive/llap/fold_when.q.out 8753d9fddf 
>   ql/src/test/results/clientpositive/llap/folder_predicate.q.out b4c4724a24 
>   ql/src/test/results/clientpositive/llap/foldts.q.out feda88c156 
>   ql/src/test/results/clientpositive/llap/fp_literal_arithmetic.q.out 1d28b276e4 
>   ql/src/test/results/clientpositive/llap/gby_star.q.out 33ac8c32ae 
>   ql/src/test/results/clientpositive/llap/groupby10.q.out 583f2fbc28 
>   ql/src/test/results/clientpositive/llap/groupby11.q.out 4b62238506 
>   ql/src/test/results/clientpositive/llap/groupby12.q.out ded303637f 
>   ql/src/test/results/clientpositive/llap/groupby13.q.out a32a654afa 
>   ql/src/test/results/clientpositive/llap/groupby1_limit.q.out 03bd541de2 
>   ql/src/test/results/clientpositive/llap/groupby1_map.q.out 81459ac6b6 
>   ql/src/test/results/clientpositive/llap/groupby1_map_nomap.q.out 2a40ed5f39 
>   ql/src/test/results/clientpositive/llap/groupby1_map_skew.q.out da4f502178 
>   ql/src/test/results/clientpositive/llap/groupby1_noskew.q.out 1745df03b1 
>   ql/src/test/results/clientpositive/llap/groupby2_limit.q.out 1579903938 
>   ql/src/test/results/clientpositive/llap/groupby2_map.q.out 85bebf0000 
>   ql/src/test/results/clientpositive/llap/groupby2_map_multi_distinct.q.out d49e7de3b7 
>   ql/src/test/results/clientpositive/llap/groupby2_map_skew.q.out 9783f9e10f 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew.q.out 5dd501fbe1 
>   ql/src/test/results/clientpositive/llap/groupby2_noskew_multi_distinct.q.out 4d8a5aa02b 
>   ql/src/test/results/clientpositive/llap/groupby3_map.q.out 22573cb77a 
>   ql/src/test/results/clientpositive/llap/groupby3_map_multi_distinct.q.out fbd6e4e894 
>   ql/src/test/results/clientpositive/llap/groupby3_map_skew.q.out c6cccd1c60 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew.q.out c62c01db6a 
>   ql/src/test/results/clientpositive/llap/groupby3_noskew_multi_distinct.q.out 4f6ce09725 
>   ql/src/test/results/clientpositive/llap/groupby4.q.out d861e47207 
>   ql/src/test/results/clientpositive/llap/groupby4_map.q.out 73d550f8d6 
>   ql/src/test/results/clientpositive/llap/groupby4_map_skew.q.out c1ad5b3a7f 
>   ql/src/test/results/clientpositive/llap/groupby4_noskew.q.out 842bda37c7 
>   ql/src/test/results/clientpositive/llap/groupby5.q.out 2eb244bad0 
>   ql/src/test/results/clientpositive/llap/groupby5_map.q.out c6cd69de5b 
>   ql/src/test/results/clientpositive/llap/groupby5_map_skew.q.out f8c4ee77ca 
>   ql/src/test/results/clientpositive/llap/groupby5_noskew.q.out 2363dfed27 
>   ql/src/test/results/clientpositive/llap/groupby6.q.out a72afb26b8 
>   ql/src/test/results/clientpositive/llap/groupby6_map.q.out 9f8c791d25 
>   ql/src/test/results/clientpositive/llap/groupby6_map_skew.q.out 43fbc841b1 
>   ql/src/test/results/clientpositive/llap/groupby6_noskew.q.out 9545ca3873 
>   ql/src/test/results/clientpositive/llap/groupby7_map.q.out 08b0db51e1 
>   ql/src/test/results/clientpositive/llap/groupby7_map_multi_single_reducer.q.out e17ef4e8da 
>   ql/src/test/results/clientpositive/llap/groupby7_map_skew.q.out 4a06aa7830 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew.q.out d60d67e0a8 
>   ql/src/test/results/clientpositive/llap/groupby7_noskew_multi_single_reducer.q.out 45a2afcebc 
>   ql/src/test/results/clientpositive/llap/groupby8.q.out 59a2334014 
>   ql/src/test/results/clientpositive/llap/groupby8_map.q.out c004bcaf13 
>   ql/src/test/results/clientpositive/llap/groupby8_map_skew.q.out 6ae2b31edd 
>   ql/src/test/results/clientpositive/llap/groupby8_noskew.q.out fdc5a60438 
> 
> 
> Diff: https://reviews.apache.org/r/72421/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Miklos Gergely
> 
>