You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2019/01/04 00:24:25 UTC
[26/35] hive git commit: HIVE-16957: Support CTAS for auto gather
column stats (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window_2.q.out
index 24bd61d..b382fa4 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window_2.q.out
@@ -28,16 +28,6 @@ POSTHOOK: Lineage: cmv_basetable_n100.a SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n100.b SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n100.c SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n100.d SCRIPT []
-PREHOOK: query: analyze table cmv_basetable_n100 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@cmv_basetable_n100
-PREHOOK: Output: default@cmv_basetable_n100
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table cmv_basetable_n100 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@cmv_basetable_n100
-POSTHOOK: Output: default@cmv_basetable_n100
-#### A masked pattern was here ####
PREHOOK: query: create table cmv_basetable_2_n100 (a int, b varchar(256), c decimal(10,2), d int) stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -62,16 +52,6 @@ POSTHOOK: Lineage: cmv_basetable_2_n100.a SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.b SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.c SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.d SCRIPT []
-PREHOOK: query: analyze table cmv_basetable_2_n100 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@cmv_basetable_2_n100
-PREHOOK: Output: default@cmv_basetable_2_n100
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table cmv_basetable_2_n100 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@cmv_basetable_2_n100
-POSTHOOK: Output: default@cmv_basetable_2_n100
-#### A masked pattern was here ####
PREHOOK: query: CREATE MATERIALIZED VIEW cmv_mat_view_n300 AS
SELECT cmv_basetable_n100.a, cmv_basetable_2_n100.c
FROM cmv_basetable_n100 JOIN cmv_basetable_2_n100 ON (cmv_basetable_n100.a = cmv_basetable_2_n100.a)
@@ -109,7 +89,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"c\":\"true\"}}
bucketing_version 2
numFiles 2
numRows 2
@@ -151,16 +131,6 @@ POSTHOOK: Lineage: cmv_basetable_2_n100.a SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.b SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.c SCRIPT []
POSTHOOK: Lineage: cmv_basetable_2_n100.d SCRIPT []
-PREHOOK: query: analyze table cmv_basetable_2_n100 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@cmv_basetable_2_n100
-PREHOOK: Output: default@cmv_basetable_2_n100
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table cmv_basetable_2_n100 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@cmv_basetable_2_n100
-POSTHOOK: Output: default@cmv_basetable_2_n100
-#### A masked pattern was here ####
PREHOOK: query: DESCRIBE FORMATTED cmv_mat_view_n300
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@cmv_mat_view_n300
@@ -178,7 +148,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"c\":\"true\"}}
bucketing_version 2
numFiles 2
numRows 2
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
index 581cc87..00577c0 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_describe.q.out
@@ -66,7 +66,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"c\":\"true\"}}
bucketing_version 2
comment this is the first view
key foo
@@ -94,7 +94,7 @@ PREHOOK: query: show tblproperties cmv_mat_view_n8
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view_n8
POSTHOOK: type: SHOW_TBLPROPERTIES
-COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"a":"true","c":"true"}}
bucketing_version 2
comment this is the first view
key foo
@@ -157,7 +157,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\"}}
bucketing_version 2
comment this is the second view
key alice
@@ -239,7 +239,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}}
bucketing_version 2
comment this is the third view
numFiles 1
@@ -330,7 +330,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\"}}
bucketing_version 2
comment this is the last view
numFiles 1
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
index ba4d76f..2c9b36d 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
@@ -39,30 +39,69 @@ STAGE PLANS:
Stage: Stage-1
Tez
#### A masked pattern was here ####
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
Vertices:
Map 1
Map Operator Tree:
TableScan
alias: src_txn
filterExpr: ((UDFToDouble(key) > 200.0D) and (UDFToDouble(key) < 250.0D)) (type: boolean)
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) < 250.0D) and (UDFToDouble(key) > 200.0D)) (type: boolean)
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: value (type: string), key (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
name: default.partition_mv_1
- Execution mode: vectorized, llap
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: col1, col2
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
+ Group By Operator
+ aggregations: compute_stats(col1, 'hll')
+ keys: col2 (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
+ Execution mode: llap
LLAP IO: may be used (ACID table)
+ Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: compute_stats(VALUE._col0)
+ keys: KEY._col0 (type: string)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-2
Dependency Collection
@@ -92,6 +131,10 @@ STAGE PLANS:
Stage: Stage-3
Stats Work
Basic Stats Work:
+ Column Stats Desc:
+ Columns: value
+ Column Types: string
+ Table: default.partition_mv_1
Stage: Stage-5
Materialized View Work
@@ -578,17 +621,17 @@ STAGE PLANS:
TableScan
alias: src_txn
filterExpr: ((UDFToDouble(key) > 200.0D) and (UDFToDouble(key) < 250.0D)) (type: boolean)
- Statistics: Num rows: 501 Data size: 175536 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 501 Data size: 90180 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) < 250.0D) and (UDFToDouble(key) > 200.0D)) (type: boolean)
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9900 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: value (type: string), key (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9900 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9900 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -597,18 +640,18 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: value, key
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9900 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: compute_stats(value, 'hll')
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 55 Data size: 19270 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
Execution mode: llap
LLAP IO: may be used (ACID table)
@@ -620,14 +663,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 9459 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 27 Data size: 9459 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 27 Data size: 9459 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -956,19 +999,19 @@ STAGE PLANS:
TableScan
alias: src_txn
filterExpr: ((UDFToDouble(key) > 200.0D) and (UDFToDouble(key) < 250.0D)) (type: boolean)
- Statistics: Num rows: 502 Data size: 175904 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 502 Data size: 90862 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) < 250.0D) and (UDFToDouble(key) > 200.0D)) (type: boolean)
- Statistics: Num rows: 55 Data size: 19272 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 55 Data size: 19272 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 55 Data size: 19272 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: string)
Execution mode: vectorized, llap
LLAP IO: may be used (ACID table)
@@ -977,19 +1020,19 @@ STAGE PLANS:
TableScan
alias: src_txn_2
filterExpr: ((UDFToDouble(key) > 200.0D) and (UDFToDouble(key) < 250.0D)) (type: boolean)
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) < 250.0D) and (UDFToDouble(key) > 200.0D)) (type: boolean)
- Statistics: Num rows: 55 Data size: 9634 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 4785 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 55 Data size: 9634 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 4785 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 55 Data size: 9634 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 4785 Basic stats: COMPLETE Column stats: COMPLETE
Execution mode: vectorized, llap
LLAP IO: may be used (ACID table)
Reducer 2
@@ -1002,14 +1045,14 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col1 (type: string), _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -1018,18 +1061,18 @@ STAGE PLANS:
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
outputColumnNames: value, key
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9955 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: compute_stats(value, 'hll')
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 60 Data size: 21199 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
Reducer 3
Execution mode: llap
@@ -1039,14 +1082,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 10599 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 30 Data size: 10599 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 30 Data size: 10599 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
index 4ed30ee..6afa85d 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
@@ -41,6 +41,7 @@ STAGE PLANS:
#### A masked pattern was here ####
Edges:
Reducer 2 <- Map 1 (SIMPLE_EDGE)
+ Reducer 3 <- Map 1 (SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -48,22 +49,58 @@ STAGE PLANS:
TableScan
alias: src_txn
filterExpr: ((UDFToDouble(key) > 200.0D) and (UDFToDouble(key) < 250.0D)) (type: boolean)
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((UDFToDouble(key) < 250.0D) and (UDFToDouble(key) > 200.0D)) (type: boolean)
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: value (type: string), key (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: col1, col2
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
+ Group By Operator
+ aggregations: compute_stats(col1, 'hll')
+ keys: col2 (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
value expressions: _col0 (type: string)
- Execution mode: vectorized, llap
+ Execution mode: llap
LLAP IO: may be used (ACID table)
Reducer 2
+ Execution mode: llap
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: compute_stats(VALUE._col0)
+ keys: KEY._col0 (type: string)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ Select Operator
+ expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 27 Data size: 14229 Basic stats: COMPLETE Column stats: COMPLETE
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Reducer 3
Execution mode: vectorized, llap
Reduce Operator Tree:
Select Operator
@@ -72,7 +109,7 @@ STAGE PLANS:
File Output Operator
compressed: false
Dp Sort State: PARTITION_SORTED
- Statistics: Num rows: 55 Data size: 19268 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 9790 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
@@ -107,6 +144,10 @@ STAGE PLANS:
Stage: Stage-3
Stats Work
Basic Stats Work:
+ Column Stats Desc:
+ Columns: value
+ Column Types: string
+ Table: default.partition_mv_sdp
Stage: Stage-5
Materialized View Work
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
index 735a4db..5714ef8 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n3.deptno SCRIPT []
POSTHOOK: Lineage: emps_n3.empid SCRIPT []
POSTHOOK: Lineage: emps_n3.name SCRIPT []
POSTHOOK: Lineage: emps_n3.salary SCRIPT []
-PREHOOK: query: analyze table emps_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n3
-PREHOOK: Output: default@emps_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n3
-POSTHOOK: Output: default@emps_n3
-#### A masked pattern was here ####
PREHOOK: query: create table depts_n2 (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts_n2
POSTHOOK: Lineage: depts_n2.deptno SCRIPT []
POSTHOOK: Lineage: depts_n2.locationid SCRIPT []
POSTHOOK: Lineage: depts_n2.name SCRIPT []
-PREHOOK: query: analyze table depts_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts_n2
-PREHOOK: Output: default@depts_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts_n2
-POSTHOOK: Output: default@depts_n2
-#### A masked pattern was here ####
PREHOOK: query: create table dependents_n2 (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents_n2
POSTHOOK: Lineage: dependents_n2.empid SCRIPT []
POSTHOOK: Lineage: dependents_n2.name SCRIPT []
-PREHOOK: query: analyze table dependents_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents_n2
-PREHOOK: Output: default@dependents_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents_n2
-POSTHOOK: Output: default@dependents_n2
-#### A masked pattern was here ####
PREHOOK: query: create table locations_n2 (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations_n2
POSTHOOK: Lineage: locations_n2.locationid SCRIPT []
POSTHOOK: Lineage: locations_n2.name SCRIPT []
-PREHOOK: query: analyze table locations_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations_n2
-PREHOOK: Output: default@locations_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations_n2
-POSTHOOK: Output: default@locations_n2
-#### A masked pattern was here ####
PREHOOK: query: alter table emps_n3 add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps_n3 add constraint pk1 primary key (empid) disable novalidate rely
@@ -184,16 +144,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select *
from (select * from emps_n3 where empid < 120) t
@@ -331,16 +281,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps_n3.name, emps_n3.salary, emps_n3.commission
from emps_n3
@@ -422,16 +362,6 @@ POSTHOOK: Input: default@depts_n2
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid deptno from emps_n3
join depts_n2 using (deptno) where empid = 1
@@ -500,16 +430,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select * from emps_n3 where empid > 120
union all select * from emps_n3 where empid < 150
@@ -627,16 +547,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid, deptno from emps_n3 group by empid, deptno
PREHOOK: type: QUERY
@@ -695,16 +605,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid, name from emps_n3 group by empid, name
PREHOOK: type: QUERY
@@ -763,16 +663,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select name, salary from emps_n3 group by name, salary
PREHOOK: type: QUERY
@@ -834,16 +724,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select name from emps_n3 group by name
PREHOOK: type: QUERY
@@ -945,16 +825,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select name from emps_n3 where deptno = 10 group by name
PREHOOK: type: QUERY
@@ -1057,16 +927,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n3
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n2
-PREHOOK: query: analyze table mv1_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n2
-PREHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n2
-POSTHOOK: Output: default@mv1_n2
-#### A masked pattern was here ####
PREHOOK: query: explain
select name from emps_n3 group by name
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out
index 3ed5609..94940ac 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n10.deptno SCRIPT []
POSTHOOK: Lineage: emps_n10.empid SCRIPT []
POSTHOOK: Lineage: emps_n10.name SCRIPT []
POSTHOOK: Lineage: emps_n10.salary SCRIPT []
-PREHOOK: query: analyze table emps_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n10
-PREHOOK: Output: default@emps_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n10
-POSTHOOK: Output: default@emps_n10
-#### A masked pattern was here ####
PREHOOK: query: create materialized view mv1_n10 as
select deptno, sum(salary), count(salary) as a
from emps_n10 group by deptno
@@ -57,16 +47,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n10
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n10
-PREHOOK: query: analyze table mv1_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n10
-PREHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n10
-POSTHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
PREHOOK: query: explain
select deptno, avg(salary) as a
from emps_n10 group by deptno
@@ -132,16 +112,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n10
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n10
-PREHOOK: query: analyze table mv1_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n10
-PREHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n10
-POSTHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
PREHOOK: query: explain
select salary, avg(salary) as a
from emps_n10 group by salary
@@ -208,16 +178,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n10
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n10
-PREHOOK: query: analyze table mv1_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n10
-PREHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n10
-POSTHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
PREHOOK: query: explain
select salary, avg(salary) as a
from emps_n10 where salary > 0 group by salary
@@ -305,16 +265,6 @@ POSTHOOK: Lineage: emps_n10_2.deptno SCRIPT []
POSTHOOK: Lineage: emps_n10_2.empid SCRIPT []
POSTHOOK: Lineage: emps_n10_2.name SCRIPT []
POSTHOOK: Lineage: emps_n10_2.salary SCRIPT []
-PREHOOK: query: analyze table emps_n10_2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n10_2
-PREHOOK: Output: default@emps_n10_2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n10_2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n10_2
-POSTHOOK: Output: default@emps_n10_2
-#### A masked pattern was here ####
PREHOOK: query: create materialized view mv1_n10 as
select salary, sum(salary), count(salary) as a
from emps_n10_2 where salary > 0 group by salary
@@ -329,16 +279,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n10_2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n10
-PREHOOK: query: analyze table mv1_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n10
-PREHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n10
-POSTHOOK: Output: default@mv1_n10
-#### A masked pattern was here ####
PREHOOK: query: explain
select avg(salary)
from emps_n10_2 where salary > 0
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
index d5afe3f..f87b55b 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n0.deptno SCRIPT []
POSTHOOK: Lineage: emps_n0.empid SCRIPT []
POSTHOOK: Lineage: emps_n0.name SCRIPT []
POSTHOOK: Lineage: emps_n0.salary SCRIPT []
-PREHOOK: query: analyze table emps_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n0
-PREHOOK: Output: default@emps_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n0
-POSTHOOK: Output: default@emps_n0
-#### A masked pattern was here ####
PREHOOK: query: create table depts_n0 (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts_n0
POSTHOOK: Lineage: depts_n0.deptno SCRIPT []
POSTHOOK: Lineage: depts_n0.locationid SCRIPT []
POSTHOOK: Lineage: depts_n0.name SCRIPT []
-PREHOOK: query: analyze table depts_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts_n0
-PREHOOK: Output: default@depts_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts_n0
-POSTHOOK: Output: default@depts_n0
-#### A masked pattern was here ####
PREHOOK: query: create table dependents_n0 (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents_n0
POSTHOOK: Lineage: dependents_n0.empid SCRIPT []
POSTHOOK: Lineage: dependents_n0.name SCRIPT []
-PREHOOK: query: analyze table dependents_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents_n0
-PREHOOK: Output: default@dependents_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents_n0
-POSTHOOK: Output: default@dependents_n0
-#### A masked pattern was here ####
PREHOOK: query: create table locations_n0 (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations_n0
POSTHOOK: Lineage: locations_n0.locationid SCRIPT []
POSTHOOK: Lineage: locations_n0.name SCRIPT []
-PREHOOK: query: analyze table locations_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations_n0
-PREHOOK: Output: default@locations_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations_n0
-POSTHOOK: Output: default@locations_n0
-#### A masked pattern was here ####
PREHOOK: query: alter table emps_n0 add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps_n0 add constraint pk1 primary key (empid) disable novalidate rely
@@ -190,16 +150,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid from emps_n0
join depts_n0 using (deptno) where depts_n0.deptno > 20
@@ -278,16 +228,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid from emps_n0
join depts_n0 using (deptno) where depts_n0.deptno > 20
@@ -366,16 +306,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid from emps_n0
join depts_n0 using (deptno) where depts_n0.deptno > 20
@@ -454,16 +384,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n0.deptno from depts_n0
join emps_n0 using (deptno) where emps_n0.empid > 15
@@ -547,16 +467,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n0.deptno from depts_n0
join emps_n0 using (deptno) where emps_n0.empid > 15
@@ -693,7 +603,7 @@ POSTHOOK: query: drop materialized view mv1_n0
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n0
POSTHOOK: Output: default@mv1_n0
-Warning: Shuffle Join MERGEJOIN[18][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[28][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: create materialized view mv1_n0 as
select depts_n0.name, dependents_n0.name as name2, emps_n0.deptno, depts_n0.deptno as deptno2, dependents_n0.empid
from depts_n0, dependents_n0, emps_n0
@@ -716,16 +626,6 @@ POSTHOOK: Input: default@depts_n0
POSTHOOK: Input: default@emps_n0
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n0
-PREHOOK: query: analyze table mv1_n0 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n0
-PREHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n0 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n0
-POSTHOOK: Output: default@mv1_n0
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents_n0.empid
from depts_n0
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
index 91f6982..93bda76 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n9.deptno SCRIPT []
POSTHOOK: Lineage: emps_n9.empid SCRIPT []
POSTHOOK: Lineage: emps_n9.name SCRIPT []
POSTHOOK: Lineage: emps_n9.salary SCRIPT []
-PREHOOK: query: analyze table emps_n9 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n9
-PREHOOK: Output: default@emps_n9
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n9 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n9
-POSTHOOK: Output: default@emps_n9
-#### A masked pattern was here ####
PREHOOK: query: create table depts_n7 (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts_n7
POSTHOOK: Lineage: depts_n7.deptno SCRIPT []
POSTHOOK: Lineage: depts_n7.locationid SCRIPT []
POSTHOOK: Lineage: depts_n7.name SCRIPT []
-PREHOOK: query: analyze table depts_n7 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts_n7
-PREHOOK: Output: default@depts_n7
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts_n7 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts_n7
-POSTHOOK: Output: default@depts_n7
-#### A masked pattern was here ####
PREHOOK: query: create table dependents_n5 (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents_n5
POSTHOOK: Lineage: dependents_n5.empid SCRIPT []
POSTHOOK: Lineage: dependents_n5.name SCRIPT []
-PREHOOK: query: analyze table dependents_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents_n5
-PREHOOK: Output: default@dependents_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents_n5
-POSTHOOK: Output: default@dependents_n5
-#### A masked pattern was here ####
PREHOOK: query: create table locations_n5 (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations_n5
POSTHOOK: Lineage: locations_n5.locationid SCRIPT []
POSTHOOK: Lineage: locations_n5.name SCRIPT []
-PREHOOK: query: analyze table locations_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations_n5
-PREHOOK: Output: default@locations_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations_n5
-POSTHOOK: Output: default@locations_n5
-#### A masked pattern was here ####
PREHOOK: query: alter table emps_n9 add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps_n9 add constraint pk1 primary key (empid) disable novalidate rely
@@ -188,16 +148,6 @@ POSTHOOK: Input: default@depts_n7
POSTHOOK: Input: default@emps_n9
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n5
-PREHOOK: query: analyze table mv1_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n5
-PREHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n5
-POSTHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid deptno from emps_n9
join depts_n7 using (deptno) where empid = 1
@@ -270,16 +220,6 @@ POSTHOOK: Input: default@depts_n7
POSTHOOK: Input: default@emps_n9
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n5
-PREHOOK: query: analyze table mv1_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n5
-PREHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n5
-POSTHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid deptno from emps_n9
join depts_n7 using (deptno) where empid > 1
@@ -356,16 +296,6 @@ POSTHOOK: Input: default@depts_n7
POSTHOOK: Input: default@emps_n9
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n5
-PREHOOK: query: analyze table mv1_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n5
-PREHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n5
-POSTHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid deptno from emps_n9
join depts_n7 using (deptno) where empid = 1
@@ -440,16 +370,6 @@ POSTHOOK: Input: default@depts_n7
POSTHOOK: Input: default@emps_n9
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n5
-PREHOOK: query: analyze table mv1_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n5
-PREHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n5
-POSTHOOK: Output: default@mv1_n5
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents_n5.empid
from depts_n7
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
index 18efcba..2442ecc 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n5.deptno SCRIPT []
POSTHOOK: Lineage: emps_n5.empid SCRIPT []
POSTHOOK: Lineage: emps_n5.name SCRIPT []
POSTHOOK: Lineage: emps_n5.salary SCRIPT []
-PREHOOK: query: analyze table emps_n5 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n5
-PREHOOK: Output: default@emps_n5
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n5 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n5
-POSTHOOK: Output: default@emps_n5
-#### A masked pattern was here ####
PREHOOK: query: create table depts_n4 (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts_n4
POSTHOOK: Lineage: depts_n4.deptno SCRIPT []
POSTHOOK: Lineage: depts_n4.locationid SCRIPT []
POSTHOOK: Lineage: depts_n4.name SCRIPT []
-PREHOOK: query: analyze table depts_n4 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts_n4
-PREHOOK: Output: default@depts_n4
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts_n4 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts_n4
-POSTHOOK: Output: default@depts_n4
-#### A masked pattern was here ####
PREHOOK: query: create table dependents_n3 (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents_n3
POSTHOOK: Lineage: dependents_n3.empid SCRIPT []
POSTHOOK: Lineage: dependents_n3.name SCRIPT []
-PREHOOK: query: analyze table dependents_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents_n3
-PREHOOK: Output: default@dependents_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents_n3
-POSTHOOK: Output: default@dependents_n3
-#### A masked pattern was here ####
PREHOOK: query: create table locations_n3 (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations_n3
POSTHOOK: Lineage: locations_n3.locationid SCRIPT []
POSTHOOK: Lineage: locations_n3.name SCRIPT []
-PREHOOK: query: analyze table locations_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations_n3
-PREHOOK: Output: default@locations_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations_n3
-POSTHOOK: Output: default@locations_n3
-#### A masked pattern was here ####
PREHOOK: query: alter table emps_n5 add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps_n5 add constraint pk1 primary key (empid) disable novalidate rely
@@ -186,16 +146,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select name, count(*) as c, sum(empid) as s
from emps_n5 group by name
@@ -310,16 +260,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select salary, name, sum(empid) as s, count(*) as c
from emps_n5 group by name, salary
@@ -391,16 +331,6 @@ POSTHOOK: Input: default@depts_n4
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n4.deptno, count(*) as c, sum(empid) as s
from emps_n5 join depts_n4 using (deptno)
@@ -525,16 +455,6 @@ POSTHOOK: Input: default@depts_n4
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n4.deptno, sum(empid) as s
from emps_n5 join depts_n4 using (deptno)
@@ -654,16 +574,6 @@ POSTHOOK: Input: default@depts_n4
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n4.deptno, sum(empid) + 1 as s
from emps_n5 join depts_n4 using (deptno)
@@ -793,16 +703,6 @@ POSTHOOK: Input: default@depts_n4
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents_n3.empid, sum(salary) as s
from emps_n5
@@ -978,16 +878,6 @@ POSTHOOK: Input: default@dependents_n3
POSTHOOK: Input: default@emps_n5
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n3
-PREHOOK: query: analyze table mv1_n3 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n3
-PREHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n3 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n3
-POSTHOOK: Output: default@mv1_n3
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps_n5.deptno, count(distinct salary) as s
from emps_n5
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
index e4c939e..b865675 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_5.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps_n2.deptno SCRIPT []
POSTHOOK: Lineage: emps_n2.empid SCRIPT []
POSTHOOK: Lineage: emps_n2.name SCRIPT []
POSTHOOK: Lineage: emps_n2.salary SCRIPT []
-PREHOOK: query: analyze table emps_n2 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps_n2
-PREHOOK: Output: default@emps_n2
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps_n2 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps_n2
-POSTHOOK: Output: default@emps_n2
-#### A masked pattern was here ####
PREHOOK: query: create table depts_n1 (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts_n1
POSTHOOK: Lineage: depts_n1.deptno SCRIPT []
POSTHOOK: Lineage: depts_n1.locationid SCRIPT []
POSTHOOK: Lineage: depts_n1.name SCRIPT []
-PREHOOK: query: analyze table depts_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts_n1
-PREHOOK: Output: default@depts_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts_n1
-POSTHOOK: Output: default@depts_n1
-#### A masked pattern was here ####
PREHOOK: query: create table dependents_n1 (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents_n1
POSTHOOK: Lineage: dependents_n1.empid SCRIPT []
POSTHOOK: Lineage: dependents_n1.name SCRIPT []
-PREHOOK: query: analyze table dependents_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents_n1
-PREHOOK: Output: default@dependents_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents_n1
-POSTHOOK: Output: default@dependents_n1
-#### A masked pattern was here ####
PREHOOK: query: create table locations_n1 (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations_n1
POSTHOOK: Lineage: locations_n1.locationid SCRIPT []
POSTHOOK: Lineage: locations_n1.name SCRIPT []
-PREHOOK: query: analyze table locations_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations_n1
-PREHOOK: Output: default@locations_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations_n1
-POSTHOOK: Output: default@locations_n1
-#### A masked pattern was here ####
PREHOOK: query: alter table emps_n2 add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps_n2 add constraint pk1 primary key (empid) disable novalidate rely
@@ -200,16 +160,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select name from emps_n2 where deptno >= 20 group by name
PREHOOK: type: QUERY
@@ -314,16 +264,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select name, sum(empid) as s
from emps_n2 where deptno > 15 group by name
@@ -451,16 +391,6 @@ POSTHOOK: Input: default@emps_n2
POSTHOOK: Input: default@locations_n1
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents_n1.empid
from depts_n1
@@ -604,16 +534,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select deptno from emps_n2 group by deptno
PREHOOK: type: QUERY
@@ -719,16 +639,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select deptno, empid, sum(empid) as s, count(*) as c
from emps_n2 group by empid, deptno
@@ -803,16 +713,6 @@ POSTHOOK: Input: default@dependents_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents_n1.empid, sum(salary) as s
from emps_n2
@@ -945,16 +845,6 @@ POSTHOOK: Input: default@dependents_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select depts_n1.name, sum(salary) as s
from emps_n2
@@ -1102,7 +992,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[23][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select a.empid deptno from
(select * from emps_n2 where empid = 1) a
@@ -1125,16 +1015,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select a.empid from
(select * from emps_n2 where empid = 1) a
@@ -1192,7 +1072,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[23][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select a.empid, a.deptno from
(select * from emps_n2 where empid = 1) a
@@ -1215,16 +1095,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select a.empid from
(select * from emps_n2 where empid = 1) a
@@ -1300,16 +1170,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select empid from emps_n2 where empid = 1
PREHOOK: type: QUERY
@@ -1355,7 +1215,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[23][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select emps_n2.empid, emps_n2.deptno from emps_n2
join depts_n1 on (emps_n2.deptno = depts_n1.deptno)
@@ -1378,16 +1238,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps_n2.empid from emps_n2
join dependents_n1 on (emps_n2.empid = dependents_n1.empid)
@@ -1445,7 +1295,7 @@ POSTHOOK: query: drop materialized view mv1_n1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@mv1_n1
POSTHOOK: Output: default@mv1_n1
-Warning: Shuffle Join MERGEJOIN[13][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[23][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: create materialized view mv1_n1 as
select emps_n2.empid, emps_n2.deptno from emps_n2
join depts_n1 a on (emps_n2.deptno=a.deptno)
@@ -1470,16 +1320,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps_n2.empid from emps_n2
join dependents_n1 on (emps_n2.empid = dependents_n1.empid)
@@ -1561,16 +1401,6 @@ POSTHOOK: Input: default@depts_n1
POSTHOOK: Input: default@emps_n2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1_n1
-PREHOOK: query: analyze table mv1_n1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1_n1
-PREHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1_n1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1_n1
-POSTHOOK: Output: default@mv1_n1
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps_n2.empid from emps_n2
join dependents_n1 on (emps_n2.empid = dependents_n1.empid)
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
index 899e50a..b66cd57 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_6.q.out
@@ -33,16 +33,6 @@ POSTHOOK: Lineage: emps.deptno SCRIPT []
POSTHOOK: Lineage: emps.empid SCRIPT []
POSTHOOK: Lineage: emps.name SCRIPT []
POSTHOOK: Lineage: emps.salary SCRIPT []
-PREHOOK: query: analyze table emps compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@emps
-PREHOOK: Output: default@emps
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table emps compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@emps
-POSTHOOK: Output: default@emps
-#### A masked pattern was here ####
PREHOOK: query: create table depts (
deptno int,
name varchar(256),
@@ -70,16 +60,6 @@ POSTHOOK: Output: default@depts
POSTHOOK: Lineage: depts.deptno SCRIPT []
POSTHOOK: Lineage: depts.locationid SCRIPT []
POSTHOOK: Lineage: depts.name SCRIPT []
-PREHOOK: query: analyze table depts compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@depts
-PREHOOK: Output: default@depts
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table depts compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@depts
-POSTHOOK: Output: default@depts
-#### A masked pattern was here ####
PREHOOK: query: create table dependents (
empid int,
name varchar(256))
@@ -104,16 +84,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@dependents
POSTHOOK: Lineage: dependents.empid SCRIPT []
POSTHOOK: Lineage: dependents.name SCRIPT []
-PREHOOK: query: analyze table dependents compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@dependents
-PREHOOK: Output: default@dependents
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dependents compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@dependents
-POSTHOOK: Output: default@dependents
-#### A masked pattern was here ####
PREHOOK: query: create table locations (
locationid int,
name varchar(256))
@@ -138,16 +108,6 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@locations
POSTHOOK: Lineage: locations.locationid SCRIPT []
POSTHOOK: Lineage: locations.name SCRIPT []
-PREHOOK: query: analyze table locations compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@locations
-PREHOOK: Output: default@locations
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table locations compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@locations
-POSTHOOK: Output: default@locations
-#### A masked pattern was here ####
PREHOOK: query: alter table emps add constraint pk1 primary key (empid) disable novalidate rely
PREHOOK: type: ALTERTABLE_ADDCONSTRAINT
POSTHOOK: query: alter table emps add constraint pk1 primary key (empid) disable novalidate rely
@@ -202,16 +162,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1
-PREHOOK: query: analyze table mv1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1
-PREHOOK: Output: default@mv1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1
-POSTHOOK: Output: default@mv1
-#### A masked pattern was here ####
PREHOOK: query: explain
select salary, sum(empid) + 1 as s
from emps where deptno > 10 group by salary
@@ -327,16 +277,6 @@ POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1
-PREHOOK: query: analyze table mv1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1
-PREHOOK: Output: default@mv1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1
-POSTHOOK: Output: default@mv1
-#### A masked pattern was here ####
PREHOOK: query: explain
select salary + 1, sum(empid) + 1 as s
from emps where deptno > 15 group by salary
@@ -456,16 +396,6 @@ POSTHOOK: Input: default@depts
POSTHOOK: Input: default@emps
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1
-PREHOOK: query: analyze table mv1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1
-PREHOOK: Output: default@mv1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1
-POSTHOOK: Output: default@mv1
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents.empid
from emps
@@ -616,16 +546,6 @@ POSTHOOK: Input: default@depts
POSTHOOK: Input: default@emps
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1
-PREHOOK: query: analyze table mv1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1
-PREHOOK: Output: default@mv1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1
-POSTHOOK: Output: default@mv1
-#### A masked pattern was here ####
PREHOOK: query: explain
select dependents.empid
from depts
@@ -804,16 +724,6 @@ POSTHOOK: Input: default@dependents
POSTHOOK: Input: default@emps
POSTHOOK: Output: database:default
POSTHOOK: Output: default@mv1
-PREHOOK: query: analyze table mv1 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@mv1
-PREHOOK: Output: default@mv1
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table mv1 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@mv1
-POSTHOOK: Output: default@mv1
-#### A masked pattern was here ####
PREHOOK: query: explain
select emps.empid, dependents.empid, emps.deptno
from emps