You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2017/11/07 22:33:47 UTC
[10/22] hive git commit: HIVE-16827 : Merge stats task and column
stats task into a single task (Zoltan Haindrich via Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join33.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join33.q.out b/ql/src/test/results/clientpositive/join33.q.out
index 176989c..30a5ba9 100644
--- a/ql/src/test/results/clientpositive/join33.q.out
+++ b/ql/src/test/results/clientpositive/join33.q.out
@@ -366,7 +366,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join34.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join34.q.out b/ql/src/test/results/clientpositive/join34.q.out
index 67599bc..072a20b 100644
--- a/ql/src/test/results/clientpositive/join34.q.out
+++ b/ql/src/test/results/clientpositive/join34.q.out
@@ -309,7 +309,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join35.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join35.q.out b/ql/src/test/results/clientpositive/join35.q.out
index ade6646..f8fd438 100644
--- a/ql/src/test/results/clientpositive/join35.q.out
+++ b/ql/src/test/results/clientpositive/join35.q.out
@@ -393,7 +393,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-4
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join36.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join36.q.out b/ql/src/test/results/clientpositive/join36.q.out
index 43a091f..0fd4d91 100644
--- a/ql/src/test/results/clientpositive/join36.q.out
+++ b/ql/src/test/results/clientpositive/join36.q.out
@@ -133,7 +133,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join37.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join37.q.out b/ql/src/test/results/clientpositive/join37.q.out
index b0a2ee3..c8bef83 100644
--- a/ql/src/test/results/clientpositive/join37.q.out
+++ b/ql/src/test/results/clientpositive/join37.q.out
@@ -93,7 +93,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
SELECT /*+ MAPJOIN(X) */ x.key, x.value, y.value
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join39.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join39.q.out b/ql/src/test/results/clientpositive/join39.q.out
index c656762..93ebdb8 100644
--- a/ql/src/test/results/clientpositive/join39.q.out
+++ b/ql/src/test/results/clientpositive/join39.q.out
@@ -86,7 +86,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE dest_j1
SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join4.q.out b/ql/src/test/results/clientpositive/join4.q.out
index f11d995..d4e83c4 100644
--- a/ql/src/test/results/clientpositive/join4.q.out
+++ b/ql/src/test/results/clientpositive/join4.q.out
@@ -110,7 +110,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM (
FROM
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join5.q.out b/ql/src/test/results/clientpositive/join5.q.out
index 99cfe1a..8cfe402 100644
--- a/ql/src/test/results/clientpositive/join5.q.out
+++ b/ql/src/test/results/clientpositive/join5.q.out
@@ -110,7 +110,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM (
FROM
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join6.q.out b/ql/src/test/results/clientpositive/join6.q.out
index ce2ec8b..8d6578a 100644
--- a/ql/src/test/results/clientpositive/join6.q.out
+++ b/ql/src/test/results/clientpositive/join6.q.out
@@ -110,7 +110,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM (
FROM
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join7.q.out b/ql/src/test/results/clientpositive/join7.q.out
index d8adc39..f1af54a 100644
--- a/ql/src/test/results/clientpositive/join7.q.out
+++ b/ql/src/test/results/clientpositive/join7.q.out
@@ -138,7 +138,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM (
FROM
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join8.q.out b/ql/src/test/results/clientpositive/join8.q.out
index 3784824..ce5a5d4 100644
--- a/ql/src/test/results/clientpositive/join8.q.out
+++ b/ql/src/test/results/clientpositive/join8.q.out
@@ -113,7 +113,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM (
FROM
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join9.q.out b/ql/src/test/results/clientpositive/join9.q.out
index a96f341..58f8d7d 100644
--- a/ql/src/test/results/clientpositive/join9.q.out
+++ b/ql/src/test/results/clientpositive/join9.q.out
@@ -240,7 +240,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/join_map_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join_map_ppr.q.out b/ql/src/test/results/clientpositive/join_map_ppr.q.out
index a4d4140..6eb9889 100644
--- a/ql/src/test/results/clientpositive/join_map_ppr.q.out
+++ b/ql/src/test/results/clientpositive/join_map_ppr.q.out
@@ -225,7 +225,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-5
@@ -803,7 +804,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-5
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out b/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
index eeb47f7..7d0abfd 100644
--- a/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
+++ b/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
@@ -296,7 +296,8 @@ STAGE PLANS:
name: default.dest_2
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-4
Map Reduce
@@ -339,5 +340,6 @@ STAGE PLANS:
name: default.dest_3
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/lineage1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/lineage1.q.out b/ql/src/test/results/clientpositive/lineage1.q.out
index 6c8a22f..7d6af3e 100644
--- a/ql/src/test/results/clientpositive/lineage1.q.out
+++ b/ql/src/test/results/clientpositive/lineage1.q.out
@@ -147,7 +147,8 @@ STAGE PLANS:
name: default.dest_l1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-4
Map Reduce
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
index a664db3..2eca946 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out
@@ -197,7 +197,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08'
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
index bf987e1..6b34745 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
@@ -150,7 +150,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
index 3c80cef..a0bc3e9 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
@@ -150,7 +150,8 @@ STAGE PLANS:
name: default.list_bucketing_mul_col
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_mul_col partition (ds = '2008-04-08', hr = '11')
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
index 379a730..df8717b 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
@@ -150,7 +150,8 @@ STAGE PLANS:
name: default.list_bucketing_mul_col
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_mul_col partition (ds = '2008-04-08', hr = '2013-01-23+18:00:99')
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
index b6b829a..6b48f3d 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
@@ -146,7 +146,8 @@ STAGE PLANS:
name: default.list_bucketing
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing select * from src
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
index 8167730..512aeab 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
index aafdbb1..e86bf0a 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
@@ -191,7 +191,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds='2008-04-08', hr='11') select key, value from srcpart where ds='2008-04-08'
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
index 36bd666..7f90ac5 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
@@ -469,7 +470,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
index 23ec5f4..64fdacb 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
@@ -197,7 +197,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08'
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
index 1e01ca3..32dac42 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
@@ -516,7 +517,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
index eea69ff..7c11d3f 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
@@ -516,7 +517,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
index 0215f5d..d45be4e 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_dynamic_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
index fdc7a3e..9df2130 100644
--- a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
+++ b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
@@ -201,7 +201,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
@@ -469,7 +470,8 @@ STAGE PLANS:
name: default.list_bucketing_static_part
Stage: Stage-2
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out b/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
index 77bea79..86a9bf5 100644
--- a/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out
@@ -86,6 +86,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {}
bucket_count 16
bucket_field_name a
column.name.delimiter ,
@@ -109,6 +110,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
properties:
+ COLUMN_STATS_ACCURATE {}
bucket_count 16
bucket_field_name a
column.name.delimiter ,
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
index 388ff67..9b83fad 100644
--- a/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_no_buckets.q.out
@@ -169,7 +169,8 @@ STAGE PLANS:
Write Type: UPDATE
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: update srcpart_acid set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11'
PREHOOK: type: QUERY
@@ -348,7 +349,8 @@ STAGE PLANS:
Write Type: DELETE
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: delete from srcpart_acid where key in( '1001', '213', '43')
PREHOOK: type: QUERY
@@ -665,7 +667,8 @@ STAGE PLANS:
Write Type: UPDATE
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: update srcpart_acidb set value = concat(value, 'updated') where cast(key as integer) in(413,43) and hr='11'
PREHOOK: type: QUERY
@@ -845,7 +848,8 @@ STAGE PLANS:
Write Type: DELETE
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: delete from srcpart_acidb where key in( '1001', '213', '43')
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out
index ab74d0d..1a2aff7 100644
--- a/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out
+++ b/ql/src/test/results/clientpositive/llap/acid_vectorization_original.q.out
@@ -618,7 +618,8 @@ STAGE PLANS:
Write Type: UPDATE
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: update over10k_orc_bucketed set i = 0 where b = 4294967363 and t < 100
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
index 9fbc404..f93f666 100644
--- a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out
@@ -374,6 +374,44 @@ POSTHOOK: query: create table if not exists nzhang_part14 (key string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_part14
+PREHOOK: query: desc formatted nzhang_part14
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@nzhang_part14
+POSTHOOK: query: desc formatted nzhang_part14
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@nzhang_part14
+# col_name data_type comment
+key string
+
+# Partition Information
+# col_name data_type comment
+value string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 0
+ numPartitions 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
PREHOOK: query: insert overwrite table nzhang_part14 partition(value)
select key, value from (
select * from (select 'k1' as key, cast(null as string) as value from src limit 2)a
@@ -399,6 +437,42 @@ POSTHOOK: Output: default@nzhang_part14@value=
POSTHOOK: Output: default@nzhang_part14@value=__HIVE_DEFAULT_PARTITION__
POSTHOOK: Lineage: nzhang_part14 PARTITION(value= ).key EXPRESSION []
POSTHOOK: Lineage: nzhang_part14 PARTITION(value=__HIVE_DEFAULT_PARTITION__).key EXPRESSION []
+PREHOOK: query: desc formatted nzhang_part14 partition (value=' ')
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@nzhang_part14
+POSTHOOK: query: desc formatted nzhang_part14 partition (value=' ')
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@nzhang_part14
+# col_name data_type comment
+key string
+
+# Partition Information
+# col_name data_type comment
+value string
+
+# Detailed Partition Information
+Partition Value: [ ]
+Database: default
+Table: nzhang_part14
+#### A masked pattern was here ####
+Partition Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}
+ numFiles 1
+ numRows 2
+ rawDataSize 4
+ totalSize 6
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
PREHOOK: query: explain select key from nzhang_part14
PREHOOK: type: QUERY
POSTHOOK: query: explain select key from nzhang_part14
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/autoColumnStats_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_10.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_10.q.out
new file mode 100644
index 0000000..6cb51fd
--- /dev/null
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_10.q.out
@@ -0,0 +1,516 @@
+PREHOOK: query: drop table p
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table p
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE p(insert_num int, c1 tinyint, c2 smallint)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@p
+POSTHOOK: query: CREATE TABLE p(insert_num int, c1 tinyint, c2 smallint)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@p
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 tinyint
+c2 smallint
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"c1\":\"true\",\"c2\":\"true\",\"insert_num\":\"true\"}}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: insert into p values (1,22,333)
+PREHOOK: type: QUERY
+PREHOOK: Output: default@p
+POSTHOOK: query: insert into p values (1,22,333)
+POSTHOOK: type: QUERY
+POSTHOOK: Output: default@p
+POSTHOOK: Lineage: p.c1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: p.c2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: p.insert_num EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 tinyint
+c2 smallint
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"c1\":\"true\",\"c2\":\"true\",\"insert_num\":\"true\"}}
+ numFiles 1
+ numRows 1
+ rawDataSize 8
+ totalSize 9
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: alter table p replace columns (insert_num int, c1 STRING, c2 STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@p
+PREHOOK: Output: default@p
+POSTHOOK: query: alter table p replace columns (insert_num int, c1 STRING, c2 STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@p
+POSTHOOK: Output: default@p
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 string
+c2 string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+#### A masked pattern was here ####
+ numFiles 1
+ numRows 1
+ rawDataSize 8
+ totalSize 9
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: desc formatted p insert_num
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p insert_num
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name insert_num
+data_type int
+min 1
+max 1
+num_nulls 0
+distinct_count 1
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+PREHOOK: query: desc formatted p c1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p c1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name c1
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+PREHOOK: query: insert into p values (2,11,111)
+PREHOOK: type: QUERY
+PREHOOK: Output: default@p
+POSTHOOK: query: insert into p values (2,11,111)
+POSTHOOK: type: QUERY
+POSTHOOK: Output: default@p
+POSTHOOK: Lineage: p.c1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: p.c2 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: p.insert_num EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 string
+c2 string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+#### A masked pattern was here ####
+ numFiles 2
+ numRows 2
+ rawDataSize 16
+ totalSize 18
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: desc formatted p insert_num
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p insert_num
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name insert_num
+data_type int
+min 1
+max 2
+num_nulls 0
+distinct_count 2
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+PREHOOK: query: desc formatted p c1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p c1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name c1
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"insert_num\":\"true\"}}
+PREHOOK: query: drop table p
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@p
+PREHOOK: Output: default@p
+POSTHOOK: query: drop table p
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@p
+POSTHOOK: Output: default@p
+PREHOOK: query: CREATE TABLE p(insert_num int, c1 tinyint, c2 smallint)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@p
+POSTHOOK: query: CREATE TABLE p(insert_num int, c1 tinyint, c2 smallint)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@p
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 tinyint
+c2 smallint
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"c1\":\"true\",\"c2\":\"true\",\"insert_num\":\"true\"}}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: insert into p values (1,22,333)
+PREHOOK: type: QUERY
+PREHOOK: Output: default@p
+POSTHOOK: query: insert into p values (1,22,333)
+POSTHOOK: type: QUERY
+POSTHOOK: Output: default@p
+POSTHOOK: Lineage: p.c1 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: p.c2 EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: p.insert_num EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 tinyint
+c2 smallint
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ numFiles 1
+ numRows 1
+ rawDataSize 8
+ totalSize 9
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: alter table p replace columns (insert_num int, c1 STRING, c2 STRING)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@p
+PREHOOK: Output: default@p
+POSTHOOK: query: alter table p replace columns (insert_num int, c1 STRING, c2 STRING)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@p
+POSTHOOK: Output: default@p
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 string
+c2 string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+#### A masked pattern was here ####
+ numFiles 1
+ numRows 1
+ rawDataSize 8
+ totalSize 9
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: desc formatted p insert_num
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p insert_num
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name insert_num
+data_type int
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+PREHOOK: query: desc formatted p c1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p c1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name c1
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+PREHOOK: query: insert into p values (2,11,111)
+PREHOOK: type: QUERY
+PREHOOK: Output: default@p
+POSTHOOK: query: insert into p values (2,11,111)
+POSTHOOK: type: QUERY
+POSTHOOK: Output: default@p
+POSTHOOK: Lineage: p.c1 SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: p.c2 SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: p.insert_num EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: desc formatted p
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+# col_name data_type comment
+insert_num int
+c1 string
+c2 string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+#### A masked pattern was here ####
+ numFiles 2
+ numRows 2
+ rawDataSize 16
+ totalSize 18
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+InputFormat: org.apache.hadoop.mapred.TextInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
+PREHOOK: query: desc formatted p insert_num
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p insert_num
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name insert_num
+data_type int
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+PREHOOK: query: desc formatted p c1
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@p
+POSTHOOK: query: desc formatted p c1
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@p
+col_name c1
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
index 104c25f..0cc0c05 100644
--- a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out
@@ -747,7 +747,6 @@ Database: default
Table: alter5
#### A masked pattern was here ####
Partition Parameters:
- COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"col1\":\"true\"}}
numFiles 1
totalSize 1906
#### A masked pattern was here ####
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/auto_join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_join1.q.out b/ql/src/test/results/clientpositive/llap/auto_join1.q.out
index 5329f84..bbe63e2 100644
--- a/ql/src/test/results/clientpositive/llap/auto_join1.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_join1.q.out
@@ -98,7 +98,8 @@ STAGE PLANS:
name: default.dest_j1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
index c6b14ab..80a74fb 100644
--- a/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_smb_mapjoin_14.q.out
@@ -1612,7 +1612,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -1625,7 +1626,8 @@ STAGE PLANS:
name: default.dest2
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
@@ -1850,7 +1852,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -1863,7 +1866,8 @@ STAGE PLANS:
name: default.dest2
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: from (
select a.key as key, a.value as val1, b.value as val2 from tbl1 a join tbl2 b on a.key = b.key
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
index f358a59..a6d7309 100644
--- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
+++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_13.q.out
@@ -165,7 +165,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -178,7 +179,8 @@ STAGE PLANS:
name: default.dest2
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
@@ -366,7 +368,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -379,7 +382,8 @@ STAGE PLANS:
name: default.dest2
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
@@ -567,7 +571,8 @@ STAGE PLANS:
name: default.dest1
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -580,7 +585,8 @@ STAGE PLANS:
name: default.dest2
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: from (
SELECT a.key key1, a.value value1, b.key key2, b.value value2
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket2.q.out b/ql/src/test/results/clientpositive/llap/bucket2.q.out
index e0c92ce..9954c2d 100644
--- a/ql/src/test/results/clientpositive/llap/bucket2.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket2.q.out
@@ -174,7 +174,8 @@ STAGE PLANS:
name: default.bucket2_1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucket2_1
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket3.q.out b/ql/src/test/results/clientpositive/llap/bucket3.q.out
index 8e6d85c..218f9b7 100644
--- a/ql/src/test/results/clientpositive/llap/bucket3.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket3.q.out
@@ -171,7 +171,8 @@ STAGE PLANS:
name: default.bucket3_1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucket3_1 partition (ds='1')
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket4.q.out b/ql/src/test/results/clientpositive/llap/bucket4.q.out
index 5fbffc9..2115565 100644
--- a/ql/src/test/results/clientpositive/llap/bucket4.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket4.q.out
@@ -177,7 +177,8 @@ STAGE PLANS:
name: default.bucket4_1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucket4_1
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket5.q.out b/ql/src/test/results/clientpositive/llap/bucket5.q.out
index 2357623..680dbd9 100644
--- a/ql/src/test/results/clientpositive/llap/bucket5.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket5.q.out
@@ -248,7 +248,8 @@ STAGE PLANS:
name: default.bucketed_table
Stage: Stage-4
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-1
@@ -280,7 +281,8 @@ STAGE PLANS:
name: default.unbucketed_table
Stage: Stage-5
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
Stage: Stage-10
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket6.q.out b/ql/src/test/results/clientpositive/llap/bucket6.q.out
index 20895f8..42f062b 100644
--- a/ql/src/test/results/clientpositive/llap/bucket6.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket6.q.out
@@ -73,7 +73,8 @@ STAGE PLANS:
name: default.src_bucket
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: insert into table src_bucket select key,value from srcpart
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucket_many.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucket_many.q.out b/ql/src/test/results/clientpositive/llap/bucket_many.q.out
index b78cbaa..4f3bee2 100644
--- a/ql/src/test/results/clientpositive/llap/bucket_many.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucket_many.q.out
@@ -174,7 +174,8 @@ STAGE PLANS:
name: default.bucket_many
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucket_many
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
index c6ab95c..fa6a2d0 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin1.q.out
@@ -638,7 +638,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
@@ -1004,7 +1005,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
index c254d89..57eead0 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin2.q.out
@@ -352,7 +352,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
@@ -724,7 +725,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
@@ -1162,7 +1164,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out
index 1678135..184e890 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin3.q.out
@@ -376,7 +376,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
@@ -748,7 +749,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out
index b871c93..b353073 100644
--- a/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketmapjoin4.q.out
@@ -372,7 +372,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
@@ -728,7 +729,8 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucketmapjoin_tmp_result
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
index 13eecea..b907c2d 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_2.q.out
@@ -189,7 +189,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -368,7 +369,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -571,7 +573,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -780,7 +783,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -971,7 +975,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.v1, b.v2)
@@ -1162,7 +1167,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key+a.key, concat(a.value, b.value)
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
index 9959ba4..f5f5f91 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_6.q.out
@@ -167,7 +167,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, a.key2, concat(a.value, b.value)
@@ -353,7 +354,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT subq1.key, subq1.key2, subq1.value from
@@ -539,7 +541,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
@@ -660,7 +663,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
@@ -787,7 +791,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT subq2.key, subq2.key2, subq2.value from
@@ -991,7 +996,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT subq2.k2, subq2.k1, subq2.value from
@@ -1205,5 +1211,6 @@ STAGE PLANS:
name: default.test_table4
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
index c5e2973..7b38056 100644
--- a/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
+++ b/ql/src/test/results/clientpositive/llap/bucketsortoptimize_insert_7.q.out
@@ -167,7 +167,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -350,7 +351,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
@@ -539,7 +541,8 @@ STAGE PLANS:
name: default.test_table3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1')
SELECT a.key, concat(a.value, b.value)
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
index f073720..a6add6a 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
@@ -58,7 +58,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -175,11 +174,9 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
- Stats Aggregation Key Prefix: default.s/
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats Work:
+ Stats Aggregation Key Prefix: default.s/
Column Stats Desc:
Columns: key, value
Column Types: string, string
@@ -314,7 +311,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -490,11 +486,9 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
- Stats Aggregation Key Prefix: default.spart/
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats Work:
+ Stats Aggregation Key Prefix: default.spart/
Column Stats Desc:
Columns: key, value
Column Types: string, string
@@ -723,7 +717,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -899,11 +892,9 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
- Stats Aggregation Key Prefix: default.spart/
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats Work:
+ Stats Aggregation Key Prefix: default.spart/
Column Stats Desc:
Columns: key, value
Column Types: string, string
@@ -1132,7 +1123,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -1260,11 +1250,9 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
- Stats Aggregation Key Prefix: default.spart/
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats Work:
+ Stats Aggregation Key Prefix: default.spart/
Column Stats Desc:
Columns: key, value
Column Types: string, string
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
index 4bc5b39..6e71803 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
@@ -59,7 +59,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -178,10 +177,8 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats NoJob Work:
Column Stats Desc:
Columns: key, value
Column Types: string, string
@@ -311,7 +308,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -481,10 +477,8 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats NoJob Work:
Column Stats Desc:
Columns: key, value
Column Types: string, string
@@ -708,7 +702,6 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-0 is a root stage
Stage-2 depends on stages: Stage-0
- Stage-3 depends on stages: Stage-2
STAGE PLANS:
Stage: Stage-0
@@ -833,10 +826,8 @@ STAGE PLANS:
MultiFileSpray: false
Stage: Stage-2
- Stats-Aggr Operator
-
- Stage: Stage-3
- Column Stats Work
+ Stats Work
+ Basic Stats NoJob Work:
Column Stats Desc:
Columns: key, value
Column Types: string, string
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/ctas.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ctas.q.out b/ql/src/test/results/clientpositive/llap/ctas.q.out
index 1dd2dd1..7240da6 100644
--- a/ql/src/test/results/clientpositive/llap/ctas.q.out
+++ b/ql/src/test/results/clientpositive/llap/ctas.q.out
@@ -97,7 +97,8 @@ STAGE PLANS:
name: default.nzhang_CTAS1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
@@ -252,7 +253,8 @@ STAGE PLANS:
name: default.nzhang_ctas2
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
@@ -407,7 +409,8 @@ STAGE PLANS:
name: default.nzhang_ctas3
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
@@ -626,7 +629,8 @@ STAGE PLANS:
name: default.nzhang_ctas4
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
@@ -785,7 +789,8 @@ STAGE PLANS:
name: default.nzhang_ctas5
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out b/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
index 45b9af6..d2552fe 100644
--- a/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
+++ b/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
@@ -94,6 +94,42 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@testdeci2
POSTHOOK: Output: default@testdeci2
#### A masked pattern was here ####
+PREHOOK: query: describe formatted testdeci2
+PREHOOK: type: DESCTABLE
+PREHOOK: Input: default@testdeci2
+POSTHOOK: query: describe formatted testdeci2
+POSTHOOK: type: DESCTABLE
+POSTHOOK: Input: default@testdeci2
+# col_name data_type comment
+id int
+amount decimal(10,3)
+sales_tax decimal(10,3)
+item string
+
+# Detailed Table Information
+Database: default
+#### A masked pattern was here ####
+Retention: 0
+#### A masked pattern was here ####
+Table Type: MANAGED_TABLE
+Table Parameters:
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"amount\":\"true\",\"id\":\"true\",\"item\":\"true\",\"sales_tax\":\"true\"}}
+ numFiles 0
+ numRows 0
+ rawDataSize 0
+ totalSize 0
+#### A masked pattern was here ####
+
+# Storage Information
+SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
+InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
+OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
+Compressed: No
+Num Buckets: -1
+Bucket Columns: []
+Sort Columns: []
+Storage Desc Params:
+ serialization.format 1
PREHOOK: query: analyze table testdeci2 compute statistics for columns
PREHOOK: type: QUERY
PREHOOK: Input: default@testdeci2
@@ -129,18 +165,18 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_10]
- Select Operator [SEL_9] (rows=2 width=228)
+ Select Operator [SEL_9] (rows=1 width=228)
Output:["_col0","_col1","_col2"]
- Merge Join Operator [MERGEJOIN_15] (rows=2 width=228)
+ Merge Join Operator [MERGEJOIN_15] (rows=1 width=228)
Conds:RS_6._col1=RS_7._col3(Inner),Output:["_col0","_col3","_col4"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_6]
PartitionCols:_col1
- Select Operator [SEL_2] (rows=2 width=88)
+ Select Operator [SEL_2] (rows=1 width=88)
Output:["_col0","_col1"]
- Filter Operator [FIL_13] (rows=2 width=88)
+ Filter Operator [FIL_13] (rows=1 width=88)
predicate:item is not null
- TableScan [TS_0] (rows=2 width=88)
+ TableScan [TS_0] (rows=1 width=88)
default@testdeci2,s,Tbl:COMPLETE,Col:COMPLETE,Output:["id","item"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_7]
@@ -149,6 +185,6 @@ Stage-0
Output:["_col1","_col2","_col3"]
Filter Operator [FIL_14] (rows=1 width=312)
predicate:((id = 2) and item is not null)
- TableScan [TS_3] (rows=2 width=312)
+ TableScan [TS_3] (rows=1 width=312)
default@testdeci2,d,Tbl:COMPLETE,Col:COMPLETE,Output:["id","amount","sales_tax","item"]
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out b/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out
index e31ebaf..acd6076 100644
--- a/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out
+++ b/ql/src/test/results/clientpositive/llap/disable_merge_for_bucketing.q.out
@@ -174,7 +174,8 @@ STAGE PLANS:
name: default.bucket2_1
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
#### A masked pattern was here ####
PREHOOK: query: insert overwrite table bucket2_1
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out b/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out
index 3c3cd74..025c484 100644
--- a/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out
@@ -108,7 +108,8 @@ STAGE PLANS:
name: default.srcpart_date
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-0
Move Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/ec9cc0bc/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out
index 374d4b8..6772e5d 100644
--- a/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_3.q.out
@@ -259,7 +259,8 @@ STAGE PLANS:
Write Type: DELETE
Stage: Stage-6
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-2
Move Operator
@@ -273,7 +274,8 @@ STAGE PLANS:
Write Type: UPDATE
Stage: Stage-7
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-3
Move Operator
@@ -286,7 +288,8 @@ STAGE PLANS:
name: default.merge_tmp_table
Stage: Stage-8
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -300,7 +303,8 @@ STAGE PLANS:
Write Type: INSERT
Stage: Stage-9
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: explain merge into acidTbl as t using nonAcidOrcTbl s ON t.a = s.a
WHEN NOT MATCHED THEN INSERT VALUES(s.a, s.b)
@@ -433,7 +437,8 @@ STAGE PLANS:
Write Type: INSERT
Stage: Stage-3
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: explain merge into acidTbl as t using (
select * from nonAcidOrcTbl where a > 0
@@ -734,7 +739,8 @@ STAGE PLANS:
Write Type: DELETE
Stage: Stage-6
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-2
Move Operator
@@ -748,7 +754,8 @@ STAGE PLANS:
Write Type: UPDATE
Stage: Stage-7
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-3
Move Operator
@@ -761,7 +768,8 @@ STAGE PLANS:
name: default.merge_tmp_table
Stage: Stage-8
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
Stage: Stage-1
Move Operator
@@ -775,7 +783,8 @@ STAGE PLANS:
Write Type: INSERT
Stage: Stage-9
- Stats-Aggr Operator
+ Stats Work
+ Basic Stats Work:
PREHOOK: query: drop database if exists type2_scd_helper cascade
PREHOOK: type: DROPDATABASE