You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2017/03/13 19:42:11 UTC
[10/46] hive git commit: HIVE-15903: Compute table stats when user
computes column stats (Pengcheng Xiong, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/schema_evol_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_stats.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_stats.q.out
index 906e5e8..d024503 100644
--- a/ql/src/test/results/clientpositive/llap/schema_evol_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/schema_evol_stats.q.out
@@ -37,12 +37,18 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@partitioned1
PREHOOK: Input: default@partitioned1@part=1
PREHOOK: Input: default@partitioned1@part=2
+PREHOOK: Output: default@partitioned1
+PREHOOK: Output: default@partitioned1@part=1
+PREHOOK: Output: default@partitioned1@part=2
#### A masked pattern was here ####
POSTHOOK: query: analyze table partitioned1 compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partitioned1
POSTHOOK: Input: default@partitioned1@part=1
POSTHOOK: Input: default@partitioned1@part=2
+POSTHOOK: Output: default@partitioned1
+POSTHOOK: Output: default@partitioned1@part=1
+POSTHOOK: Output: default@partitioned1@part=2
#### A masked pattern was here ####
PREHOOK: query: desc formatted partitioned1
PREHOOK: type: DESCTABLE
@@ -237,12 +243,18 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@partitioned1
PREHOOK: Input: default@partitioned1@part=1
PREHOOK: Input: default@partitioned1@part=2
+PREHOOK: Output: default@partitioned1
+PREHOOK: Output: default@partitioned1@part=1
+PREHOOK: Output: default@partitioned1@part=2
#### A masked pattern was here ####
POSTHOOK: query: analyze table partitioned1 compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partitioned1
POSTHOOK: Input: default@partitioned1@part=1
POSTHOOK: Input: default@partitioned1@part=2
+POSTHOOK: Output: default@partitioned1
+POSTHOOK: Output: default@partitioned1@part=1
+POSTHOOK: Output: default@partitioned1@part=2
#### A masked pattern was here ####
PREHOOK: query: desc formatted partitioned1
PREHOOK: type: DESCTABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_table.q.out b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_table.q.out
index 5bfe159..2faf88a 100644
--- a/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_table.q.out
+++ b/ql/src/test/results/clientpositive/llap/schema_evol_text_vec_table.q.out
@@ -515,7 +515,7 @@ POSTHOOK: Input: default@table_change_string_group_double
insert_num c1 c2 c3 b
101 1.7976931348623157E308 1.7976931348623157E308 1.7976931348623157E308 original
102 -1.7976931348623157E308 -1.7976931348623157E308 -1.7976931348623157E308 original
-103 NULL NULL NULL original
+103 NULL 0.0 NULL original
104 30.774 30.774 30.774 original
105 46114.28 46114.28 46114.28 original
111 789.321 789.321 789.321 new
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/special_character_in_tabnames_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/special_character_in_tabnames_1.q.out b/ql/src/test/results/clientpositive/llap/special_character_in_tabnames_1.q.out
index d01b373..f6f3aac 100644
--- a/ql/src/test/results/clientpositive/llap/special_character_in_tabnames_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/special_character_in_tabnames_1.q.out
@@ -162,11 +162,15 @@ PREHOOK: query: analyze table `c/b/o_t1` compute statistics for columns key, val
PREHOOK: type: QUERY
PREHOOK: Input: default@c/b/o_t1
PREHOOK: Input: default@c/b/o_t1@dt=2014
+PREHOOK: Output: default@c/b/o_t1
+PREHOOK: Output: default@c/b/o_t1@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: analyze table `c/b/o_t1` compute statistics for columns key, value, c_int, c_float, c_boolean
POSTHOOK: type: QUERY
POSTHOOK: Input: default@c/b/o_t1
POSTHOOK: Input: default@c/b/o_t1@dt=2014
+POSTHOOK: Output: default@c/b/o_t1
+POSTHOOK: Output: default@c/b/o_t1@dt=2014
#### A masked pattern was here ####
PREHOOK: query: analyze table `//cbo_t2` partition (dt) compute statistics
PREHOOK: type: QUERY
@@ -184,11 +188,15 @@ PREHOOK: query: analyze table `//cbo_t2` compute statistics for columns key, val
PREHOOK: type: QUERY
PREHOOK: Input: default@//cbo_t2
PREHOOK: Input: default@//cbo_t2@dt=2014
+PREHOOK: Output: default@//cbo_t2
+PREHOOK: Output: default@//cbo_t2@dt=2014
#### A masked pattern was here ####
POSTHOOK: query: analyze table `//cbo_t2` compute statistics for columns key, value, c_int, c_float, c_boolean
POSTHOOK: type: QUERY
POSTHOOK: Input: default@//cbo_t2
POSTHOOK: Input: default@//cbo_t2@dt=2014
+POSTHOOK: Output: default@//cbo_t2
+POSTHOOK: Output: default@//cbo_t2@dt=2014
#### A masked pattern was here ####
PREHOOK: query: analyze table `cbo_/t3////` compute statistics
PREHOOK: type: QUERY
@@ -201,10 +209,12 @@ POSTHOOK: Output: default@cbo_/t3////
PREHOOK: query: analyze table `cbo_/t3////` compute statistics for columns key, value, c_int, c_float, c_boolean
PREHOOK: type: QUERY
PREHOOK: Input: default@cbo_/t3////
+PREHOOK: Output: default@cbo_/t3////
#### A masked pattern was here ####
POSTHOOK: query: analyze table `cbo_/t3////` compute statistics for columns key, value, c_int, c_float, c_boolean
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cbo_/t3////
+POSTHOOK: Output: default@cbo_/t3////
#### A masked pattern was here ####
PREHOOK: query: analyze table `src/_/cbo` compute statistics
PREHOOK: type: QUERY
@@ -217,10 +227,12 @@ POSTHOOK: Output: default@src/_/cbo
PREHOOK: query: analyze table `src/_/cbo` compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@src/_/cbo
+PREHOOK: Output: default@src/_/cbo
#### A masked pattern was here ####
POSTHOOK: query: analyze table `src/_/cbo` compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src/_/cbo
+POSTHOOK: Output: default@src/_/cbo
#### A masked pattern was here ####
PREHOOK: query: analyze table `p/a/r/t` compute statistics
PREHOOK: type: QUERY
@@ -233,10 +245,12 @@ POSTHOOK: Output: default@p/a/r/t
PREHOOK: query: analyze table `p/a/r/t` compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@p/a/r/t
+PREHOOK: Output: default@p/a/r/t
#### A masked pattern was here ####
POSTHOOK: query: analyze table `p/a/r/t` compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@p/a/r/t
+POSTHOOK: Output: default@p/a/r/t
#### A masked pattern was here ####
PREHOOK: query: analyze table `line/item` compute statistics
PREHOOK: type: QUERY
@@ -249,10 +263,12 @@ POSTHOOK: Output: default@line/item
PREHOOK: query: analyze table `line/item` compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@line/item
+PREHOOK: Output: default@line/item
#### A masked pattern was here ####
POSTHOOK: query: analyze table `line/item` compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@line/item
+POSTHOOK: Output: default@line/item
#### A masked pattern was here ####
PREHOOK: query: select key, (c_int+1)+2 as x, sum(c_int) from `c/b/o_t1` group by c_float, `c/b/o_t1`.c_int, key
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
index c905ceb..57aaf55 100644
--- a/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
+++ b/ql/src/test/results/clientpositive/llap/stats_only_null.q.out
@@ -189,30 +189,40 @@ STAGE PLANS:
PREHOOK: query: analyze table stats_null compute statistics for columns a,b,c,d
PREHOOK: type: QUERY
PREHOOK: Input: default@stats_null
+PREHOOK: Output: default@stats_null
#### A masked pattern was here ####
POSTHOOK: query: analyze table stats_null compute statistics for columns a,b,c,d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_null
+POSTHOOK: Output: default@stats_null
#### A masked pattern was here ####
PREHOOK: query: analyze table stats_null_part partition(dt='2010') compute statistics for columns a,b,c,d
PREHOOK: type: QUERY
PREHOOK: Input: default@stats_null_part
PREHOOK: Input: default@stats_null_part@dt=2010
+PREHOOK: Output: default@stats_null_part
+PREHOOK: Output: default@stats_null_part@dt=2010
#### A masked pattern was here ####
POSTHOOK: query: analyze table stats_null_part partition(dt='2010') compute statistics for columns a,b,c,d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_null_part
POSTHOOK: Input: default@stats_null_part@dt=2010
+POSTHOOK: Output: default@stats_null_part
+POSTHOOK: Output: default@stats_null_part@dt=2010
#### A masked pattern was here ####
PREHOOK: query: analyze table stats_null_part partition(dt='2011') compute statistics for columns a,b,c,d
PREHOOK: type: QUERY
PREHOOK: Input: default@stats_null_part
PREHOOK: Input: default@stats_null_part@dt=2011
+PREHOOK: Output: default@stats_null_part
+PREHOOK: Output: default@stats_null_part@dt=2011
#### A masked pattern was here ####
POSTHOOK: query: analyze table stats_null_part partition(dt='2011') compute statistics for columns a,b,c,d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_null_part
POSTHOOK: Input: default@stats_null_part@dt=2011
+POSTHOOK: Output: default@stats_null_part
+POSTHOOK: Output: default@stats_null_part@dt=2011
#### A masked pattern was here ####
PREHOOK: query: describe formatted stats_null_part partition (dt='2010')
PREHOOK: type: DESCTABLE
@@ -384,12 +394,18 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@stats_null_part
PREHOOK: Input: default@stats_null_part@dt=1
PREHOOK: Input: default@stats_null_part@dt=__HIVE_DEFAULT_PARTITION__
+PREHOOK: Output: default@stats_null_part
+PREHOOK: Output: default@stats_null_part@dt=1
+PREHOOK: Output: default@stats_null_part@dt=__HIVE_DEFAULT_PARTITION__
#### A masked pattern was here ####
POSTHOOK: query: analyze table stats_null_part compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_null_part
POSTHOOK: Input: default@stats_null_part@dt=1
POSTHOOK: Input: default@stats_null_part@dt=__HIVE_DEFAULT_PARTITION__
+POSTHOOK: Output: default@stats_null_part
+POSTHOOK: Output: default@stats_null_part@dt=1
+POSTHOOK: Output: default@stats_null_part@dt=__HIVE_DEFAULT_PARTITION__
#### A masked pattern was here ####
PREHOOK: query: describe formatted stats_null_part partition(dt = 1) a
PREHOOK: type: DESCTABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/union_remove_26.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/union_remove_26.q.out b/ql/src/test/results/clientpositive/llap/union_remove_26.q.out
index 18b9aa5..67fef54 100644
--- a/ql/src/test/results/clientpositive/llap/union_remove_26.q.out
+++ b/ql/src/test/results/clientpositive/llap/union_remove_26.q.out
@@ -103,18 +103,22 @@ POSTHOOK: Lineage: inputtbl3.val SIMPLE [(inputsrctbl3)inputsrctbl3.FieldSchema(
PREHOOK: query: analyze table inputTbl1 compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl1
+PREHOOK: Output: default@inputtbl1
#### A masked pattern was here ####
POSTHOOK: query: analyze table inputTbl1 compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl1
+POSTHOOK: Output: default@inputtbl1
#### A masked pattern was here ####
PREHOOK: query: analyze table inputTbl3 compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl3
+PREHOOK: Output: default@inputtbl3
#### A masked pattern was here ####
POSTHOOK: query: analyze table inputTbl3 compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl3
+POSTHOOK: Output: default@inputtbl3
#### A masked pattern was here ####
PREHOOK: query: explain
SELECT count(1) as rowcnt, min(val) as ms, max(val) as mx from inputTbl1
@@ -282,10 +286,12 @@ POSTHOOK: Input: default@inputtbl3
PREHOOK: query: analyze table inputTbl2 compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@inputtbl2
+PREHOOK: Output: default@inputtbl2
#### A masked pattern was here ####
POSTHOOK: query: analyze table inputTbl2 compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@inputtbl2
+POSTHOOK: Output: default@inputtbl2
#### A masked pattern was here ####
PREHOOK: query: explain
SELECT count(1) as rowcnt, min(val) as ms, max(val) as mx from inputTbl1
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
index 072399e..e687c5b 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join1.q.out
@@ -186,10 +186,12 @@ POSTHOOK: Output: default@small_alltypesorc_a
PREHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_alltypesorc_a
+PREHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_alltypesorc_a
+POSTHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
PREHOOK: query: select * from small_alltypesorc_a
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
index d79c71b..1dd24b0 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join2.q.out
@@ -191,10 +191,12 @@ POSTHOOK: Output: default@small_alltypesorc_a
PREHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_alltypesorc_a
+PREHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_alltypesorc_a
+POSTHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
PREHOOK: query: select * from small_alltypesorc_a
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vector_outer_join3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join3.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join3.q.out
index dbbfd34..f8d1ec2 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join3.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join3.q.out
@@ -191,10 +191,12 @@ POSTHOOK: Output: default@small_alltypesorc_a
PREHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_alltypesorc_a
+PREHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_alltypesorc_a
+POSTHOOK: Output: default@small_alltypesorc_a
#### A masked pattern was here ####
PREHOOK: query: select * from small_alltypesorc_a
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vector_outer_join4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join4.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join4.q.out
index ffce9e6..a55250b 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join4.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join4.q.out
@@ -201,10 +201,12 @@ POSTHOOK: Output: default@small_alltypesorc_b
PREHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_alltypesorc_b
+PREHOOK: Output: default@small_alltypesorc_b
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_alltypesorc_b
+POSTHOOK: Output: default@small_alltypesorc_b
#### A masked pattern was here ####
PREHOOK: query: select * from small_alltypesorc_b
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vector_outer_join5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vector_outer_join5.q.out b/ql/src/test/results/clientpositive/llap/vector_outer_join5.q.out
index 4f25253..680ee42 100644
--- a/ql/src/test/results/clientpositive/llap/vector_outer_join5.q.out
+++ b/ql/src/test/results/clientpositive/llap/vector_outer_join5.q.out
@@ -27,10 +27,12 @@ POSTHOOK: Output: default@sorted_mod_4
PREHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@sorted_mod_4
+PREHOOK: Output: default@sorted_mod_4
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE sorted_mod_4 COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sorted_mod_4
+POSTHOOK: Output: default@sorted_mod_4
#### A masked pattern was here ####
PREHOOK: query: create table small_table stored
as orc as select ctinyint, cbigint from alltypesorc limit 100
@@ -57,10 +59,12 @@ POSTHOOK: Output: default@small_table
PREHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_table
+PREHOOK: Output: default@small_table
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_table COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_table
+POSTHOOK: Output: default@small_table
#### A masked pattern was here ####
PREHOOK: query: explain vectorization detail formatted
select count(*) from (select s.*, st.*
@@ -267,10 +271,12 @@ POSTHOOK: Output: default@mod_8_mod_4
PREHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@mod_8_mod_4
+PREHOOK: Output: default@mod_8_mod_4
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE mod_8_mod_4 COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mod_8_mod_4
+POSTHOOK: Output: default@mod_8_mod_4
#### A masked pattern was here ####
PREHOOK: query: create table small_table2 stored
as orc as select pmod(ctinyint, 16) as cmodtinyint, cbigint from alltypesorc limit 100
@@ -297,10 +303,12 @@ POSTHOOK: Output: default@small_table2
PREHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS FOR COLUMNS
PREHOOK: type: QUERY
PREHOOK: Input: default@small_table2
+PREHOOK: Output: default@small_table2
#### A masked pattern was here ####
POSTHOOK: query: ANALYZE TABLE small_table2 COMPUTE STATISTICS FOR COLUMNS
POSTHOOK: type: QUERY
POSTHOOK: Input: default@small_table2
+POSTHOOK: Output: default@small_table2
#### A masked pattern was here ####
PREHOOK: query: explain vectorization detail formatted
select count(*) from (select s.*, st.*
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out
index eb0f405..5f4735f 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out
@@ -1632,10 +1632,12 @@ POSTHOOK: Output: default@dsrv_small
PREHOOK: query: analyze table dsrv_small compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@dsrv_small
+PREHOOK: Output: default@dsrv_small
#### A masked pattern was here ####
POSTHOOK: query: analyze table dsrv_small compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dsrv_small
+POSTHOOK: Output: default@dsrv_small
#### A masked pattern was here ####
PREHOOK: query: EXPLAIN select count(*) from dsrv_big a join dsrv_small b on (a.key_int = b.key_int)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out
index b369e7c..d9fd706 100644
--- a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out
+++ b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out
@@ -73,18 +73,22 @@ POSTHOOK: Output: default@dsrv2_small
PREHOOK: query: analyze table dsrv2_big compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@dsrv2_big
+PREHOOK: Output: default@dsrv2_big
#### A masked pattern was here ####
POSTHOOK: query: analyze table dsrv2_big compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dsrv2_big
+POSTHOOK: Output: default@dsrv2_big
#### A masked pattern was here ####
PREHOOK: query: analyze table dsrv2_small compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@dsrv2_small
+PREHOOK: Output: default@dsrv2_small
#### A masked pattern was here ####
POSTHOOK: query: analyze table dsrv2_small compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dsrv2_small
+POSTHOOK: Output: default@dsrv2_small
#### A masked pattern was here ####
PREHOOK: query: EXPLAIN select count(*) from dsrv2_big a join dsrv2_small b on (a.partkey_bigint = b.partkey_bigint)
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/perf/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query14.q.out b/ql/src/test/results/clientpositive/perf/query14.q.out
index 9821180..051d837 100644
--- a/ql/src/test/results/clientpositive/perf/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -1,7 +1,7 @@
-Warning: Shuffle Join MERGEJOIN[916][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 114' is a cross product
-Warning: Shuffle Join MERGEJOIN[917][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 115' is a cross product
Warning: Shuffle Join MERGEJOIN[914][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 61' is a cross product
Warning: Shuffle Join MERGEJOIN[915][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 62' is a cross product
+Warning: Shuffle Join MERGEJOIN[916][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 114' is a cross product
+Warning: Shuffle Join MERGEJOIN[917][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 115' is a cross product
Warning: Shuffle Join MERGEJOIN[912][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 5' is a cross product
Warning: Shuffle Join MERGEJOIN[913][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 6' is a cross product
PREHOOK: query: explain
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
index 20c330a..32609eb 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out
@@ -234,10 +234,12 @@ Stage-2
PREHOOK: query: analyze table src_stats compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@src_stats
+PREHOOK: Output: default@src_stats
#### A masked pattern was here ####
POSTHOOK: query: analyze table src_stats compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_stats
+POSTHOOK: Output: default@src_stats
#### A masked pattern was here ####
PREHOOK: query: explain analyze analyze table src_stats compute statistics for columns
PREHOOK: type: QUERY
@@ -246,19 +248,21 @@ POSTHOOK: type: QUERY
Vertex dependency in root stage
Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-Stage-2
+Stage-3
Column Stats Work{}
- Stage-0
- Reducer 2
- File Output Operator [FS_5]
- Group By Operator [GBY_3] (rows=1/1 width=960)
- Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0, 16)","compute_stats(VALUE._col2, 16)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=500/500 width=10)
- Output:["key","value"]
- TableScan [TS_0] (rows=500/500 width=10)
- default@src_stats,src_stats,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ Stage-2
+ Stats-Aggr Operator
+ Stage-0
+ Reducer 2
+ File Output Operator [FS_5]
+ Group By Operator [GBY_3] (rows=1/1 width=960)
+ Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0, 16)","compute_stats(VALUE._col2, 16)"]
+ <-Map 1 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_2]
+ Select Operator [SEL_1] (rows=500/500 width=10)
+ Output:["key","value"]
+ TableScan [TS_0] (rows=500/500 width=10)
+ default@src_stats,src_stats,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x))
PREHOOK: type: CREATEMACRO
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
index ee9affb..b35e294 100644
--- a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out
@@ -36,10 +36,12 @@ Stage-2
PREHOOK: query: analyze table src_stats compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@src_stats
+PREHOOK: Output: default@src_stats
#### A masked pattern was here ####
POSTHOOK: query: analyze table src_stats compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_stats
+POSTHOOK: Output: default@src_stats
#### A masked pattern was here ####
PREHOOK: query: explain analyze analyze table src_stats compute statistics for columns
PREHOOK: type: QUERY
@@ -48,19 +50,21 @@ POSTHOOK: type: QUERY
Vertex dependency in root stage
Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-Stage-2
+Stage-3
Column Stats Work{}
- Stage-0
- Reducer 2
- File Output Operator [FS_5]
- Group By Operator [GBY_3] (rows=1/1 width=960)
- Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0, 16)","compute_stats(VALUE._col2, 16)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=500/500 width=10)
- Output:["key","value"]
- TableScan [TS_0] (rows=500/500 width=10)
- default@src_stats,src_stats,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ Stage-2
+ Stats-Aggr Operator
+ Stage-0
+ Reducer 2
+ File Output Operator [FS_5]
+ Group By Operator [GBY_3] (rows=1/1 width=960)
+ Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0, 16)","compute_stats(VALUE._col2, 16)"]
+ <-Map 1 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_2]
+ Select Operator [SEL_1] (rows=500/500 width=10)
+ Output:["key","value"]
+ TableScan [TS_0] (rows=500/500 width=10)
+ default@src_stats,src_stats,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
PREHOOK: query: drop table src_multi2
PREHOOK: type: DROPTABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/1321293e/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
index 74e4693..da52b0a 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out
@@ -19,10 +19,12 @@ POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(alltypesorc)alltypesorc.FieldSchem
PREHOOK: query: analyze table acid_vectorized compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_vectorized
+PREHOOK: Output: default@acid_vectorized
#### A masked pattern was here ####
POSTHOOK: query: analyze table acid_vectorized compute statistics for columns
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_vectorized
+POSTHOOK: Output: default@acid_vectorized
#### A masked pattern was here ####
PREHOOK: query: explain select a, b from acid_vectorized order by a, b
PREHOOK: type: QUERY
@@ -39,13 +41,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=16 width=101)
+ Select Operator [SEL_7] (rows=10 width=101)
Output:["_col0","_col1"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=16 width=101)
+ Select Operator [SEL_5] (rows=10 width=101)
Output:["_col0","_col1"]
- TableScan [TS_0] (rows=16 width=101)
+ TableScan [TS_0] (rows=10 width=101)
default@acid_vectorized,acid_vectorized, ACID table,Tbl:COMPLETE,Col:COMPLETE,Output:["a","b"]
PREHOOK: query: explain select key, value
@@ -200,21 +202,23 @@ POSTHOOK: type: QUERY
Vertex dependency in root stage
Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)
-Stage-2
+Stage-3
Column Stats Work{}
- Stage-0
- Reducer 2
- File Output Operator [FS_6]
- Group By Operator [GBY_4] (rows=1 width=960)
- Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0)","compute_stats(VALUE._col1)"]
- <-Map 1 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_3]
- Group By Operator [GBY_2] (rows=1 width=984)
- Output:["_col0","_col1"],aggregations:["compute_stats(key, 16)","compute_stats(value, 16)"]
- Select Operator [SEL_1] (rows=500 width=178)
- Output:["key","value"]
- TableScan [TS_0] (rows=500 width=178)
- default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
+ Stage-2
+ Stats-Aggr Operator
+ Stage-0
+ Reducer 2
+ File Output Operator [FS_6]
+ Group By Operator [GBY_4] (rows=1 width=960)
+ Output:["_col0","_col1"],aggregations:["compute_stats(VALUE._col0)","compute_stats(VALUE._col1)"]
+ <-Map 1 [CUSTOM_SIMPLE_EDGE]
+ PARTITION_ONLY_SHUFFLE [RS_3]
+ Group By Operator [GBY_2] (rows=1 width=984)
+ Output:["_col0","_col1"],aggregations:["compute_stats(key, 16)","compute_stats(value, 16)"]
+ Select Operator [SEL_1] (rows=500 width=178)
+ Output:["key","value"]
+ TableScan [TS_0] (rows=500 width=178)
+ default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"]
PREHOOK: query: explain
CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x))