hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject [01/53] [abbrv] hive git commit: HIVE-11037: HiveOnTez: make explain user level = true as default (Pengcheng Xiong via Laljo John Pullokkaran)
Date Fri, 26 Jun 2015 03:41:54 GMT
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


Mime
View raw message