> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > accumulo-handler/src/test/results/positive/accumulo_queries.q.out
> > Line 150 (original), 150 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134691#file2134691line150>
> >
> > Is this a known issue?
removing the cast might have suppressed problematic cases;
In Hive: `select cast('xxx' as double) is null` should be true; however `select
'xxx' is null` is false
see: CALCITE-2929
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/allcolref_in_udf.q.out
> > Line 107 (original), 107 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134706#file2134706line107>
> >
> > Known issue?
CALCITE-2929
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/auto_join2.q.out
> > Line 42 (original), 42 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134710#file2134710line42>
> >
> > I guess same as previous one, but this time it is preventing folding in
> > more complex expression from happening.
CALCITE-2929 was a late comer to 1.19 release;
this change was happening in many q.out-s; not sure how much impact this has -
but from `UDFToDouble(key) is not null` we could deduce that `key is not
null`...
however; I think keeping `key is not null` is also good; because I don't think
that readers could be able to do the `cast` as well.
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/filter_cond_pushdown.q.out
> > Line 344 (original), 344 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134730#file2134730line344>
> >
> > Is the literal transformation here expected (int -> double?)?
query expressions is: `(int1 + int2) > 2`; so integer comparision would be
fine....
I've checked that even earlier if the literal was 2.1 or something it worked
correctly and the comparision happened in decimal
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/explainuser_1.q.out
> > Line 588 (original), 588 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134763#file2134763line588>
> >
> > Constant literal transformation. Is it expected?
`((UDFToFloat(c_int) + c_float) >= 0.0)`
I think in this case it is ok to change to floating point; as left hand side is
all float as well
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out
> > Line 29 (original), 29 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134781#file2134781line29>
> >
> > Expected?
this issue has its own ticket: issues is that a literal varchar value have
changed type to string
https://issues.apache.org/jira/browse/HIVE-21316
> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/orc_ppd_char.q.out
> > Line 29 (original), 29 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134829#file2134829line29>
> >
> > Expected?
this issue has its own ticket: issues is that a literal varchar value have
changed type to string
https://issues.apache.org/jira/browse/HIVE-21316
- Zoltan
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/69918/#review214127
-----------------------------------------------------------
On March 27, 2019, 4:40 p.m., Zoltan Haindrich wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/69918/
> -----------------------------------------------------------
>
> (Updated March 27, 2019, 4:40 p.m.)
>
>
> Review request for hive, Ashutosh Chauhan and Jesús Camacho Rodríguez.
>
>
> Bugs: HIVE-21001
> https://issues.apache.org/jira/browse/HIVE-21001
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> patch#1 here is #23 on jira
> patch#2 here is #48 on jira
>
>
> Diffs
> -----
>
>
> accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out
> fb8fca9324
> accumulo-handler/src/test/results/positive/accumulo_queries.q.out
> 80a7dc9717
> hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out
> b80738b263
> hbase-handler/src/test/results/positive/hbase_pushdown.q.out f37460c6d3
> hbase-handler/src/test/results/positive/hbase_queries.q.out cfcfaf3274
> pom.xml 7b45d84de8
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java
> e85a99e846
>
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelDecorrelator.java
> 238ae4ef4e
>
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveSubQueryRemoveRule.java
> 50ed8eda89
>
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTBuilder.java
> 74f8c33ab7
>
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java
> e783d1c833
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/PartitionPruner.java
> 7645564f3d
> ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 98e94e27e9
> ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
> a2dd554b6e
> ql/src/test/queries/clientpositive/druidmini_expressions.q e491986250
> ql/src/test/queries/clientpositive/subquery_multi.q 81a9187c19
> ql/src/test/results/clientpositive/allcolref_in_udf.q.out b635f67b7a
> ql/src/test/results/clientpositive/alter_partition_coltype.q.out 1fbc2131d5
> ql/src/test/results/clientpositive/annotate_stats_filter.q.out 44f77b8f50
> ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out
> 2cf5b0c456
> ql/src/test/results/clientpositive/auto_join2.q.out f154680c62
> ql/src/test/results/clientpositive/auto_join33.q.out 27fe10a0aa
> ql/src/test/results/clientpositive/auto_join_stats.q.out dc1338a5a7
> ql/src/test/results/clientpositive/auto_join_stats2.q.out 69623472fc
> ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out cb22b61f26
> ql/src/test/results/clientpositive/cbo_simple_select.q.out 32e69204f6
> ql/src/test/results/clientpositive/char_udf1.q.out 09fb69782f
> ql/src/test/results/clientpositive/complex_alias.q.out a808513d73
> ql/src/test/results/clientpositive/constantPropWhen.q.out 1684cb6010
> ql/src/test/results/clientpositive/constant_prop_3.q.out db73902af1
> ql/src/test/results/clientpositive/constprog_when_case.q.out 958e05e959
> ql/src/test/results/clientpositive/cte_mat_5.q.out 5beaada3f9
> ql/src/test/results/clientpositive/decimal_udf.q.out b2a5837aef
> ql/src/test/results/clientpositive/druid/druidmini_expressions.q.out
> 071a0f7739
> ql/src/test/results/clientpositive/druid/druidmini_extractTime.q.out
> 4ea95f6930
> ql/src/test/results/clientpositive/druid/druidmini_floorTime.q.out
> 8d9382443e
> ql/src/test/results/clientpositive/druid/druidmini_test_ts.q.out 358e98b674
> ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out
> 0c2ad97bdd
>
> ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out
> e5e6fd1f48
> ql/src/test/results/clientpositive/except_all.q.out 24a7dfbcf8
> ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 8627583c37
> ql/src/test/results/clientpositive/fold_case.q.out f4ef28dae5
> ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out 7bd756a863
> ql/src/test/results/clientpositive/fold_to_null.q.out 84c379e42e
> ql/src/test/results/clientpositive/fold_when.q.out 2cf30b5b4d
> ql/src/test/results/clientpositive/groupby_grouping_sets_grouping.q.out
> 33e68882ff
> ql/src/test/results/clientpositive/groupby_rollup_empty.q.out ecfd766526
> ql/src/test/results/clientpositive/groupby_sort_1_23.q.out e4ca83b0f4
> ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 7f1a231152
> ql/src/test/results/clientpositive/in_typecheck_char.q.out 464aad5924
> ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
> cd9fb275c4
> ql/src/test/results/clientpositive/infer_join_preds.q.out 0afdd029be
> ql/src/test/results/clientpositive/innerjoin1.q.out cfc2c06bbc
> ql/src/test/results/clientpositive/input8.q.out 32daa0598f
> ql/src/test/results/clientpositive/join2.q.out ec9e436013
> ql/src/test/results/clientpositive/join_filters_overlap.q.out 6cd17d1ddb
> ql/src/test/results/clientpositive/list_bucket_dml_6.q.out da36c459fe
> ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 68664a7060
> ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 6521e0f497
> ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
> c6a3c1fb8f
> ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out
> 30f8f0570b
> ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out
> 2c6d7cafa7
> ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out
> f61a6ed462
> ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out
> 2d48b9fa84
> ql/src/test/results/clientpositive/llap/bucketpruning1.q.out 934b383af5
> ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out acf91bf178
> ql/src/test/results/clientpositive/llap/constraints_optimization.q.out
> fbdc702daf
> ql/src/test/results/clientpositive/llap/cte_mat_5.q.out 7acc8eefc6
> ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out
> 54244672e4
> ql/src/test/results/clientpositive/llap/default_constraint.q.out 5d716ebb56
> ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out
> 1679d577e6
> ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out
> 9813b8fcc3
> ql/src/test/results/clientpositive/llap/except_distinct.q.out d54dda9714
> ql/src/test/results/clientpositive/llap/explainuser_1.q.out 1ea8fdcbb2
> ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out
> e7c0ab975b
> ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out
> 1098bb41f3
> ql/src/test/results/clientpositive/llap/kryo.q.out 7e10d64403
> ql/src/test/results/clientpositive/llap/lineage3.q.out 11e6904a12
> ql/src/test/results/clientpositive/llap/mapjoin_hint.q.out 9350fcb982
>
> ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out
> e0efe3cc1e
>
> ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out
> 6c3ba6cd96
>
> ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out
> d3e494dc4b
>
> ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out
> b55287deb0
>
> ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out
> cf6a6bace1
> ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
> d8aab03a22
> ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out
> de13beaf75
> ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
> 8566402bff
> ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out
> 4d7b983226
>
> ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out
> 9197bb6394
> ql/src/test/results/clientpositive/llap/mergejoin.q.out f1153e76dd
> ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out abd7dbdf7a
> ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out 12d6f67092
> ql/src/test/results/clientpositive/llap/sharedwork.q.out 9bd73f98b6
> ql/src/test/results/clientpositive/llap/subquery_in.q.out afcbddcef2
> ql/src/test/results/clientpositive/llap/subquery_in_having.q.out ddb7b421d9
> ql/src/test/results/clientpositive/llap/subquery_multi.q.out e04b2a6f94
> ql/src/test/results/clientpositive/llap/subquery_notin.q.out 37d9253f4e
> ql/src/test/results/clientpositive/llap/subquery_null_agg.q.out 2c306da6d9
> ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 1016a64525
> ql/src/test/results/clientpositive/llap/subquery_select.q.out ab56f905e0
> ql/src/test/results/clientpositive/llap/subquery_views.q.out fbc9f5b82d
> ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out
> c1156759d2
> ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out
> 93a1716064
> ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out
> c1156759d2
> ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out 3d6fe204be
> ql/src/test/results/clientpositive/llap/vector_adaptor_usage_mode.q.out
> 93c7e5aa61
> ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out 6529758a3a
> ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out 218a5cff17
> ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out
> d6f01ae582
> ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out 493cfca23a
> ql/src/test/results/clientpositive/llap/vector_date_1.q.out e79a7b7e9e
> ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out
> b26fb62e17
>
> ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out
> 16fe26fb6b
> ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out
> 229814f46d
> ql/src/test/results/clientpositive/llap/vector_interval_2.q.out 28da5049af
> ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out
> abf998eb90
>
> ql/src/test/results/clientpositive/llap/vector_orc_nested_column_pruning.q.out
> 944a36329c
> ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out
> f8b3223fdc
> ql/src/test/results/clientpositive/llap/vector_windowing_navfn.q.out
> 2af57ed583
> ql/src/test/results/clientpositive/llap/vectorization_0.q.out 1ee9aa97eb
> ql/src/test/results/clientpositive/llap/vectorization_5.q.out 6467a2fd81
> ql/src/test/results/clientpositive/llap/vectorization_6.q.out 2990bd4b82
> ql/src/test/results/clientpositive/llap/vectorization_8.q.out 3959239dbe
> ql/src/test/results/clientpositive/llap/vectorization_div0.q.out 9a260ef118
> ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out
> 051dc2f8a8
> ql/src/test/results/clientpositive/llap/vectorized_casts.q.out d1a9620186
>
> ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out
> 7f096716ff
> ql/src/test/results/clientpositive/llap/vectorized_math_funcs.q.out
> 63b42fde3a
> ql/src/test/results/clientpositive/llap/vectorized_string_funcs.q.out
> 7a5073577e
>
> ql/src/test/results/clientpositive/llap/vectorized_timestamp_ints_casts.q.out
> c52e3b9e94
> ql/src/test/results/clientpositive/masking_1.q.out d915a47757
> ql/src/test/results/clientpositive/masking_12.q.out 178a141da3
> ql/src/test/results/clientpositive/masking_2.q.out 6d8420270b
> ql/src/test/results/clientpositive/masking_3.q.out 1c7cd158f4
> ql/src/test/results/clientpositive/masking_4.q.out fc0acb7e27
> ql/src/test/results/clientpositive/mergejoin.q.out 1c6d62c8a0
> ql/src/test/results/clientpositive/nested_column_pruning.q.out 80fb68b2ba
> ql/src/test/results/clientpositive/optimize_filter_literal.q.out 6eb573a400
> ql/src/test/results/clientpositive/orc_nested_column_pruning.q.out
> 0fccc9ee7f
> ql/src/test/results/clientpositive/orc_ppd_char.q.out 846de53ff4
> ql/src/test/results/clientpositive/parquet_vectorization_0.q.out ebbe004dfa
> ql/src/test/results/clientpositive/parquet_vectorization_5.q.out fd348a04c2
> ql/src/test/results/clientpositive/parquet_vectorization_6.q.out 3ad9ad7e17
> ql/src/test/results/clientpositive/parquet_vectorization_8.q.out 112f63392a
> ql/src/test/results/clientpositive/parquet_vectorization_div0.q.out
> a4791ef2c9
> ql/src/test/results/clientpositive/pcr.q.out 3840eae596
> ql/src/test/results/clientpositive/pcs.q.out b6c22125f3
> ql/src/test/results/clientpositive/perf/spark/query11.q.out 45f02fdb49
> ql/src/test/results/clientpositive/perf/spark/query13.q.out 04be3cf39a
> ql/src/test/results/clientpositive/perf/spark/query21.q.out db03678080
> ql/src/test/results/clientpositive/perf/spark/query27.q.out 98a0ea8015
> ql/src/test/results/clientpositive/perf/spark/query31.q.out 12c99b1431
> ql/src/test/results/clientpositive/perf/spark/query34.q.out 1a6c034cef
> ql/src/test/results/clientpositive/perf/spark/query36.q.out 2920c2f0b5
> ql/src/test/results/clientpositive/perf/spark/query4.q.out 14a5ea2b21
> ql/src/test/results/clientpositive/perf/spark/query45.q.out 7ee7c0ee2b
> ql/src/test/results/clientpositive/perf/spark/query47.q.out 7ee1efa54e
> ql/src/test/results/clientpositive/perf/spark/query48.q.out 80d9752853
> ql/src/test/results/clientpositive/perf/spark/query53.q.out 939e2a54db
> ql/src/test/results/clientpositive/perf/spark/query57.q.out b975a8abfc
> ql/src/test/results/clientpositive/perf/spark/query63.q.out 9cd9c9897d
> ql/src/test/results/clientpositive/perf/spark/query67.q.out f1954b1c85
> ql/src/test/results/clientpositive/perf/spark/query70.q.out 11e8f0d18a
> ql/src/test/results/clientpositive/perf/spark/query73.q.out f77acfda3d
> ql/src/test/results/clientpositive/perf/spark/query74.q.out e7a4784479
> ql/src/test/results/clientpositive/perf/spark/query78.q.out 125f0a9904
> ql/src/test/results/clientpositive/perf/spark/query85.q.out 04a4e18c30
> ql/src/test/results/clientpositive/perf/spark/query86.q.out 301679a2cd
> ql/src/test/results/clientpositive/perf/spark/query87.q.out 9008fc2d99
> ql/src/test/results/clientpositive/perf/spark/query88.q.out f06f831298
> ql/src/test/results/clientpositive/perf/spark/query89.q.out c781201379
> ql/src/test/results/clientpositive/perf/spark/query93.q.out f69920d27b
> ql/src/test/results/clientpositive/perf/spark/query97.q.out 2372928d52
> ql/src/test/results/clientpositive/perf/tez/cbo_ext_query1.q.out bcd1f8dd20
> ql/src/test/results/clientpositive/perf/tez/cbo_query1.q.out 9d0fa3a109
> ql/src/test/results/clientpositive/perf/tez/cbo_query11.q.out de0783be16
> ql/src/test/results/clientpositive/perf/tez/cbo_query12.q.out cda7aa302e
> ql/src/test/results/clientpositive/perf/tez/cbo_query13.q.out 412cc67334
> ql/src/test/results/clientpositive/perf/tez/cbo_query14.q.out c85f42c4fd
> ql/src/test/results/clientpositive/perf/tez/cbo_query15.q.out c00a7418f3
> ql/src/test/results/clientpositive/perf/tez/cbo_query16.q.out ef8712ce1f
> ql/src/test/results/clientpositive/perf/tez/cbo_query17.q.out 84832a4b4d
> ql/src/test/results/clientpositive/perf/tez/cbo_query2.q.out 7b14ad3358
> ql/src/test/results/clientpositive/perf/tez/cbo_query20.q.out ba354b6738
> ql/src/test/results/clientpositive/perf/tez/cbo_query21.q.out 0365697005
> ql/src/test/results/clientpositive/perf/tez/cbo_query23.q.out 377b587654
> ql/src/test/results/clientpositive/perf/tez/cbo_query24.q.out 3add88ad25
> ql/src/test/results/clientpositive/perf/tez/cbo_query25.q.out db13a5d30a
> ql/src/test/results/clientpositive/perf/tez/cbo_query27.q.out e072692b33
> ql/src/test/results/clientpositive/perf/tez/cbo_query28.q.out e0e61534c5
> ql/src/test/results/clientpositive/perf/tez/cbo_query29.q.out 82a914b616
> ql/src/test/results/clientpositive/perf/tez/cbo_query30.q.out 02e26a7c10
> ql/src/test/results/clientpositive/perf/tez/cbo_query31.q.out 8907b8d6cd
> ql/src/test/results/clientpositive/perf/tez/cbo_query32.q.out fc353fb02b
> ql/src/test/results/clientpositive/perf/tez/cbo_query33.q.out 8534997488
> ql/src/test/results/clientpositive/perf/tez/cbo_query34.q.out b2a6320acb
> ql/src/test/results/clientpositive/perf/tez/cbo_query36.q.out 9a74bed470
> ql/src/test/results/clientpositive/perf/tez/cbo_query37.q.out 07b9901520
> ql/src/test/results/clientpositive/perf/tez/cbo_query39.q.out 51bb90101d
> ql/src/test/results/clientpositive/perf/tez/cbo_query4.q.out 4b388653ae
> ql/src/test/results/clientpositive/perf/tez/cbo_query40.q.out 1f834b5647
> ql/src/test/results/clientpositive/perf/tez/cbo_query43.q.out 1d86c8bd07
> ql/src/test/results/clientpositive/perf/tez/cbo_query47.q.out 8dff4677ba
> ql/src/test/results/clientpositive/perf/tez/cbo_query48.q.out 22b051d06a
> ql/src/test/results/clientpositive/perf/tez/cbo_query49.q.out 1300dd92af
> ql/src/test/results/clientpositive/perf/tez/cbo_query5.q.out e78c3e5917
> ql/src/test/results/clientpositive/perf/tez/cbo_query50.q.out becffde820
> ql/src/test/results/clientpositive/perf/tez/cbo_query53.q.out 9b42428097
> ql/src/test/results/clientpositive/perf/tez/cbo_query54.q.out 39b6a6be15
> ql/src/test/results/clientpositive/perf/tez/cbo_query56.q.out d01dbcd154
> ql/src/test/results/clientpositive/perf/tez/cbo_query57.q.out 6c8ef17bc6
> ql/src/test/results/clientpositive/perf/tez/cbo_query58.q.out b4410ff07a
> ql/src/test/results/clientpositive/perf/tez/cbo_query59.q.out 8674a8a6c6
> ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out f502c004cf
> ql/src/test/results/clientpositive/perf/tez/cbo_query60.q.out acda930197
> ql/src/test/results/clientpositive/perf/tez/cbo_query61.q.out 3c03347810
> ql/src/test/results/clientpositive/perf/tez/cbo_query63.q.out 78c9b13111
> ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out 356778b4a7
> ql/src/test/results/clientpositive/perf/tez/cbo_query65.q.out 25cb9ccc6b
> ql/src/test/results/clientpositive/perf/tez/cbo_query66.q.out e2409a9d82
> ql/src/test/results/clientpositive/perf/tez/cbo_query73.q.out 2639cf22b4
> ql/src/test/results/clientpositive/perf/tez/cbo_query74.q.out 4a9a1127b3
> ql/src/test/results/clientpositive/perf/tez/cbo_query75.q.out 8c445d9de5
> ql/src/test/results/clientpositive/perf/tez/cbo_query76.q.out 740d03818e
> ql/src/test/results/clientpositive/perf/tez/cbo_query77.q.out 91ad054e66
> ql/src/test/results/clientpositive/perf/tez/cbo_query78.q.out 02635826f0
> ql/src/test/results/clientpositive/perf/tez/cbo_query80.q.out 334f09cc33
> ql/src/test/results/clientpositive/perf/tez/cbo_query81.q.out 0adb5551da
> ql/src/test/results/clientpositive/perf/tez/cbo_query82.q.out a60312f11b
> ql/src/test/results/clientpositive/perf/tez/cbo_query83.q.out 8211db1c95
> ql/src/test/results/clientpositive/perf/tez/cbo_query85.q.out 0963936768
> ql/src/test/results/clientpositive/perf/tez/cbo_query87.q.out e030b3eb2c
> ql/src/test/results/clientpositive/perf/tez/cbo_query88.q.out 1f4471e8ae
> ql/src/test/results/clientpositive/perf/tez/cbo_query89.q.out 7cfb3ecdec
> ql/src/test/results/clientpositive/perf/tez/cbo_query91.q.out e6fe23fb5b
> ql/src/test/results/clientpositive/perf/tez/cbo_query92.q.out be7f364ee9
> ql/src/test/results/clientpositive/perf/tez/cbo_query93.q.out 6a8ed39e29
> ql/src/test/results/clientpositive/perf/tez/cbo_query94.q.out e80788209e
> ql/src/test/results/clientpositive/perf/tez/cbo_query95.q.out 68f318934c
> ql/src/test/results/clientpositive/perf/tez/cbo_query97.q.out a6f39397ea
> ql/src/test/results/clientpositive/perf/tez/cbo_query98.q.out 374a6a06d6
>
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out
> 255261bdaa
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out
> 13801ffc6c
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query11.q.out
> f315e3c455
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query12.q.out
> ab4a8377e6
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query13.q.out
> a08c5a4be1
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out
> 118d23b577
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query15.q.out
> 32404b6209
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query16.q.out
> 1de59b24d9
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query17.q.out
> 120c8d28d1
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query2.q.out
> 07ab7a16e0
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query20.q.out
> 29382b389b
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query21.q.out
> 5e165e8e70
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query23.q.out
> 3146b776ce
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query24.q.out
> 41d96ea303
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query25.q.out
> 958033e41b
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query27.q.out
> 7fae258207
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query28.q.out
> e0e61534c5
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query29.q.out
> 3e7c6805b2
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query30.q.out
> bd68baa23b
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query31.q.out
> f8e31a23aa
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query32.q.out
> b5cf714198
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query33.q.out
> e8824ddf54
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query34.q.out
> 987f8d3eea
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query36.q.out
> d4031261c7
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query37.q.out
> f054717d70
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query39.q.out
> 272bedcbce
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query4.q.out
> 9668e0f4a1
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query40.q.out
> 5cce22af4e
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query43.q.out
> 6b21ee45c0
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query46.q.out
> 9d21449b65
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query47.q.out
> 8aa0871cb0
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query48.q.out
> 3188d82f28
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query49.q.out
> bc108dba6e
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query5.q.out
> 54f3dd6a10
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query50.q.out
> 49c87eedb5
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query53.q.out
> bac3f77538
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query54.q.out
> e33203d93c
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query56.q.out
> a13e599b34
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query57.q.out
> cb8f67b5c1
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query58.q.out
> 3e89c2da75
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query59.q.out
> 34376d1262
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out
> 5e3deb3eb9
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query60.q.out
> ea098f7567
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query61.q.out
> 2bc02f51f7
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query63.q.out
> e22d812f78
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out
> 8223efcdb6
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out
> 3e906b73b0
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query66.q.out
> 77256a3adc
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query68.q.out
> 1b25235c8a
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out
> 206b0f1972
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query73.q.out
> 38af7c0d35
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query74.q.out
> 4a8f0b88f0
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query75.q.out
> a95e756dab
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query76.q.out
> a51a05ac00
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query77.q.out
> 0ac295bf8f
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out
> de1b133006
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query80.q.out
> a4fac0cca1
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query81.q.out
> 98066643bf
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query82.q.out
> 54c4a99b68
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query83.q.out
> 58ed6dabe7
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query85.q.out
> 91aad930ba
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query87.q.out
> 97c9eddc34
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query88.q.out
> 1ac8fe2dcd
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query89.q.out
> d9c7d42b9f
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query91.q.out
> 0017776216
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query92.q.out
> 503c78185c
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query94.q.out
> 25e0c8bd9e
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query95.q.out
> 606e162b30
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query97.q.out
> c8fff90413
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query98.q.out
> 2a6b66f2bf
> ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out
> db9acc93cb
> ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out
> 69f93290d9
> ql/src/test/results/clientpositive/perf/tez/constraints/query11.q.out
> 7e0582e164
> ql/src/test/results/clientpositive/perf/tez/constraints/query13.q.out
> 616ed6bcde
> ql/src/test/results/clientpositive/perf/tez/constraints/query21.q.out
> 7c68a294ea
> ql/src/test/results/clientpositive/perf/tez/constraints/query31.q.out
> 8e0de0ffe2
> ql/src/test/results/clientpositive/perf/tez/constraints/query34.q.out
> e2c3631141
> ql/src/test/results/clientpositive/perf/tez/constraints/query36.q.out
> 8158608354
> ql/src/test/results/clientpositive/perf/tez/constraints/query4.q.out
> e6558e99a9
> ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out
> 3fd361a9f9
> ql/src/test/results/clientpositive/perf/tez/constraints/query45.q.out
> 64d9c98395
> ql/src/test/results/clientpositive/perf/tez/constraints/query46.q.out
> dde72e07b8
> ql/src/test/results/clientpositive/perf/tez/constraints/query47.q.out
> efb3edda71
> ql/src/test/results/clientpositive/perf/tez/constraints/query48.q.out
> 93bafabefd
> ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out
> a13d0f9c09
> ql/src/test/results/clientpositive/perf/tez/constraints/query57.q.out
> 69aeaae7e9
> ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out
> 7aea119ac3
> ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out
> 5620b819fb
> ql/src/test/results/clientpositive/perf/tez/constraints/query68.q.out
> dd4ce4eb84
> ql/src/test/results/clientpositive/perf/tez/constraints/query70.q.out
> a49314c858
> ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out
> 1a9c2cf203
> ql/src/test/results/clientpositive/perf/tez/constraints/query73.q.out
> 52b0c26588
> ql/src/test/results/clientpositive/perf/tez/constraints/query74.q.out
> 525217b526
> ql/src/test/results/clientpositive/perf/tez/constraints/query78.q.out
> ef4d6dbc21
> ql/src/test/results/clientpositive/perf/tez/constraints/query85.q.out
> aeb33836cd
> ql/src/test/results/clientpositive/perf/tez/constraints/query86.q.out
> 638cce1b46
> ql/src/test/results/clientpositive/perf/tez/constraints/query87.q.out
> b6d3904c1c
> ql/src/test/results/clientpositive/perf/tez/constraints/query88.q.out
> 64919cafe7
> ql/src/test/results/clientpositive/perf/tez/constraints/query89.q.out
> 3049fec95c
> ql/src/test/results/clientpositive/perf/tez/query11.q.out da1c349ff0
> ql/src/test/results/clientpositive/perf/tez/query13.q.out 60a73d7250
> ql/src/test/results/clientpositive/perf/tez/query21.q.out 0d10843009
> ql/src/test/results/clientpositive/perf/tez/query31.q.out c0762b7bd4
> ql/src/test/results/clientpositive/perf/tez/query34.q.out d401e4cdc0
> ql/src/test/results/clientpositive/perf/tez/query36.q.out 064837a3cf
> ql/src/test/results/clientpositive/perf/tez/query4.q.out bb0d7ba3f5
> ql/src/test/results/clientpositive/perf/tez/query45.q.out c2f9374c4b
> ql/src/test/results/clientpositive/perf/tez/query47.q.out 04c64b405f
> ql/src/test/results/clientpositive/perf/tez/query48.q.out d64eec1c74
> ql/src/test/results/clientpositive/perf/tez/query53.q.out e9153f3a06
> ql/src/test/results/clientpositive/perf/tez/query57.q.out 4a18880260
> ql/src/test/results/clientpositive/perf/tez/query63.q.out 0bdd48b728
> ql/src/test/results/clientpositive/perf/tez/query70.q.out 8d9d06dd48
> ql/src/test/results/clientpositive/perf/tez/query73.q.out 352c7245ea
> ql/src/test/results/clientpositive/perf/tez/query74.q.out 20aade2974
> ql/src/test/results/clientpositive/perf/tez/query78.q.out 3d938e1c8e
> ql/src/test/results/clientpositive/perf/tez/query85.q.out 5b8ad0ba57
> ql/src/test/results/clientpositive/perf/tez/query86.q.out 2d6d545a5b
> ql/src/test/results/clientpositive/perf/tez/query87.q.out 5b59116741
> ql/src/test/results/clientpositive/perf/tez/query88.q.out e02ff3715b
> ql/src/test/results/clientpositive/perf/tez/query89.q.out 8501822cd2
> ql/src/test/results/clientpositive/perf/tez/query93.q.out b5e6ba9c48
> ql/src/test/results/clientpositive/pointlookup.q.out c77536efe5
> ql/src/test/results/clientpositive/pointlookup2.q.out 5a1f92758a
> ql/src/test/results/clientpositive/pointlookup3.q.out 469a460773
> ql/src/test/results/clientpositive/pointlookup4.q.out f105f8a569
> ql/src/test/results/clientpositive/ppd_constant_expr.q.out 39dd2d7de3
> ql/src/test/results/clientpositive/ppd_join_filter.q.out 68a8cd01f7
> ql/src/test/results/clientpositive/row__id.q.out fc4c3123b0
> ql/src/test/results/clientpositive/semijoin4.q.out 4cfdd55503
> ql/src/test/results/clientpositive/semijoin5.q.out 6fd4174110
> ql/src/test/results/clientpositive/skewjoinopt18.q.out 26526a37b2
> ql/src/test/results/clientpositive/spark/auto_join2.q.out 6aeadb52dd
> ql/src/test/results/clientpositive/spark/auto_join_stats.q.out a6d09228c1
> ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out fbcc489b14
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out
> 7138a6fb30
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out
> 24cf07b9a3
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out_spark
> 8c22440488
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out
> 329cdf66b2
> ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out
> be43889af1
> ql/src/test/results/clientpositive/spark/cbo_simple_select.q.out acf91bf178
> ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 866a86d7b4
> ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
> 06da1248f3
>
> ql/src/test/results/clientpositive/spark/infer_bucket_sort_map_operators.q.out
> 59e25f890e
> ql/src/test/results/clientpositive/spark/join2.q.out 3f64bc9a40
> ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out
> 49226b2622
> ql/src/test/results/clientpositive/spark/parquet_vectorization_0.q.out
> adb9f4a33b
> ql/src/test/results/clientpositive/spark/parquet_vectorization_5.q.out
> fc3952117a
> ql/src/test/results/clientpositive/spark/parquet_vectorization_6.q.out
> 6eabffb84d
> ql/src/test/results/clientpositive/spark/parquet_vectorization_8.q.out
> 357a321c27
> ql/src/test/results/clientpositive/spark/parquet_vectorization_div0.q.out
> 8f40278318
> ql/src/test/results/clientpositive/spark/pcr.q.out 2c5b15aa3a
> ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out b8a8760955
> ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 0e43a882ed
>
> ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning.q.out
> 89da63134c
> ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out
> b8403f4e39
>
> ql/src/test/results/clientpositive/spark/spark_use_ts_stats_for_mapjoin.q.out
> eecacca8ad
>
> ql/src/test/results/clientpositive/spark/spark_vectorized_dynamic_partition_pruning.q.out
> e90f9d17ac
> ql/src/test/results/clientpositive/spark/subquery_in.q.out 3fc9aa1b1b
> ql/src/test/results/clientpositive/spark/subquery_multi.q.out 17240f9dc5
> ql/src/test/results/clientpositive/spark/subquery_notin.q.out 2d93874450
> ql/src/test/results/clientpositive/spark/subquery_null_agg.q.out 302c2609cb
> ql/src/test/results/clientpositive/spark/subquery_scalar.q.out 4e31c3fd20
> ql/src/test/results/clientpositive/spark/subquery_select.q.out 3c6f6af020
> ql/src/test/results/clientpositive/spark/subquery_views.q.out d048716c0a
> ql/src/test/results/clientpositive/spark/union22.q.out 3798d87f7b
> ql/src/test/results/clientpositive/spark/vectorization_0.q.out c6e0c33dc5
> ql/src/test/results/clientpositive/spark/vectorization_5.q.out 00f8260aac
> ql/src/test/results/clientpositive/spark/vectorization_6.q.out d1cc6e39ed
> ql/src/test/results/clientpositive/spark/vectorization_div0.q.out
> 18159aa9bf
> ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out
> 2d8d8b1ec9
> ql/src/test/results/clientpositive/spark/vectorized_math_funcs.q.out
> 977725ca4c
> ql/src/test/results/clientpositive/spark/vectorized_string_funcs.q.out
> 79546c5a73
> ql/src/test/results/clientpositive/subquery_notexists.q.out 2b6c08bde4
> ql/src/test/results/clientpositive/subquery_notin_having.q.out 68a65df3a9
> ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
> 7217ac55b3
> ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 83d4557c8a
> ql/src/test/results/clientpositive/udf_isops_simplify.q.out e9fcd05939
> ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out 1f446eb454
> ql/src/test/results/clientpositive/union22.q.out a3aa5e2c77
> ql/src/test/results/clientpositive/union_offcbo.q.out 2e5675fe8e
> ql/src/test/results/clientpositive/vector_case_when_1.q.out 61062e1f8e
> ql/src/test/results/clientpositive/vector_case_when_2.q.out 29b0823961
> ql/src/test/results/clientpositive/vector_char_mapjoin1.q.out 19cb5b4b71
> ql/src/test/results/clientpositive/vector_coalesce_3.q.out 39fd5e898a
> ql/src/test/results/clientpositive/vector_date_1.q.out 4e82ed84b6
> ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out
> 31751503b5
> ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 613a30701a
> ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 49843e939e
> ql/src/test/results/clientpositive/vector_varchar_mapjoin1.q.out 0d4107991c
> ql/src/test/results/clientpositive/vectorization_5.q.out 36eb6d53a8
> ql/src/test/results/clientpositive/vectorization_6.q.out fbb6f5e3ca
> ql/src/test/results/clientpositive/vectorization_8.q.out 6a52519eae
> ql/src/test/results/clientpositive/vectorized_casts.q.out fd6277c4bb
> ql/src/test/results/clientpositive/vectorized_math_funcs.q.out 0b0aba6829
> ql/src/test/results/clientpositive/vectorized_string_funcs.q.out 64064c0e85
> ql/src/test/results/clientpositive/vectorized_timestamp_ints_casts.q.out
> bf66c03a5e
> ql/src/test/results/clientpositive/view_cbo.q.out c7d9c8a0ec
>
>
> Diff: https://reviews.apache.org/r/69918/diff/2/
>
>
> Testing
> -------
>
>
> Thanks,
>
> Zoltan Haindrich
>
>
