Repository: hive Updated Branches: refs/heads/branch-3 812ae7388 -> 10e126e7b
Addendum to HIVE-19396 Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/10e126e7 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/10e126e7 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/10e126e7 Branch: refs/heads/branch-3 Commit: 10e126e7bcc37ea57a1b9814e1aa4ac7e178b9a4 Parents: 24b4666 Author: Ashutosh Chauhan <hashut...@apache.org> Authored: Thu May 3 21:28:47 2018 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Fri May 4 14:05:28 2018 -0700 ---------------------------------------------------------------------- .../materialized_view_create_rewrite_4.q.out | 312 ++++++++++--------- .../clientpositive/tez/explainanalyze_3.q.out | 8 +- .../clientpositive/tez/explainuser_3.q.out | 8 +- .../results/clientpositive/tez/tez-tag.q.out | 4 +- 4 files changed, 175 insertions(+), 157 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/10e126e7/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out index c0862b0..4ffea62 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out @@ -659,24 +659,49 @@ POSTHOOK: query: EXPLAIN ALTER MATERIALIZED VIEW cmv_mat_view REBUILD POSTHOOK: type: QUERY STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - Stage-4 depends on stages: Stage-3 + Stage-2 is a root stage + Stage-3 depends on stages: Stage-2 + Stage-0 depends on stages: Stage-3 + Stage-4 depends on stages: Stage-0 + Stage-6 depends on stages: Stage-4, Stage-5 + Stage-1 depends on stages: Stage-3 + Stage-5 depends on stages: Stage-1 STAGE PLANS: - Stage: Stage-1 + Stage: Stage-2 Tez #### A masked pattern was here #### Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) + Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 7 (ONE_TO_ONE_EDGE) + Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE) + Reducer 4 <- Reducer 2 (SIMPLE_EDGE) + Reducer 6 <- Map 5 (SIMPLE_EDGE), Map 8 (SIMPLE_EDGE) + Reducer 7 <- Reducer 6 (SIMPLE_EDGE) #### A masked pattern was here #### Vertices: Map 1 Map Operator Tree: TableScan + alias: default.cmv_mat_view + Statistics: Num rows: 2 Data size: 248 Basic stats: COMPLETE Column stats: COMPLETE + Filter Operator + predicate: ((c > 10) and a is not null) (type: boolean) + Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE + Select Operator + expressions: a (type: int), c (type: decimal(10,2)), _c2 (type: bigint), ROW__ID (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE + Reduce Output Operator + key expressions: _col0 (type: int), _col1 (type: decimal(10,2)) + sort order: ++ + Map-reduce partition columns: _col0 (type: int), _col1 (type: decimal(10,2)) + Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE + value expressions: _col2 (type: bigint), _col3 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) + Execution mode: llap + LLAP IO: may be used (ACID table) + Map 5 + Map Operator Tree: + TableScan alias: cmv_basetable Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator @@ -693,23 +718,23 @@ STAGE PLANS: Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Execution mode: llap LLAP IO: may be used (ACID table) - Map 4 + Map 8 Map Operator Tree: TableScan alias: cmv_basetable_2 Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator - predicate: ((c > 10) and a is not null) (type: boolean) + predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: a (type: int), c (type: decimal(10,2)), d (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 196 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 196 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: decimal(10,2)), _col2 (type: int) Execution mode: llap LLAP IO: may be used (ACID table) @@ -718,6 +743,89 @@ STAGE PLANS: Reduce Operator Tree: Merge Join Operator condition map: + Right Outer Join 0 to 1 + keys: + 0 _col0 (type: int), _col1 (type: decimal(10,2)) + 1 _col0 (type: int), _col1 (type: decimal(10,2)) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 + Statistics: Num rows: 1 Data size: 324 Basic stats: COMPLETE Column stats: COMPLETE + Filter Operator + predicate: (_col0 is null and _col1 is null) (type: boolean) + Statistics: Num rows: 1 Data size: 324 Basic stats: COMPLETE Column stats: COMPLETE + Select Operator + expressions: _col4 (type: int), _col5 (type: decimal(10,2)), CASE WHEN ((_col0 is null and _col1 is null)) THEN (_col6) ELSE ((_col6 + _col2)) END (type: bigint) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 124 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.cmv_mat_view + Write Type: INSERT + Select Operator + expressions: _col0 (type: int), _col1 (type: decimal(10,2)), _col2 (type: bigint) + outputColumnNames: a, c, _c2 + Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE + Group By Operator + aggregations: compute_stats(a, 'hll'), compute_stats(c, 'hll'), compute_stats(_c2, 'hll') + mode: hash + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: COMPLETE + Reduce Output Operator + sort order: + Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: COMPLETE + value expressions: _col0 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,min:decimal(10,2),max:decimal(10,2),countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) + Filter Operator + predicate: ((_col0 = _col4) and (_col1 = _col5)) (type: boolean) + Statistics: Num rows: 1 Data size: 324 Basic stats: COMPLETE Column stats: COMPLETE + Select Operator + expressions: _col3 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>), _col4 (type: int), _col5 (type: decimal(10,2)), CASE WHEN ((_col0 is null and _col1 is null)) THEN (_col6) ELSE ((_col6 + _col2)) END (type: bigint) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE + Reduce Output Operator + key expressions: _col0 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>) + sort order: + + Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE + value expressions: _col1 (type: int), _col2 (type: decimal(10,2)), _col3 (type: bigint) + Reducer 3 + Execution mode: llap + Reduce Operator Tree: + Group By Operator + aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2) + mode: mergepartial + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 1 Data size: 1528 Basic stats: COMPLETE Column stats: COMPLETE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 1528 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 4 + Execution mode: llap + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: struct<writeid:bigint,bucketid:int,rowid:bigint>), VALUE._col0 (type: int), VALUE._col1 (type: decimal(10,2)), VALUE._col2 (type: bigint) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 200 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.cmv_mat_view + Write Type: UPDATE + Reducer 6 + Execution mode: llap + Reduce Operator Tree: + Merge Join Operator + condition map: Inner Join 0 to 1 keys: 0 _col0 (type: int) @@ -736,7 +844,7 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: int), _col1 (type: decimal(10,2)) Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col2 (type: bigint) - Reducer 3 + Reducer 7 Execution mode: llap Reduce Operator Tree: Group By Operator @@ -745,37 +853,14 @@ STAGE PLANS: mode: mergepartial outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 124 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.cmv_mat_view - Write Type: INSERT - Select Operator - expressions: _col0 (type: int), _col1 (type: decimal(10,2)), _col2 (type: bigint) - outputColumnNames: a, c, _c2 + Reduce Output Operator + key expressions: _col0 (type: int), _col1 (type: decimal(10,2)) + sort order: ++ + Map-reduce partition columns: _col0 (type: int), _col1 (type: decimal(10,2)) Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: compute_stats(a, 'hll'), compute_stats(c, 'hll'), compute_stats(_c2, 'hll') - mode: complete - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col1 (type: struct<columntype:string,min:decimal(10,2),max:decimal(10,2),countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1480 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 1480 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 + value expressions: _col2 (type: bigint) - Stage: Stage-2 + Stage: Stage-3 Dependency Collection Stage: Stage-0 @@ -789,7 +874,25 @@ STAGE PLANS: name: default.cmv_mat_view Write Type: INSERT - Stage: Stage-3 + Stage: Stage-4 + Stats Work + Basic Stats Work: + + Stage: Stage-6 + Materialized View Work + + Stage: Stage-1 + Move Operator + tables: + replace: false + 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.cmv_mat_view + Write Type: UPDATE + + Stage: Stage-5 Stats Work Basic Stats Work: Column Stats Desc: @@ -797,20 +900,21 @@ STAGE PLANS: Column Types: int, decimal(10,2), bigint Table: default.cmv_mat_view - Stage: Stage-4 - Materialized View Work - PREHOOK: query: ALTER MATERIALIZED VIEW cmv_mat_view REBUILD PREHOOK: type: QUERY PREHOOK: Input: default@cmv_basetable PREHOOK: Input: default@cmv_basetable_2 +PREHOOK: Input: default@cmv_mat_view +PREHOOK: Output: default@cmv_mat_view PREHOOK: Output: default@cmv_mat_view POSTHOOK: query: ALTER MATERIALIZED VIEW cmv_mat_view REBUILD POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_basetable POSTHOOK: Input: default@cmv_basetable_2 +POSTHOOK: Input: default@cmv_mat_view POSTHOOK: Output: default@cmv_mat_view -POSTHOOK: Lineage: cmv_mat_view._c2 EXPRESSION [(cmv_basetable_2)cmv_basetable_2.FieldSchema(name:d, type:int, comment:null), ] +POSTHOOK: Output: default@cmv_mat_view +POSTHOOK: Lineage: cmv_mat_view._c2 EXPRESSION [(cmv_mat_view)default.cmv_mat_view.FieldSchema(name:a, type:int, comment:null), (cmv_mat_view)default.cmv_mat_view.FieldSchema(name:c, type:decimal(10,2), comment:null), (cmv_basetable_2)cmv_basetable_2.FieldSchema(name:d, type:int, comment:null), (cmv_mat_view)default.cmv_mat_view.FieldSchema(name:_c2, type:bigint, comment:null), ] POSTHOOK: Lineage: cmv_mat_view.a SIMPLE [(cmv_basetable)cmv_basetable.FieldSchema(name:a, type:int, comment:null), ] POSTHOOK: Lineage: cmv_mat_view.c SIMPLE [(cmv_basetable_2)cmv_basetable_2.FieldSchema(name:c, type:decimal(10,2), comment:null), ] PREHOOK: query: DESCRIBE FORMATTED cmv_mat_view @@ -831,12 +935,9 @@ Retention: 0 #### A masked pattern was here #### Table Type: MATERIALIZED_VIEW Table Parameters: - COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"_c2\":\"true\",\"a\":\"true\",\"c\":\"true\"}} bucketing_version 2 - numFiles 1 - numRows 3 - rawDataSize 0 - totalSize 805 + numFiles 3 + totalSize 1451 transactional true transactional_properties default #### A masked pattern was here #### @@ -873,106 +974,21 @@ WHERE cmv_basetable_2.c > 10.10 GROUP BY cmv_basetable.a, cmv_basetable_2.c POSTHOOK: type: QUERY STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 + Stage-0 is a root stage STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: cmv_basetable - Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: a is not null (type: boolean) - Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE - Execution mode: llap - LLAP IO: may be used (ACID table) - Map 4 - Map Operator Tree: - TableScan - alias: cmv_basetable_2 - Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: ((c > 10.1) and a is not null) (type: boolean) - Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), c (type: decimal(10,2)), d (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: decimal(10,2)), _col2 (type: int) - Execution mode: llap - LLAP IO: may be used (ACID table) - Reducer 2 - Execution mode: llap - Reduce Operator Tree: - Merge Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: int) - 1 _col0 (type: int) - outputColumnNames: _col0, _col2, _col3 - Statistics: Num rows: 2 Data size: 240 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: sum(_col3) - keys: _col0 (type: int), _col2 (type: decimal(10,2)) - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: decimal(10,2)) - sort order: ++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: decimal(10,2)) - Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col2 (type: bigint) - Reducer 3 - Execution mode: llap - Reduce Operator Tree: - Group By Operator - aggregations: sum(VALUE._col0) - keys: KEY._col0 (type: int), KEY._col1 (type: decimal(10,2)) - mode: mergepartial - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 124 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: int), _col2 (type: bigint) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 12 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-0 Fetch Operator limit: -1 Processor Tree: - ListSink + TableScan + alias: default.cmv_mat_view + Filter Operator + predicate: (c > 10.1) (type: boolean) + Select Operator + expressions: a (type: int), _c2 (type: bigint) + outputColumnNames: _col0, _col1 + ListSink PREHOOK: query: SELECT cmv_basetable.a, sum(cmv_basetable_2.d) FROM cmv_basetable JOIN cmv_basetable_2 ON (cmv_basetable.a = cmv_basetable_2.a) @@ -981,6 +997,7 @@ GROUP BY cmv_basetable.a, cmv_basetable_2.c PREHOOK: type: QUERY PREHOOK: Input: default@cmv_basetable PREHOOK: Input: default@cmv_basetable_2 +PREHOOK: Input: default@cmv_mat_view #### A masked pattern was here #### POSTHOOK: query: SELECT cmv_basetable.a, sum(cmv_basetable_2.d) FROM cmv_basetable JOIN cmv_basetable_2 ON (cmv_basetable.a = cmv_basetable_2.a) @@ -989,10 +1006,11 @@ GROUP BY cmv_basetable.a, cmv_basetable_2.c POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_basetable POSTHOOK: Input: default@cmv_basetable_2 +POSTHOOK: Input: default@cmv_mat_view #### A masked pattern was here #### 1 2 -3 2 3 6 +3 2 PREHOOK: query: UPDATE cmv_basetable_2 SET a=2 WHERE a=1 PREHOOK: type: QUERY PREHOOK: Input: default@cmv_basetable_2 http://git-wip-us.apache.org/repos/asf/hive/blob/10e126e7/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out index 8da42f4..b2cfb06 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out @@ -235,19 +235,19 @@ Stage-2 default@src_stats,src_stats,Tbl:COMPLETE,Col:COMPLETE PREHOOK: query: analyze table src_stats compute statistics for columns -PREHOOK: type: QUERY +PREHOOK: type: ANALYZE_TABLE PREHOOK: Input: default@src_stats PREHOOK: Output: default@src_stats PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: analyze table src_stats compute statistics for columns -POSTHOOK: type: QUERY +POSTHOOK: type: ANALYZE_TABLE POSTHOOK: Input: default@src_stats POSTHOOK: Output: default@src_stats POSTHOOK: Output: hdfs://### HDFS PATH ### PREHOOK: query: explain analyze analyze table src_stats compute statistics for columns -PREHOOK: type: QUERY +PREHOOK: type: ANALYZE_TABLE POSTHOOK: query: explain analyze analyze table src_stats compute statistics for columns -POSTHOOK: type: QUERY +POSTHOOK: type: ANALYZE_TABLE Vertex dependency in root stage Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) http://git-wip-us.apache.org/repos/asf/hive/blob/10e126e7/ql/src/test/results/clientpositive/tez/explainuser_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out index f87ee43..6f15c01 100644 --- a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out @@ -17,12 +17,12 @@ POSTHOOK: Output: default@acid_vectorized POSTHOOK: Lineage: acid_vectorized.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: acid_vectorized.b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] PREHOOK: query: analyze table acid_vectorized compute statistics for columns -PREHOOK: type: QUERY +PREHOOK: type: ANALYZE_TABLE PREHOOK: Input: default@acid_vectorized PREHOOK: Output: default@acid_vectorized PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: analyze table acid_vectorized compute statistics for columns -POSTHOOK: type: QUERY +POSTHOOK: type: ANALYZE_TABLE POSTHOOK: Input: default@acid_vectorized POSTHOOK: Output: default@acid_vectorized POSTHOOK: Output: hdfs://### HDFS PATH ### @@ -197,9 +197,9 @@ Stage-2 default@src,src,Tbl:COMPLETE,Col:COMPLETE PREHOOK: query: explain analyze table src compute statistics for columns -PREHOOK: type: QUERY +PREHOOK: type: ANALYZE_TABLE POSTHOOK: query: explain analyze table src compute statistics for columns -POSTHOOK: type: QUERY +POSTHOOK: type: ANALYZE_TABLE Vertex dependency in root stage Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE) http://git-wip-us.apache.org/repos/asf/hive/blob/10e126e7/ql/src/test/results/clientpositive/tez/tez-tag.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez-tag.q.out b/ql/src/test/results/clientpositive/tez/tez-tag.q.out index 2ba1f6e..9f6e5d5 100644 --- a/ql/src/test/results/clientpositive/tez/tez-tag.q.out +++ b/ql/src/test/results/clientpositive/tez/tez-tag.q.out @@ -158,12 +158,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@tab2 POSTHOOK: Output: default@tab2 PREHOOK: query: analyze table tab2 compute statistics for columns -PREHOOK: type: QUERY +PREHOOK: type: ANALYZE_TABLE PREHOOK: Input: default@tab2 PREHOOK: Output: default@tab2 PREHOOK: Output: hdfs://### HDFS PATH ### POSTHOOK: query: analyze table tab2 compute statistics for columns -POSTHOOK: type: QUERY +POSTHOOK: type: ANALYZE_TABLE POSTHOOK: Input: default@tab2 POSTHOOK: Output: default@tab2 POSTHOOK: Output: hdfs://### HDFS PATH ###