Repository: hive Updated Branches: refs/heads/beeline-cli 2243de3b2 -> 00e0d55a8
http://git-wip-us.apache.org/repos/asf/hive/blob/8842dcaf/ql/src/test/results/clientpositive/tez/explainuser_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainuser_2.q.out b/ql/src/test/results/clientpositive/tez/explainuser_2.q.out index 222e89e..95924aa 100644 --- a/ql/src/test/results/clientpositive/tez/explainuser_2.q.out +++ b/ql/src/test/results/clientpositive/tez/explainuser_2.q.out @@ -260,6 +260,7 @@ Stage-0 TableScan [TS_5] alias:x Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: EXPLAIN select ss.k1,sr.k2,cs.k3,count(ss.v1),count(sr.v2),count(cs.v3) @@ -319,15 +320,15 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE) +Reducer 11 <- Map 10 (SIMPLE_EDGE), Reducer 13 (SIMPLE_EDGE) Reducer 13 <- Map 12 (SIMPLE_EDGE), Map 14 (SIMPLE_EDGE) +Reducer 16 <- Map 15 (SIMPLE_EDGE), Map 17 (SIMPLE_EDGE) +Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE) Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE) -Reducer 11 <- Map 10 (SIMPLE_EDGE), Reducer 13 (SIMPLE_EDGE) -Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Reducer 4 <- Reducer 3 (SIMPLE_EDGE) -Reducer 9 <- Reducer 16 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE) +Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Reducer 8 <- Map 7 (SIMPLE_EDGE), Reducer 11 (SIMPLE_EDGE) -Reducer 16 <- Map 15 (SIMPLE_EDGE), Map 17 (SIMPLE_EDGE) +Reducer 9 <- Reducer 16 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -573,6 +574,7 @@ Stage-0 TableScan [TS_14] alias:ss Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -594,17 +596,17 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 12 <- Map 11 (SIMPLE_EDGE), Reducer 16 (SIMPLE_EDGE), Union 3 (CONTAINS) Map 13 <- Union 14 (CONTAINS) +Map 17 <- Union 14 (CONTAINS) Map 5 <- Union 6 (CONTAINS) -Reducer 4 <- Union 3 (SIMPLE_EDGE) -Reducer 7 <- Union 6 (SIMPLE_EDGE) Map 9 <- Union 6 (CONTAINS) -Reducer 8 <- Map 10 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE) +Reducer 12 <- Map 11 (SIMPLE_EDGE), Reducer 16 (SIMPLE_EDGE), Union 3 (CONTAINS) Reducer 15 <- Union 14 (SIMPLE_EDGE) Reducer 16 <- Map 18 (SIMPLE_EDGE), Reducer 15 (SIMPLE_EDGE) -Map 17 <- Union 14 (CONTAINS) +Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE), Union 3 (CONTAINS) +Reducer 4 <- Union 3 (SIMPLE_EDGE) +Reducer 7 <- Union 6 (SIMPLE_EDGE) +Reducer 8 <- Map 10 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -846,6 +848,7 @@ Stage-0 TableScan [TS_31] alias:y Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -875,29 +878,29 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Reducer 32 <- Union 31 (SIMPLE_EDGE) Map 11 <- Union 8 (CONTAINS) -Reducer 14 <- Map 13 (SIMPLE_EDGE), Reducer 20 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 30 <- Union 29 (SIMPLE_EDGE), Union 31 (CONTAINS) -Reducer 25 <- Map 24 (SIMPLE_EDGE), Reducer 33 (SIMPLE_EDGE), Union 5 (CONTAINS) -Map 22 <- Union 18 (CONTAINS) +Map 15 <- Union 16 (CONTAINS) Map 21 <- Union 16 (CONTAINS) +Map 22 <- Union 18 (CONTAINS) +Map 26 <- Union 27 (CONTAINS) Map 34 <- Union 27 (CONTAINS) +Map 35 <- Union 29 (CONTAINS) +Map 36 <- Union 31 (CONTAINS) +Map 7 <- Union 8 (CONTAINS) Reducer 10 <- Map 12 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE) -Reducer 33 <- Map 37 (SIMPLE_EDGE), Reducer 32 (SIMPLE_EDGE) +Reducer 14 <- Map 13 (SIMPLE_EDGE), Reducer 20 (SIMPLE_EDGE), Union 3 (CONTAINS) +Reducer 17 <- Union 16 (SIMPLE_EDGE), Union 18 (CONTAINS) +Reducer 19 <- Union 18 (SIMPLE_EDGE) +Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 3 (CONTAINS) Reducer 20 <- Map 23 (SIMPLE_EDGE), Reducer 19 (SIMPLE_EDGE) -Map 36 <- Union 31 (CONTAINS) -Map 35 <- Union 29 (CONTAINS) +Reducer 25 <- Map 24 (SIMPLE_EDGE), Reducer 33 (SIMPLE_EDGE), Union 5 (CONTAINS) +Reducer 28 <- Union 27 (SIMPLE_EDGE), Union 29 (CONTAINS) +Reducer 30 <- Union 29 (SIMPLE_EDGE), Union 31 (CONTAINS) +Reducer 32 <- Union 31 (SIMPLE_EDGE) +Reducer 33 <- Map 37 (SIMPLE_EDGE), Reducer 32 (SIMPLE_EDGE) Reducer 4 <- Union 3 (SIMPLE_EDGE), Union 5 (CONTAINS) -Reducer 19 <- Union 18 (SIMPLE_EDGE) Reducer 6 <- Union 5 (SIMPLE_EDGE) Reducer 9 <- Union 8 (SIMPLE_EDGE) -Reducer 17 <- Union 16 (SIMPLE_EDGE), Union 18 (CONTAINS) -Map 15 <- Union 16 (CONTAINS) -Reducer 28 <- Union 27 (SIMPLE_EDGE), Union 29 (CONTAINS) -Map 26 <- Union 27 (CONTAINS) -Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 3 (CONTAINS) -Map 7 <- Union 8 (CONTAINS) Stage-0 Fetch Operator @@ -1369,6 +1372,7 @@ Stage-0 TableScan [TS_2] alias:x Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: EXPLAIN SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -1447,6 +1451,7 @@ Stage-0 TableScan [TS_2] alias:z Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: EXPLAIN select ss.k1,sr.k2,cs.k3,count(ss.v1),count(sr.v2),count(cs.v3) @@ -1506,11 +1511,11 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Map 2 <- Map 1 (BROADCAST_EDGE) Map 10 <- Map 9 (BROADCAST_EDGE) +Map 2 <- Map 1 (BROADCAST_EDGE) Map 5 <- Map 10 (BROADCAST_EDGE), Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE) -Reducer 7 <- Reducer 6 (SIMPLE_EDGE) Reducer 6 <- Map 5 (SIMPLE_EDGE) +Reducer 7 <- Reducer 6 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -1710,6 +1715,7 @@ Stage-0 TableScan [TS_11] alias:srcpart Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, z.value, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -1731,15 +1737,15 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Reducer 3 <- Union 2 (SIMPLE_EDGE) -Reducer 12 <- Map 14 (BROADCAST_EDGE), Union 11 (SIMPLE_EDGE) -Map 13 <- Union 11 (CONTAINS) Map 1 <- Reducer 6 (BROADCAST_EDGE), Union 2 (CONTAINS) Map 10 <- Union 11 (CONTAINS) +Map 13 <- Union 11 (CONTAINS) Map 4 <- Union 5 (CONTAINS) Map 7 <- Union 5 (CONTAINS) -Reducer 6 <- Map 8 (BROADCAST_EDGE), Union 5 (SIMPLE_EDGE) Map 9 <- Reducer 12 (BROADCAST_EDGE), Union 2 (CONTAINS) +Reducer 12 <- Map 14 (BROADCAST_EDGE), Union 11 (SIMPLE_EDGE) +Reducer 3 <- Union 2 (SIMPLE_EDGE) +Reducer 6 <- Map 8 (BROADCAST_EDGE), Union 5 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -1957,6 +1963,7 @@ Stage-0 TableScan [TS_27] alias:y Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -1986,26 +1993,26 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage +Map 1 <- Reducer 8 (BROADCAST_EDGE), Union 2 (CONTAINS) +Map 11 <- Reducer 16 (BROADCAST_EDGE), Union 2 (CONTAINS) Map 12 <- Union 13 (CONTAINS) +Map 17 <- Union 13 (CONTAINS) +Map 18 <- Union 15 (CONTAINS) +Map 20 <- Reducer 27 (BROADCAST_EDGE), Union 4 (CONTAINS) +Map 21 <- Union 22 (CONTAINS) +Map 28 <- Union 22 (CONTAINS) +Map 29 <- Union 24 (CONTAINS) Map 30 <- Union 26 (CONTAINS) -Reducer 23 <- Union 22 (SIMPLE_EDGE), Union 24 (CONTAINS) +Map 6 <- Union 7 (CONTAINS) +Map 9 <- Union 7 (CONTAINS) Reducer 14 <- Union 13 (SIMPLE_EDGE), Union 15 (CONTAINS) -Map 11 <- Reducer 16 (BROADCAST_EDGE), Union 2 (CONTAINS) +Reducer 16 <- Map 19 (BROADCAST_EDGE), Union 15 (SIMPLE_EDGE) +Reducer 23 <- Union 22 (SIMPLE_EDGE), Union 24 (CONTAINS) Reducer 25 <- Union 24 (SIMPLE_EDGE), Union 26 (CONTAINS) -Map 21 <- Union 22 (CONTAINS) -Map 1 <- Reducer 8 (BROADCAST_EDGE), Union 2 (CONTAINS) -Map 20 <- Reducer 27 (BROADCAST_EDGE), Union 4 (CONTAINS) -Reducer 5 <- Union 4 (SIMPLE_EDGE) -Map 29 <- Union 24 (CONTAINS) -Reducer 8 <- Map 10 (BROADCAST_EDGE), Union 7 (SIMPLE_EDGE) Reducer 27 <- Map 31 (BROADCAST_EDGE), Union 26 (SIMPLE_EDGE) -Map 28 <- Union 22 (CONTAINS) -Map 18 <- Union 15 (CONTAINS) -Reducer 16 <- Map 19 (BROADCAST_EDGE), Union 15 (SIMPLE_EDGE) -Map 17 <- Union 13 (CONTAINS) Reducer 3 <- Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS) -Map 6 <- Union 7 (CONTAINS) -Map 9 <- Union 7 (CONTAINS) +Reducer 5 <- Union 4 (SIMPLE_EDGE) +Reducer 8 <- Map 10 (BROADCAST_EDGE), Union 7 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -2438,6 +2445,7 @@ Stage-0 TableScan [TS_0] alias:y Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -2605,6 +2613,7 @@ Stage-0 TableScan [TS_0] alias:s1 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain select s1.key as key, s1.value as value from tab s1 join tab s3 on s1.key=s3.key join tab s2 on s1.value=s2.value PREHOOK: type: QUERY @@ -2667,6 +2676,7 @@ Stage-0 TableScan [TS_2] alias:s2 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain select s1.key as key, s1.value as value from tab s1 join tab2 s3 on s1.key=s3.key PREHOOK: type: QUERY @@ -2702,6 +2712,7 @@ Stage-0 TableScan [TS_0] alias:s1 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain select s1.key as key, s1.value as value from tab s1 join tab2 s3 on s1.key=s3.key join tab2 s2 on s1.value=s2.value PREHOOK: type: QUERY @@ -2764,6 +2775,7 @@ Stage-0 TableScan [TS_2] alias:s2 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain select count(*) from (select s1.key as key, s1.value as value from tab s1 join tab s3 on s1.key=s3.key UNION ALL @@ -2779,10 +2791,10 @@ POSTHOOK: type: QUERY Plan not optimized by CBO due to missing statistics. Please check log for more details. Vertex dependency in root stage -Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE) Map 1 <- Union 2 (CONTAINS) -Reducer 4 <- Reducer 3 (SIMPLE_EDGE) Map 6 <- Union 2 (CONTAINS) +Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE) +Reducer 4 <- Reducer 3 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -2862,6 +2874,7 @@ Stage-0 TableScan [TS_8] alias:s2 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain select count(*) from (select s1.key as key, s1.value as value from tab s1 join tab s3 on s1.key=s3.key join tab s2 on s1.value=s2.value UNION ALL @@ -2877,10 +2890,10 @@ POSTHOOK: type: QUERY Plan not optimized by CBO due to missing statistics. Please check log for more details. Vertex dependency in root stage +Map 8 <- Union 3 (CONTAINS) Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 7 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Reducer 4 <- Map 9 (SIMPLE_EDGE), Union 3 (SIMPLE_EDGE) -Map 8 <- Union 3 (CONTAINS) +Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -2984,6 +2997,7 @@ Stage-0 TableScan [TS_14] alias:s2 Statistics:Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -3014,18 +3028,18 @@ Plan optimized by CBO. Vertex dependency in root stage Map 12 <- Union 9 (CONTAINS) -Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 3 (CONTAINS) Map 13 <- Union 9 (CONTAINS) -Map 21 <- Map 20 (BROADCAST_EDGE) -Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE) -Map 19 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) Map 16 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) -Map 18 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) Map 17 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) -Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS), Union 5 (SIMPLE_EDGE) +Map 18 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) +Map 19 <- Map 21 (BROADCAST_EDGE), Union 3 (CONTAINS) +Map 21 <- Map 20 (BROADCAST_EDGE) Map 4 <- Map 7 (BROADCAST_EDGE), Union 5 (CONTAINS) Map 6 <- Map 7 (BROADCAST_EDGE), Union 5 (CONTAINS) Map 8 <- Union 9 (CONTAINS) +Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE) +Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 3 (CONTAINS) +Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS), Union 5 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -3377,6 +3391,7 @@ Stage-0 TableScan [TS_4] alias:y Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain SELECT x.key, y.value FROM src1 x JOIN src y ON (x.key = y.key) @@ -3406,27 +3421,27 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage +Map 10 <- Union 8 (CONTAINS) Map 12 <- Union 13 (CONTAINS) -Map 30 <- Union 24 (CONTAINS) -Reducer 14 <- Union 13 (SIMPLE_EDGE), Union 15 (CONTAINS) +Map 19 <- Union 13 (CONTAINS) +Map 20 <- Union 15 (CONTAINS) Map 23 <- Union 24 (CONTAINS) -Map 32 <- Union 28 (CONTAINS) -Reducer 25 <- Union 24 (SIMPLE_EDGE), Union 26 (CONTAINS) +Map 30 <- Union 24 (CONTAINS) Map 31 <- Union 26 (CONTAINS) +Map 32 <- Union 28 (CONTAINS) Map 34 <- Map 33 (BROADCAST_EDGE) -Map 20 <- Union 15 (CONTAINS) -Map 10 <- Union 8 (CONTAINS) -Reducer 4 <- Union 3 (SIMPLE_EDGE), Union 5 (CONTAINS) -Map 19 <- Union 13 (CONTAINS) -Reducer 6 <- Union 5 (SIMPLE_EDGE) -Reducer 9 <- Map 11 (BROADCAST_EDGE), Union 8 (SIMPLE_EDGE) +Map 7 <- Union 8 (CONTAINS) +Reducer 14 <- Union 13 (SIMPLE_EDGE), Union 15 (CONTAINS) +Reducer 16 <- Union 15 (SIMPLE_EDGE) Reducer 17 <- Map 21 (SIMPLE_EDGE), Reducer 16 (SIMPLE_EDGE) -Reducer 27 <- Union 26 (SIMPLE_EDGE), Union 28 (CONTAINS) Reducer 18 <- Map 22 (SIMPLE_EDGE), Reducer 17 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 29 <- Map 34 (BROADCAST_EDGE), Union 28 (SIMPLE_EDGE), Union 5 (CONTAINS) -Reducer 16 <- Union 15 (SIMPLE_EDGE) Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE), Union 3 (CONTAINS) -Map 7 <- Union 8 (CONTAINS) +Reducer 25 <- Union 24 (SIMPLE_EDGE), Union 26 (CONTAINS) +Reducer 27 <- Union 26 (SIMPLE_EDGE), Union 28 (CONTAINS) +Reducer 29 <- Map 34 (BROADCAST_EDGE), Union 28 (SIMPLE_EDGE), Union 5 (CONTAINS) +Reducer 4 <- Union 3 (SIMPLE_EDGE), Union 5 (CONTAINS) +Reducer 6 <- Union 5 (SIMPLE_EDGE) +Reducer 9 <- Map 11 (BROADCAST_EDGE), Union 8 (SIMPLE_EDGE) Stage-0 Fetch Operator @@ -3880,6 +3895,7 @@ Stage-0 TableScan [TS_80] alias:y Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: CREATE TABLE a(key STRING, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -3945,20 +3961,20 @@ POSTHOOK: type: QUERY Plan not optimized by CBO. Vertex dependency in root stage -Map 12 <- Union 9 (CONTAINS) -Reducer 14 <- Map 13 (SIMPLE_EDGE), Map 15 (SIMPLE_EDGE) -Map 11 <- Union 9 (CONTAINS) -Map 21 <- Map 20 (BROADCAST_EDGE) Map 1 <- Union 2 (CONTAINS) -Reducer 10 <- Reducer 14 (SIMPLE_EDGE), Union 4 (CONTAINS), Union 9 (SIMPLE_EDGE) -Map 19 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) +Map 11 <- Union 9 (CONTAINS) +Map 12 <- Union 9 (CONTAINS) Map 16 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) -Map 18 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) Map 17 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) -Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS) +Map 18 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) +Map 19 <- Map 21 (BROADCAST_EDGE), Union 4 (CONTAINS) +Map 21 <- Map 20 (BROADCAST_EDGE) Map 5 <- Union 2 (CONTAINS) Map 7 <- Map 6 (BROADCAST_EDGE) Map 8 <- Union 9 (CONTAINS) +Reducer 10 <- Reducer 14 (SIMPLE_EDGE), Union 4 (CONTAINS), Union 9 (SIMPLE_EDGE) +Reducer 14 <- Map 13 (SIMPLE_EDGE), Map 15 (SIMPLE_EDGE) +Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS) Stage-15 Stats-Aggr Operator @@ -4401,6 +4417,7 @@ Stage-11 Stage-5 Stats-Aggr Operator Please refer to the previous Stage-0 + PREHOOK: query: explain FROM ( @@ -4436,28 +4453,28 @@ POSTHOOK: type: QUERY Plan not optimized by CBO. Vertex dependency in root stage -Map 12 <- Union 13 (CONTAINS) -Map 30 <- Union 24 (CONTAINS) +Map 1 <- Union 2 (CONTAINS) Map 11 <- Map 10 (BROADCAST_EDGE) -Reducer 14 <- Union 13 (SIMPLE_EDGE), Union 15 (CONTAINS) +Map 12 <- Union 13 (CONTAINS) +Map 18 <- Union 13 (CONTAINS) +Map 19 <- Union 15 (CONTAINS) Map 23 <- Union 24 (CONTAINS) -Map 32 <- Union 28 (CONTAINS) -Reducer 25 <- Union 24 (SIMPLE_EDGE), Union 26 (CONTAINS) +Map 30 <- Union 24 (CONTAINS) Map 31 <- Union 26 (CONTAINS) +Map 32 <- Union 28 (CONTAINS) Map 34 <- Map 33 (BROADCAST_EDGE) -Map 1 <- Union 2 (CONTAINS) -Reducer 21 <- Map 20 (SIMPLE_EDGE), Map 22 (SIMPLE_EDGE) -Reducer 4 <- Map 11 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE), Union 5 (CONTAINS) -Map 19 <- Union 15 (CONTAINS) -Reducer 6 <- Union 5 (SIMPLE_EDGE), Union 7 (CONTAINS) +Map 9 <- Union 2 (CONTAINS) +Reducer 14 <- Union 13 (SIMPLE_EDGE), Union 15 (CONTAINS) +Reducer 16 <- Union 15 (SIMPLE_EDGE) Reducer 17 <- Reducer 16 (SIMPLE_EDGE), Reducer 21 (SIMPLE_EDGE), Union 5 (CONTAINS) -Reducer 8 <- Union 7 (SIMPLE_EDGE) +Reducer 21 <- Map 20 (SIMPLE_EDGE), Map 22 (SIMPLE_EDGE) +Reducer 25 <- Union 24 (SIMPLE_EDGE), Union 26 (CONTAINS) Reducer 27 <- Union 26 (SIMPLE_EDGE), Union 28 (CONTAINS) -Map 18 <- Union 13 (CONTAINS) Reducer 29 <- Map 34 (BROADCAST_EDGE), Union 28 (SIMPLE_EDGE), Union 7 (CONTAINS) -Reducer 16 <- Union 15 (SIMPLE_EDGE) Reducer 3 <- Union 2 (SIMPLE_EDGE) -Map 9 <- Union 2 (CONTAINS) +Reducer 4 <- Map 11 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE), Union 5 (CONTAINS) +Reducer 6 <- Union 5 (SIMPLE_EDGE), Union 7 (CONTAINS) +Reducer 8 <- Union 7 (SIMPLE_EDGE) Stage-7 Stats-Aggr Operator @@ -4920,6 +4937,7 @@ Stage-5 Move Operator table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.a","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} Please refer to the previous Stage-4 + PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -4953,10 +4971,10 @@ POSTHOOK: type: QUERY Plan not optimized by CBO. Vertex dependency in root stage +Map 6 <- Union 3 (CONTAINS) Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Reducer 4 <- Union 3 (SIMPLE_EDGE) -Map 6 <- Union 3 (CONTAINS) +Reducer 5 <- Reducer 4 (SIMPLE_EDGE) Stage-5 Stats-Aggr Operator @@ -5058,6 +5076,7 @@ Stage-4 Move Operator table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.dest1","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} Please refer to the previous Stage-3 + PREHOOK: query: EXPLAIN FROM UNIQUEJOIN PRESERVE src a (a.key), PRESERVE src1 b (b.key), PRESERVE srcpart c (c.key) SELECT a.key, b.key, c.key PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN FROM UNIQUEJOIN PRESERVE src a (a.key), PRESERVE src1 b (b.key), PRESERVE srcpart c (c.key) SELECT a.key, b.key, c.key @@ -5111,6 +5130,7 @@ Stage-0 TableScan [TS_2] alias:c Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: EXPLAIN SELECT TRANSFORM(a.key, a.value) USING 'cat' AS (tkey, tvalue) @@ -5171,6 +5191,7 @@ Stage-0 TableScan [TS_1] alias:b Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + PREHOOK: query: explain FROM ( select key, value from ( @@ -5200,11 +5221,11 @@ POSTHOOK: type: QUERY Plan not optimized by CBO. Vertex dependency in root stage +Map 6 <- Union 3 (CONTAINS) +Map 7 <- Union 3 (CONTAINS) Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 5 <- Union 3 (SIMPLE_EDGE) Reducer 4 <- Union 3 (SIMPLE_EDGE) -Map 7 <- Union 3 (CONTAINS) -Map 6 <- Union 3 (CONTAINS) +Reducer 5 <- Union 3 (SIMPLE_EDGE) Stage-5 Stats-Aggr Operator @@ -5347,6 +5368,7 @@ Stage-4 Move Operator table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.dest1","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} Please refer to the previous Stage-3 + PREHOOK: query: explain FROM ( select 'tst1' as key, cast(count(1) as string) as value, 'tst1' as value2 from src s1 @@ -5370,10 +5392,10 @@ POSTHOOK: type: QUERY Plan not optimized by CBO. Vertex dependency in root stage +Map 6 <- Union 3 (CONTAINS) Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS) -Reducer 5 <- Union 3 (SIMPLE_EDGE) Reducer 4 <- Union 3 (SIMPLE_EDGE) -Map 6 <- Union 3 (CONTAINS) +Reducer 5 <- Union 3 (SIMPLE_EDGE) Stage-5 Stats-Aggr Operator @@ -5494,3 +5516,4 @@ Stage-4 Move Operator table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.dest1","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} Please refer to the previous Stage-3 + http://git-wip-us.apache.org/repos/asf/hive/blob/8842dcaf/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 new file mode 100644 index 0000000..9358158 --- /dev/null +++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out @@ -0,0 +1,522 @@ +PREHOOK: query: explain select key, value +FROM srcpart LATERAL VIEW explode(array(1,2,3)) myTable AS myCol +PREHOOK: type: QUERY +POSTHOOK: query: explain select key, value +FROM srcpart LATERAL VIEW explode(array(1,2,3)) myTable AS myCol +POSTHOOK: type: QUERY +Plan not optimized by CBO. + +Stage-0 + Fetch Operator + limit:-1 + Select Operator [SEL_6] + outputColumnNames:["_col0","_col1"] + Lateral View Join Operator [LVJ_5] + outputColumnNames:["_col0","_col1","_col7"] + Select Operator [SEL_2] + outputColumnNames:["key","value"] + Lateral View Forward [LVF_1] + TableScan [TS_0] + alias:srcpart + Select Operator [SEL_6] + outputColumnNames:["_col0","_col1"] + Lateral View Join Operator [LVJ_5] + outputColumnNames:["_col0","_col1","_col7"] + UDTF Operator [UDTF_4] + function name:explode + Select Operator [SEL_3] + outputColumnNames:["_col0"] + Please refer to the previous Lateral View Forward [LVF_1] + +PREHOOK: query: explain show tables +PREHOOK: type: SHOWTABLES +POSTHOOK: query: explain show tables +POSTHOOK: type: SHOWTABLES +Stage-1 + Fetch Operator + limit:-1 + Stage-0 + Show Table Operator: + database name:default + +#### A masked pattern was here #### +PREHOOK: type: CREATEDATABASE +#### A masked pattern was here #### +POSTHOOK: type: CREATEDATABASE +Stage-0 + +#### A masked pattern was here #### +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:newDB +#### A masked pattern was here #### +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:newDB +#### A masked pattern was here #### +PREHOOK: query: explain describe database extended newDB +PREHOOK: type: DESCDATABASE +POSTHOOK: query: explain describe database extended newDB +POSTHOOK: type: DESCDATABASE +Stage-1 + Fetch Operator + limit:-1 + Stage-0 + +PREHOOK: query: describe database extended newDB +PREHOOK: type: DESCDATABASE +PREHOOK: Input: database:newdb +POSTHOOK: query: describe database extended newDB +POSTHOOK: type: DESCDATABASE +POSTHOOK: Input: database:newdb +newdb location/in/test hive_test_user USER +PREHOOK: query: explain use newDB +PREHOOK: type: SWITCHDATABASE +POSTHOOK: query: explain use newDB +POSTHOOK: type: SWITCHDATABASE +Stage-0 + +PREHOOK: query: use newDB +PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:newdb +POSTHOOK: query: use newDB +POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:newdb +PREHOOK: query: create table tab (name string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:newdb +PREHOOK: Output: newDB@tab +POSTHOOK: query: create table tab (name string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:newdb +POSTHOOK: Output: newDB@tab +PREHOOK: query: explain alter table tab rename to newName +PREHOOK: type: ALTERTABLE_RENAME +POSTHOOK: query: explain alter table tab rename to newName +POSTHOOK: type: ALTERTABLE_RENAME +Stage-0 + Alter Table Operator: + new name:newDB.newName + old name:newDB.tab + type:rename + +PREHOOK: query: explain drop table tab +PREHOOK: type: DROPTABLE +POSTHOOK: query: explain drop table tab +POSTHOOK: type: DROPTABLE +Stage-0 + Drop Table Operator: + table:tab + +PREHOOK: query: drop table tab +PREHOOK: type: DROPTABLE +PREHOOK: Input: newdb@tab +PREHOOK: Output: newdb@tab +POSTHOOK: query: drop table tab +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: newdb@tab +POSTHOOK: Output: newdb@tab +PREHOOK: query: explain use default +PREHOOK: type: SWITCHDATABASE +POSTHOOK: query: explain use default +POSTHOOK: type: SWITCHDATABASE +Stage-0 + +PREHOOK: query: use default +PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default +POSTHOOK: query: use default +POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default +PREHOOK: query: drop database newDB +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:newdb +PREHOOK: Output: database:newdb +POSTHOOK: query: drop database newDB +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:newdb +POSTHOOK: Output: database:newdb +PREHOOK: query: explain analyze table src compute statistics +PREHOOK: type: QUERY +POSTHOOK: query: explain analyze table src compute statistics +POSTHOOK: type: QUERY +Stage-2 + Stats-Aggr Operator + Stage-0 + Map 1 + TableScan [TS_0] + alias:src + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE + +PREHOOK: query: explain analyze table src compute statistics for columns +PREHOOK: type: QUERY +POSTHOOK: query: explain analyze table src compute statistics for columns +POSTHOOK: type: QUERY +Vertex dependency in root stage +Reducer 2 <- Map 1 (SIMPLE_EDGE) + +Stage-2 + Column Stats Work{} + Stage-0 + Reducer 2 + File Output Operator [FS_6] + compressed:false + Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} + Group By Operator [GBY_4] + | aggregations:["compute_stats(VALUE._col0)","compute_stats(VALUE._col1)"] + | outputColumnNames:["_col0","_col1"] + | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + |<-Map 1 [SIMPLE_EDGE] + Reduce Output Operator [RS_3] + sort order: + Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + value expressions:_col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:string,numbitvectors:int>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:string,numbitvectors:int>) + Group By Operator [GBY_2] + aggregations:["compute_stats(key, 16)","compute_stats(value, 16)"] + outputColumnNames:["_col0","_col1"] + Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE + Select Operator [SEL_1] + outputColumnNames:["key","value"] + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + TableScan [TS_0] + alias:src + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + +PREHOOK: query: explain +CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x)) +PREHOOK: type: CREATEMACRO +POSTHOOK: query: explain +CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x)) +POSTHOOK: type: CREATEMACRO +Stage-0 + +PREHOOK: query: CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x)) +PREHOOK: type: CREATEMACRO +PREHOOK: Output: database:default +POSTHOOK: query: CREATE TEMPORARY MACRO SIGMOID (x DOUBLE) 1.0 / (1.0 + EXP(-x)) +POSTHOOK: type: CREATEMACRO +POSTHOOK: Output: database:default +PREHOOK: query: EXPLAIN SELECT SIGMOID(2) FROM src LIMIT 1 +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN SELECT SIGMOID(2) FROM src LIMIT 1 +POSTHOOK: type: QUERY +Plan optimized by CBO. + +Stage-0 + Fetch Operator + limit:1 + Limit [LIM_2] + Number of rows:1 + Select Operator [SEL_1] + outputColumnNames:["_col0"] + TableScan [TS_0] + alias:src + +PREHOOK: query: explain DROP TEMPORARY MACRO SIGMOID +PREHOOK: type: DROPMACRO +POSTHOOK: query: explain DROP TEMPORARY MACRO SIGMOID +POSTHOOK: type: DROPMACRO +Stage-0 + +PREHOOK: query: DROP TEMPORARY MACRO SIGMOID +PREHOOK: type: DROPMACRO +PREHOOK: Output: database:default +POSTHOOK: query: DROP TEMPORARY MACRO SIGMOID +POSTHOOK: type: DROPMACRO +POSTHOOK: Output: database:default +PREHOOK: query: explain create table src_autho_test as select * from src +PREHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: query: explain create table src_autho_test as select * from src +POSTHOOK: type: CREATETABLE_AS_SELECT +Plan optimized by CBO. + +Stage-3 + Stats-Aggr Operator + Stage-4 + Create Table Operator: + columns:["key string","value string"] + input format:org.apache.hadoop.mapred.TextInputFormat + name:default.src_autho_test + output format:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat + Stage-2 + Dependency Collection{} + Stage-1 + Map 1 + File Output Operator [FS_2] + compressed:false + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.src_autho_test","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} + Select Operator [SEL_1] + outputColumnNames:["_col0","_col1"] + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + TableScan [TS_0] + alias:src + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Stage-0 + Move Operator + Please refer to the previous Stage-1 + +PREHOOK: query: create table src_autho_test as select * from src +PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test +POSTHOOK: query: create table src_autho_test as select * from src +POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@src +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_autho_test +PREHOOK: query: explain grant select on table src_autho_test to user hive_test_user +PREHOOK: type: GRANT_PRIVILEGE +POSTHOOK: query: explain grant select on table src_autho_test to user hive_test_user +POSTHOOK: type: GRANT_PRIVILEGE +Stage-0 + +PREHOOK: query: grant select on table src_autho_test to user hive_test_user +PREHOOK: type: GRANT_PRIVILEGE +PREHOOK: Output: default@src_autho_test +POSTHOOK: query: grant select on table src_autho_test to user hive_test_user +POSTHOOK: type: GRANT_PRIVILEGE +POSTHOOK: Output: default@src_autho_test +PREHOOK: query: explain show grant user hive_test_user on table src_autho_test +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: explain show grant user hive_test_user on table src_autho_test +POSTHOOK: type: SHOW_GRANT +Stage-1 + Fetch Operator + limit:-1 + Stage-0 + +PREHOOK: query: explain show grant user hive_test_user on table src_autho_test(key) +PREHOOK: type: SHOW_GRANT +POSTHOOK: query: explain show grant user hive_test_user on table src_autho_test(key) +POSTHOOK: type: SHOW_GRANT +Stage-1 + Fetch Operator + limit:-1 + Stage-0 + +PREHOOK: query: select key from src_autho_test order by key limit 20 +PREHOOK: type: QUERY +PREHOOK: Input: default@src_autho_test +#### A masked pattern was here #### +POSTHOOK: query: select key from src_autho_test order by key limit 20 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_autho_test +#### A masked pattern was here #### +0 +0 +0 +10 +100 +100 +103 +103 +104 +104 +105 +11 +111 +113 +113 +114 +116 +118 +118 +119 +PREHOOK: query: explain revoke select on table src_autho_test from user hive_test_user +PREHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: query: explain revoke select on table src_autho_test from user hive_test_user +POSTHOOK: type: REVOKE_PRIVILEGE +Stage-0 + +PREHOOK: query: explain grant select(key) on table src_autho_test to user hive_test_user +PREHOOK: type: GRANT_PRIVILEGE +POSTHOOK: query: explain grant select(key) on table src_autho_test to user hive_test_user +POSTHOOK: type: GRANT_PRIVILEGE +Stage-0 + +PREHOOK: query: explain revoke select(key) on table src_autho_test from user hive_test_user +PREHOOK: type: REVOKE_PRIVILEGE +POSTHOOK: query: explain revoke select(key) on table src_autho_test from user hive_test_user +POSTHOOK: type: REVOKE_PRIVILEGE +Stage-0 + +PREHOOK: query: explain +create role sRc_roLE +PREHOOK: type: CREATEROLE +POSTHOOK: query: explain +create role sRc_roLE +POSTHOOK: type: CREATEROLE +Stage-0 + +PREHOOK: query: create role sRc_roLE +PREHOOK: type: CREATEROLE +POSTHOOK: query: create role sRc_roLE +POSTHOOK: type: CREATEROLE +PREHOOK: query: explain +grant role sRc_roLE to user hive_test_user +PREHOOK: type: GRANT_ROLE +POSTHOOK: query: explain +grant role sRc_roLE to user hive_test_user +POSTHOOK: type: GRANT_ROLE +Stage-0 + +PREHOOK: query: grant role sRc_roLE to user hive_test_user +PREHOOK: type: GRANT_ROLE +POSTHOOK: query: grant role sRc_roLE to user hive_test_user +POSTHOOK: type: GRANT_ROLE +PREHOOK: query: explain show role grant user hive_test_user +PREHOOK: type: SHOW_ROLE_GRANT +POSTHOOK: query: explain show role grant user hive_test_user +POSTHOOK: type: SHOW_ROLE_GRANT +Stage-1 + Fetch Operator + limit:-1 + Stage-0 + +PREHOOK: query: explain drop role sRc_roLE +PREHOOK: type: DROPROLE +POSTHOOK: query: explain drop role sRc_roLE +POSTHOOK: type: DROPROLE +Stage-0 + +PREHOOK: query: drop role sRc_roLE +PREHOOK: type: DROPROLE +POSTHOOK: query: drop role sRc_roLE +POSTHOOK: type: DROPROLE +PREHOOK: query: drop table src_autho_test +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@src_autho_test +PREHOOK: Output: default@src_autho_test +POSTHOOK: query: drop table src_autho_test +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@src_autho_test +POSTHOOK: Output: default@src_autho_test +PREHOOK: query: explain drop view v +PREHOOK: type: DROPVIEW +POSTHOOK: query: explain drop view v +POSTHOOK: type: DROPVIEW +Stage-0 + Drop Table Operator: + table:v + +PREHOOK: query: explain create view v as with cte as (select * from src order by key limit 5) +select * from cte +PREHOOK: type: CREATEVIEW +POSTHOOK: query: explain create view v as with cte as (select * from src order by key limit 5) +select * from cte +POSTHOOK: type: CREATEVIEW +Plan not optimized by CBO. + +Stage-0 + Create View Operator: + name:default.v + original text:with cte as (select * from src order by key limit 5) +select * from cte + +PREHOOK: query: explain with cte as (select * from src order by key limit 5) +select * from cte +PREHOOK: type: QUERY +POSTHOOK: query: explain with cte as (select * from src order by key limit 5) +select * from cte +POSTHOOK: type: QUERY +Plan optimized by CBO. + +Vertex dependency in root stage +Reducer 2 <- Map 1 (SIMPLE_EDGE) + +Stage-0 + Fetch Operator + limit:5 + Stage-1 + Reducer 2 + File Output Operator [FS_5] + compressed:false + Statistics:Num rows: 5 Data size: 50 Basic stats: COMPLETE Column stats: NONE + table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"} + Limit [LIM_4] + Number of rows:5 + Statistics:Num rows: 5 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Select Operator [SEL_3] + | outputColumnNames:["_col0","_col1"] + | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + |<-Map 1 [SIMPLE_EDGE] + Reduce Output Operator [RS_2] + key expressions:_col0 (type: string) + sort order:+ + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions:_col1 (type: string) + Select Operator [SEL_1] + outputColumnNames:["_col0","_col1"] + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + TableScan [TS_0] + alias:src + Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + +PREHOOK: query: create table orc_merge5 (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_merge5 +POSTHOOK: query: create table orc_merge5 (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@orc_merge5 +PREHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_merge5 +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@orc_merge5 +POSTHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_merge5 +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@orc_merge5 +PREHOOK: query: explain insert overwrite table orc_merge5 select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13 +PREHOOK: type: QUERY +POSTHOOK: query: explain insert overwrite table orc_merge5 select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13 +POSTHOOK: type: QUERY +Plan optimized by CBO. + +Stage-3 + Stats-Aggr Operator + Stage-0 + Move Operator + table:{"serde:":"org.apache.hadoop.hive.ql.io.orc.OrcSerde","name:":"default.orc_merge5","input format:":"org.apache.hadoop.hive.ql.io.orc.OrcInputFormat","output format:":"org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat"} + Stage-2 + Dependency Collection{} + Stage-5(CONDITIONAL) + Move Operator + Stage-8(CONDITIONAL CHILD TASKS: Stage-5, Stage-4, Stage-6) + Conditional Operator + Stage-1 + Map 1 + File Output Operator [FS_3] + compressed:false + Statistics:Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE + table:{"serde:":"org.apache.hadoop.hive.ql.io.orc.OrcSerde","name:":"default.orc_merge5","input format:":"org.apache.hadoop.hive.ql.io.orc.OrcInputFormat","output format:":"org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat"} + Select Operator [SEL_2] + outputColumnNames:["_col0","_col1","_col2","_col3","_col4"] + Statistics:Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE + Filter Operator [FIL_4] + predicate:(userid <= 13) (type: boolean) + Statistics:Num rows: 306 Data size: 82044 Basic stats: COMPLETE Column stats: NONE + TableScan [TS_0] + alias:orc_merge5 + Statistics:Num rows: 919 Data size: 246402 Basic stats: COMPLETE Column stats: NONE + Stage-4(CONDITIONAL) + File Merge + ORC File Merge Operator [OFM_7] + Please refer to the previous Stage-8(CONDITIONAL CHILD TASKS: Stage-5, Stage-4, Stage-6) + Stage-7 + Move Operator + Stage-6(CONDITIONAL) + File Merge + ORC File Merge Operator [OFM_7] + Please refer to the previous Stage-8(CONDITIONAL CHILD TASKS: Stage-5, Stage-4, Stage-6) + +PREHOOK: query: drop table orc_merge5 +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@orc_merge5 +PREHOOK: Output: default@orc_merge5 +POSTHOOK: query: drop table orc_merge5 +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@orc_merge5 +POSTHOOK: Output: default@orc_merge5
