http://git-wip-us.apache.org/repos/asf/hive/blob/8842dcaf/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
index 37403c4..bd5b72e 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_1.q.out
@@ -9,6 +9,7 @@ Stage-0
name:default.src_orc_merge_test_part
output format:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
partition columns:["ds string","ts string"]
+
PREHOOK: query: create table src_orc_merge_test_part(key int, value string)
partitioned by (ds string, ts string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -68,6 +69,7 @@ Stage-3
TableScan [TS_0]
alias:src
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: insert overwrite table src_orc_merge_test_part
partition(ds='2012-01-03', ts='2012-01-03+14:46:31') select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -124,6 +126,7 @@ Stage-3
TableScan [TS_0]
alias:src
Statistics:Num rows: 500 Data
size: 5312 Basic stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select count(1) from src_orc_merge_test_part where
ds='2012-01-03' and ts='2012-01-03+14:46:31'
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(1) from src_orc_merge_test_part where
ds='2012-01-03' and ts='2012-01-03+14:46:31'
@@ -160,6 +163,7 @@ Stage-0
TableScan [TS_0]
alias:src_orc_merge_test_part
Statistics:Num rows: 500 Data size: 47000 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
@@ -197,6 +201,7 @@ Stage-0
TableScan [TS_0]
alias:src_orc_merge_test_part
Statistics:Num rows: 500 Data size: 47000 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: alter table src_orc_merge_test_part partition
(ds='2012-01-03', ts='2012-01-03+14:46:31') concatenate
PREHOOK: type: ALTER_PARTITION_MERGE
PREHOOK: Input: default@src_orc_merge_test_part
@@ -241,6 +246,7 @@ Stage-0
TableScan [TS_0]
alias:src_orc_merge_test_part
Statistics:Num rows: 1 Data size: 2527 Basic stats:
PARTIAL Column stats: NONE
+
PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
src_orc_merge_test_part where ds='2012-01-03' and ts='2012-01-03+14:46:31'
@@ -278,6 +284,7 @@ Stage-0
TableScan [TS_0]
alias:src_orc_merge_test_part
Statistics:Num rows: 24 Data size: 2527 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: drop table src_orc_merge_test_part
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_orc_merge_test_part
@@ -310,9 +317,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -372,6 +379,7 @@ Stage-0
TableScan [TS_0]
alias:src
Statistics:Num rows: 500 Data size:
5312 Basic stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1
group by c_float, cbo_t1.c_int, key
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1
group by c_float, cbo_t1.c_int, key
@@ -416,6 +424,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select x, y, count(*) from (select key,
(c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float,
cbo_t1.c_int, key) R group by y, x
PREHOOK: type: QUERY
POSTHOOK: query: explain select x, y, count(*) from (select key,
(c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float,
cbo_t1.c_int, key) R group by y, x
@@ -481,6 +490,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size:
262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
order by a) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from
cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >=
0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or
c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
order by a) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from
cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >=
0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r asc) cbo_t2 on
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or
c_int >= 0) group by cbo_t3.c_int, c order by cbo_t3.c_int+c desc, c
@@ -488,13 +498,13 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
+Reducer 10 <- Map 9 (SIMPLE_EDGE)
+Reducer 11 <- Reducer 10 (SIMPLE_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 11 <- Reducer 10 (SIMPLE_EDGE)
-Reducer 10 <- Map 9 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
-Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Reducer 6 <- Map 5 (SIMPLE_EDGE)
+Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Reducer 8 <- Reducer 11 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE)
Stage-0
@@ -667,6 +677,7 @@ Stage-0
TableScan [TS_2]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by b % c asc, b desc) cbo_t1 left outer join (select key as p,
c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and
(cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key
having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0) cbo_t2 on cbo_t1.a=p left outer join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having
cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by
cbo_t3.c_int % c asc, cbo_t3.c_int desc
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by b % c asc, b desc) cbo_t1 left outer join (select key as p,
c_int+1 as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and
(cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key
having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0) cbo_t2 on cbo_t1.a=p left outer join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c having
cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int + c) >= 0 order by
cbo_t3.c_int % c asc, cbo_t3.c_int desc
@@ -676,11 +687,11 @@ Plan optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Map 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
-Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
Reducer 8 <- Map 7 (SIMPLE_EDGE)
+Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -837,6 +848,7 @@ Stage-0
TableScan [TS_10]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by b+c, a desc) cbo_t1 right outer join (select key as p, c_int+1 as
q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int
> 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having
cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0)
cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by b+c, a desc) cbo_t1 right outer join (select key as p, c_int+1 as
q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int
> 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having
cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0)
cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 2) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c
@@ -846,8 +858,8 @@ Plan optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Map 9 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 7 <- Map 6 (SIMPLE_EDGE)
Reducer 8 <- Reducer 7 (SIMPLE_EDGE)
@@ -994,6 +1006,7 @@ Stage-0
TableScan
[TS_10]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by c+a desc) cbo_t1 full outer join (select key as p, c_int+1 as q,
sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0
or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having
cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0
order by p+q desc, r asc) cbo_t2 on cbo_t1.a=p full outer join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by
cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int +
c) >= 0 order by cbo_t3.c_int
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by c+a desc) cbo_t1 full outer join (select key as p, c_int+1 as q,
sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0
or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key having
cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float) >= 0
order by p+q desc, r asc) cbo_t2 on cbo_t1.a=p full outer join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by
cbo_t3.c_int, c having cbo_t3.c_int > 0 and (c_int >=1 or c >= 1) and (c_int +
c) >= 0 order by cbo_t3.c_int
@@ -1001,13 +1014,13 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
+Reducer 10 <- Reducer 9 (SIMPLE_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 10 <- Reducer 9 (SIMPLE_EDGE)
-Reducer 5 <- Map 11 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Reducer 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
-Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
+Reducer 5 <- Map 11 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
+Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Reducer 9 <- Map 8 (SIMPLE_EDGE)
Stage-0
@@ -1174,6 +1187,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2
where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)
group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or
c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by
cbo_t3.c_int, c
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r from cbo_t2
where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)
group by c_float, cbo_t2.c_int, key having cbo_t2.c_float > 0 and (c_int >=1 or
c_float >= 1) and (c_int + c_float) >= 0) cbo_t2 on cbo_t1.a=p join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by
cbo_t3.c_int, c
@@ -1327,6 +1341,7 @@ Stage-0
TableScan
[TS_12]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select unionsrc.key FROM (select 'tst1' as key,
count(1) as value from src) unionsrc
PREHOOK: type: QUERY
POSTHOOK: query: explain select unionsrc.key FROM (select 'tst1' as key,
count(1) as value from src) unionsrc
@@ -1366,6 +1381,7 @@ Stage-0
TableScan [TS_0]
alias:src
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select unionsrc.key FROM (select 'max' as key,
max(c_int) as value from cbo_t3 s1
UNION ALL
select 'min' as key, min(c_int) as value from cbo_t3 s2
@@ -1480,6 +1496,7 @@ Stage-0
TableScan [TS_18]
alias:s1
Statistics:Num rows: 20 Data size: 262
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select unionsrc.key, count(1) FROM (select 'max' as
key, max(c_int) as value from cbo_t3 s1
UNION ALL
select 'min' as key, min(c_int) as value from cbo_t3 s2
@@ -1496,8 +1513,8 @@ Plan optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Union 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 7 <- Map 6 (SIMPLE_EDGE), Union 3 (CONTAINS)
Reducer 9 <- Map 8 (SIMPLE_EDGE), Union 3 (CONTAINS)
@@ -1627,6 +1644,7 @@ Stage-0
TableScan [TS_18]
alias:s1
Statistics:Num rows: 20 Data
size: 262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t1.key from cbo_t1 join cbo_t3 where
cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t1.key from cbo_t1 join cbo_t3 where
cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1
@@ -1680,6 +1698,7 @@ Stage-0
TableScan [TS_3]
alias:cbo_t3
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left
outer join cbo_t2 on cbo_t1.key=cbo_t2.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left
outer join cbo_t2 on cbo_t1.key=cbo_t2.key
@@ -1732,6 +1751,7 @@ Stage-0
TableScan [TS_2]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full
outer join cbo_t2 on cbo_t1.key=cbo_t2.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full
outer join cbo_t2 on cbo_t1.key=cbo_t2.key
@@ -1784,6 +1804,7 @@ Stage-0
TableScan [TS_2]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from
(select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
PREHOOK: type: QUERY
POSTHOOK: query: explain select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from
(select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
@@ -1858,6 +1879,7 @@ Stage-0
TableScan [TS_4]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on
cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from
cbo_t3)cbo_t3 on cbo_t1.key=a
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1
join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2)
cbo_t2 on cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c
from cbo_t3)cbo_t3 on cbo_t1.key=a
@@ -1931,6 +1953,7 @@ Stage-0
TableScan [TS_4]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c,
cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1
where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0))
cbo_t1 full outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r
from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b
+ cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0
or c_int >= 0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c,
cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1
where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0))
cbo_t1 full outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r
from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b
+ cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q + 1 = 2) and (R.b > 0
or c_int >= 0)
@@ -2024,6 +2047,7 @@ Stage-0
TableScan [TS_3]
alias:cbo_t2
Statistics:Num rows: 20 Data size:
262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c,
cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1
where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0))
cbo_t1 right outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as
r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q +
1 = 2) and (R.b > 0 or c_int >= 0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from (select q, b, cbo_t2.p, cbo_t1.c,
cbo_t3.c_int from (select key as a, c_int as b, cbo_t1.c_float as c from cbo_t1
where (cbo_t1.c_int + 1 == 2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0))
cbo_t1 right outer join (select cbo_t2.key as p, cbo_t2.c_int as q, c_float as
r from cbo_t2 where (cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0)) cbo_t2 on cbo_t1.a=p right outer join cbo_t3 on
cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 or c_int >= 0)) R where (q +
1 = 2) and (R.b > 0 or c_int >= 0)
@@ -2098,6 +2122,7 @@ Stage-0
TableScan [TS_6]
alias:cbo_t3
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1
group by c_float, cbo_t1.c_int, key order by x limit 1
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, (c_int+1)+2 as x, sum(c_int) from cbo_t1
group by c_float, cbo_t1.c_int, key order by x limit 1
@@ -2155,6 +2180,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select x, y, count(*) from (select key,
(c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float,
cbo_t1.c_int, key) R group by y, x order by x,y limit 1
PREHOOK: type: QUERY
POSTHOOK: query: explain select x, y, count(*) from (select key,
(c_int+c_float+1+2) as x, sum(c_int) as y from cbo_t1 group by c_float,
cbo_t1.c_int, key) R group by y, x order by x,y limit 1
@@ -2233,6 +2259,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20
Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select key from(select key from (select key from
cbo_t1 limit 5)cbo_t2 limit 5)cbo_t3 limit 5
PREHOOK: type: QUERY
POSTHOOK: query: explain select key from(select key from (select key from
cbo_t1 limit 5)cbo_t2 limit 5)cbo_t3 limit 5
@@ -2289,6 +2316,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data
size: 262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select key, c_int from(select key, c_int from (select
key, c_int from cbo_t1 order by c_int limit 5)cbo_t1 order by c_int limit
5)cbo_t2 order by c_int limit 5
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, c_int from(select key, c_int from (select
key, c_int from cbo_t1 order by c_int limit 5)cbo_t1 order by c_int limit
5)cbo_t2 order by c_int limit 5
@@ -2351,6 +2379,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data
size: 262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
order by a limit 5) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r
from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r
asc limit 5) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by
cbo_t3.c_int+c desc, c limit 5
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t3.c_int, c, count(*) from (select key as
a, c_int+1 as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
order by a limit 5) cbo_t1 join (select key as p, c_int+1 as q, sum(c_int) as r
from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and (cbo_t2.c_int > 0 or
cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key order by q/10 desc, r
asc limit 5) cbo_t2 on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b +
cbo_t2.q >= 0) and (b > 0 or c_int >= 0) group by cbo_t3.c_int, c order by
cbo_t3.c_int+c desc, c limit 5
@@ -2358,13 +2387,13 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
+Reducer 10 <- Map 9 (SIMPLE_EDGE)
+Reducer 11 <- Reducer 10 (SIMPLE_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 11 <- Reducer 10 (SIMPLE_EDGE)
-Reducer 10 <- Map 9 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
-Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Reducer 6 <- Map 5 (SIMPLE_EDGE)
+Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Reducer 8 <- Reducer 11 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE)
Stage-0
@@ -2552,6 +2581,7 @@ Stage-0
TableScan [TS_2]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic stats: COMPLETE Column
stats: COMPLETE
+
PREHOOK: query: explain select cbo_t1.c_int from cbo_t1 left semi
join cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + 1 == 2) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t1.c_int from cbo_t1 left semi
join cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + 1 == 2) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)
@@ -2613,6 +2643,7 @@ Stage-0
TableScan [TS_3]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select * from (select c, b, a from (select key as a,
c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 left semi join (select
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where
(cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2
on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 == 2) and (b >
0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from (select c, b, a from (select key as a,
c_int as b, cbo_t1.c_float as c from cbo_t1 where (cbo_t1.c_int + 1 == 2) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 left semi join (select
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2 where
(cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2
on cbo_t1.a=p left semi join cbo_t3 on cbo_t1.a=key where (b + 1 == 2) and (b >
0 or c >= 0)) R where (b + 1 = 2) and (R.b > 0 or c >= 0)
@@ -2693,6 +2724,7 @@ Stage-0
TableScan [TS_10]
alias:cbo_t3
Statistics:Num rows: 20 Data size: 262 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select a, c, count(*) from (select key as a, c_int+1
as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by a+b desc, c asc) cbo_t1 left semi join (select key as p, c_int+1
as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and
(cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key
having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by q+r/10 desc, p) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on
cbo_t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a
> 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, a
PREHOOK: type: QUERY
POSTHOOK: query: explain select a, c, count(*) from (select key as a, c_int+1
as b, sum(c_int) as c from cbo_t1 where (cbo_t1.c_int + 1 >= 0) and
(cbo_t1.c_int > 0 or cbo_t1.c_float >= 0) group by c_float, cbo_t1.c_int, key
having cbo_t1.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by a+b desc, c asc) cbo_t1 left semi join (select key as p, c_int+1
as q, sum(c_int) as r from cbo_t2 where (cbo_t2.c_int + 1 >= 0) and
(cbo_t2.c_int > 0 or cbo_t2.c_float >= 0) group by c_float, cbo_t2.c_int, key
having cbo_t2.c_float > 0 and (c_int >=1 or c_float >= 1) and (c_int + c_float)
>= 0 order by q+r/10 desc, p) cbo_t2 on cbo_t1.a=p left semi join cbo_t3 on
cbo_t1.a=key where (b + 1 >= 0) and (b > 0 or a >= 0) group by a, c having a
> 0 and (a >=1 or c >= 1) and (a + c) >= 0 order by c, a
@@ -2702,11 +2734,11 @@ Plan optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Map 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE), Reducer 9
(SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
-Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
Reducer 8 <- Map 7 (SIMPLE_EDGE)
+Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -2868,6 +2900,7 @@ Stage-0
TableScan [TS_17]
alias:cbo_t2
Statistics:Num
rows: 20 Data size: 262 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select cbo_t1.key as x, c_int as c_int,
(((c_int+c_float)*10)+5) as y from cbo_t1
PREHOOK: type: QUERY
POSTHOOK: query: explain select cbo_t1.key as x, c_int as c_int,
(((c_int+c_float)*10)+5) as y from cbo_t1
@@ -2881,6 +2914,7 @@ Stage-0
outputColumnNames:["_col0","_col1","_col2"]
TableScan [TS_0]
alias:cbo_t1
+
PREHOOK: query: explain select null from cbo_t1
PREHOOK: type: QUERY
POSTHOOK: query: explain select null from cbo_t1
@@ -2894,6 +2928,7 @@ Stage-0
outputColumnNames:["_col0"]
TableScan [TS_0]
alias:cbo_t1
+
PREHOOK: query: explain select key from cbo_t1 where c_int = -6 or c_int = +6
PREHOOK: type: QUERY
POSTHOOK: query: explain select key from cbo_t1 where c_int = -6 or c_int = +6
@@ -2909,6 +2944,7 @@ Stage-0
predicate:((c_int = -6) or (c_int = 6)) (type: boolean)
TableScan [TS_0]
alias:cbo_t1
+
PREHOOK: query: explain select count(cbo_t1.dt) from cbo_t1 join cbo_t2 on
cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014'
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(cbo_t1.dt) from cbo_t1 join cbo_t2 on
cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014'
@@ -2966,6 +3002,7 @@ Stage-0
TableScan [TS_3]
alias:cbo_t2
Statistics:Num rows: 20 Data size: 262
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *
from src_cbo b
where not exists
@@ -3053,6 +3090,7 @@ Stage-0
TableScan [TS_3]
alias:b
Statistics:Num rows: 500 Data
size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *
from src_cbo b
group by key, value
@@ -3138,6 +3176,7 @@ Stage-0
TableScan [TS_0]
alias:b
Statistics:Num rows: 500 Data size:
5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: create view cv1 as
select *
from src_cbo b
@@ -3217,6 +3256,7 @@ Stage-0
TableScan [TS_3]
alias:b
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *
from (select *
from src_cbo b
@@ -3288,6 +3328,7 @@ Stage-0
TableScan [TS_3]
alias:b
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *
from src_cbo
where src_cbo.key in (select key from src_cbo s1 where s1.key > '9')
@@ -3350,6 +3391,7 @@ Stage-0
TableScan [TS_3]
alias:src_cbo
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li
on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -3460,6 +3502,7 @@ Stage-0
TableScan [TS_6]
alias:lineitem
Statistics:Num rows: 100 Data size:
11999 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select key, value, count(*)
from src_cbo b
where b.key in (select key from src_cbo where src_cbo.key > '8')
@@ -3606,6 +3649,7 @@ Stage-0
TableScan [TS_20]
alias:b
Statistics:Num rows: 500 Data
size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select p_mfgr, p_name, avg(p_size)
from part
group by p_mfgr, p_name
@@ -3704,6 +3748,7 @@ Stage-0
TableScan [TS_8]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *
from src_cbo
where src_cbo.key not in
@@ -3823,6 +3868,7 @@ Stage-0
TableScan [TS_3]
alias:src_cbo
Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select p_mfgr, b.p_name, p_size
from part b
where b.p_name not in
@@ -3934,6 +3980,7 @@ Stage-0
TableScan [TS_3]
alias:b
Statistics:Num rows: 26
Data size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select p_name, p_size
from
part where part.p_size not in
@@ -4076,6 +4123,7 @@ Stage-0
TableScan [TS_11]
alias:part
Statistics:Num rows:
26 Data size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select b.p_mfgr, min(p_retailprice)
from part b
group by b.p_mfgr
@@ -4099,11 +4147,11 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
+Reducer 10 <- Map 9 (SIMPLE_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
-Reducer 10 <- Map 9 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Reducer 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 7 <- Map 6 (SIMPLE_EDGE)
Reducer 8 <- Reducer 7 (SIMPLE_EDGE)
@@ -4260,6 +4308,7 @@ Stage-0
TableScan
[TS_8]
alias:b
Statistics:Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats:
COMPLETE
+
PREHOOK: query: explain select count(c_int) over(), sum(c_float) over(),
max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(),
dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(),
lag(c_float, 2, c_float) over() from cbo_t1
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(c_int) over(), sum(c_float) over(),
max(c_int) over(), min(c_int) over(), row_number() over(), rank() over(),
dense_rank() over(), percent_rank() over(), lead(c_int, 2, c_int) over(),
lag(c_float, 2, c_float) over() from cbo_t1
@@ -4297,6 +4346,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select * from (select count(c_int) over(),
sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(),
rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2,
c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1) cbo_t1
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from (select count(c_int) over(),
sum(c_float) over(), max(c_int) over(), min(c_int) over(), row_number() over(),
rank() over(), dense_rank() over(), percent_rank() over(), lead(c_int, 2,
c_int) over(), lag(c_float, 2, c_float) over() from cbo_t1) cbo_t1
@@ -4334,6 +4384,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select i, a, h, b, c, d, e, f, g, a as x, a +1 as y
from (select max(c_int) over (partition by key order by value range UNBOUNDED
PRECEDING) a, min(c_int) over (partition by key order by value range current
row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c,
avg(value) over (partition by key order by value range between unbounded
preceding and unbounded following) d, sum(value) over (partition by key order
by value range between unbounded preceding and current row) e, avg(c_float)
over (partition by key order by value range between 1 preceding and unbounded
following) f, sum(c_float) over (partition by key order by value range between
1 preceding and current row) g, max(c_float) over (partition by key order by
value range between 1 preceding and unbounded following) h, min(c_float) over
(partition by key order by value range between 1 preceding and 1 following) i
from cbo_t1) cbo_t1
PREHOOK: type: QUERY
POSTHOOK: query: explain select i, a, h, b, c, d, e, f, g, a as x, a +1 as y
from (select max(c_int) over (partition by key order by value range UNBOUNDED
PRECEDING) a, min(c_int) over (partition by key order by value range current
row) b, count(c_int) over(partition by key order by value range 1 PRECEDING) c,
avg(value) over (partition by key order by value range between unbounded
preceding and unbounded following) d, sum(value) over (partition by key order
by value range between unbounded preceding and current row) e, avg(c_float)
over (partition by key order by value range between 1 preceding and unbounded
following) f, sum(c_float) over (partition by key order by value range between
1 preceding and current row) g, max(c_float) over (partition by key order by
value range between 1 preceding and unbounded following) h, min(c_float) over
(partition by key order by value range between 1 preceding and 1 following) i
from cbo_t1) cbo_t1
@@ -4371,6 +4422,7 @@ Stage-0
TableScan [TS_0]
alias:cbo_t1
Statistics:Num rows: 20 Data size: 262 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select *, rank() over(partition by key order by value)
as rr from src1
PREHOOK: type: QUERY
POSTHOOK: query: explain select *, rank() over(partition by key order by
value) as rr from src1
@@ -4407,6 +4459,7 @@ Stage-0
TableScan [TS_0]
alias:src1
Statistics:Num rows: 25 Data size: 191 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
FROM (select x.key AS key, count(1) AS cnt
@@ -4506,6 +4559,7 @@ Stage-0
TableScan [TS_2]
alias:x
Statistics:Num rows: 25
Data size: 191 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
FROM (select x.key AS key, count(1) AS cnt
@@ -4605,6 +4659,7 @@ Stage-0
TableScan [TS_2]
alias:x
Statistics:Num rows: 25
Data size: 191 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
FROM (select x.key AS key, count(1) AS cnt
@@ -4620,9 +4675,9 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -4698,6 +4753,7 @@ Stage-0
TableScan [TS_0]
alias:y
Statistics:Num rows: 500 Data
size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select SUM(HASH(tmp.key)), SUM(HASH(tmp.cnt))
FROM (select x.key AS key, count(1) AS cnt
@@ -4798,6 +4854,7 @@ Stage-0
TableScan [TS_2]
alias:y
Statistics:Num rows: 500
Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain create table abcd (a int, b int, c int, d int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: explain create table abcd (a int, b int, c int, d int)
@@ -4808,6 +4865,7 @@ Stage-0
input format:org.apache.hadoop.mapred.TextInputFormat
name:default.abcd
output format:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
PREHOOK: query: create table abcd (a int, b int, c int, d int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -4865,6 +4923,7 @@ Stage-0
TableScan [TS_0]
alias:abcd
Statistics:Num rows: 4 Data size: 78 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select a, count(distinct b), count(distinct c), sum(d)
from abcd group by a
PREHOOK: type: QUERY
POSTHOOK: query: explain select a, count(distinct b), count(distinct c),
sum(d) from abcd group by a
@@ -4901,6 +4960,7 @@ Stage-0
TableScan [TS_0]
alias:abcd
Statistics:Num rows: 4 Data size: 78 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain create table src_rc_merge_test(key int, value string)
stored as rcfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: explain create table src_rc_merge_test(key int, value string)
stored as rcfile
@@ -4911,6 +4971,7 @@ Stage-0
input format:org.apache.hadoop.hive.ql.io.RCFileInputFormat
name:default.src_rc_merge_test
output format:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+
PREHOOK: query: create table src_rc_merge_test(key int, value string) stored
as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -4937,6 +4998,7 @@ Stage-0
input format:org.apache.hadoop.hive.ql.io.RCFileInputFormat
name:default.tgt_rc_merge_test
output format:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+
PREHOOK: query: create table tgt_rc_merge_test(key int, value string) stored
as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -5003,6 +5065,7 @@ Stage-0
TableScan [TS_0]
alias:tgt_rc_merge_test
Statistics:Num rows: 5 Data size: 32 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
tgt_rc_merge_test
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
tgt_rc_merge_test
@@ -5036,6 +5099,7 @@ Stage-0
TableScan [TS_0]
alias:tgt_rc_merge_test
Statistics:Num rows: 5 Data size: 32 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: alter table tgt_rc_merge_test concatenate
PREHOOK: type: ALTER_TABLE_MERGE
PREHOOK: Input: default@tgt_rc_merge_test
@@ -5092,6 +5156,7 @@ Stage-0
TableScan [TS_0]
alias:tgt_rc_merge_test
Statistics:Num rows: 1 Data size: 171 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
tgt_rc_merge_test
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(key)), sum(hash(value)) from
tgt_rc_merge_test
@@ -5125,6 +5190,7 @@ Stage-0
TableScan [TS_0]
alias:tgt_rc_merge_test
Statistics:Num rows: 1 Data size: 171 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: drop table src_rc_merge_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@src_rc_merge_test
@@ -5184,6 +5250,7 @@ Stage-0
TableScan [TS_2]
alias:src
Statistics:Num rows: 500 Data size: 5312 Basic stats:
COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain create table nzhang_Tmp(a int, b string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: explain create table nzhang_Tmp(a int, b string)
@@ -5194,6 +5261,7 @@ Stage-0
input format:org.apache.hadoop.mapred.TextInputFormat
name:default.nzhang_Tmp
output format:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
PREHOOK: query: create table nzhang_Tmp(a int, b string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -5259,6 +5327,7 @@ Stage-3
Stage-0
Move Operator
Please refer to the previous Stage-1
+
PREHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort
by k, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -5326,6 +5395,7 @@ Stage-3
Stage-0
Move Operator
Please refer to the previous Stage-1
+
PREHOOK: query: create table nzhang_ctas3 row format serde
"org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as
select key/2 half_key, concat(value, "_con") conb from src sort by half_key,
conb limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
@@ -5340,6 +5410,7 @@ PREHOOK: query: explain create table if not exists
nzhang_ctas3 as select key, v
PREHOOK: type: CREATETABLE
POSTHOOK: query: explain create table if not exists nzhang_ctas3 as select
key, value from src sort by key, value limit 2
POSTHOOK: type: CREATETABLE
+
PREHOOK: query: create table if not exists nzhang_ctas3 as select key, value
from src sort by key, value limit 2
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table if not exists nzhang_ctas3 as select key, value
from src sort by key, value limit 2
@@ -5356,6 +5427,7 @@ Stage-0
input format:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
name:default.acid_dtt
output format:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
+
PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128))
clustered by (a) into 2 buckets stored as orc TBLPROPERTIES
('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -5436,6 +5508,7 @@ Stage-0
TableScan [TS_3]
alias:src
Statistics:Num rows: 500 Data size: 5312
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: CREATE TABLE myinput1(key int, value int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -5498,6 +5571,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value join myinput1 c on a.key=c.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value join myinput1 c on a.key=c.key
@@ -5563,6 +5637,7 @@ Stage-0
TableScan [TS_2]
alias:c
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value join myinput1 c on a.key<=>c.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value join myinput1 c on a.key<=>c.key
@@ -5619,6 +5694,7 @@ Stage-0
TableScan [TS_2]
alias:c
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value AND a.value=b.key join myinput1 c on a.key<=>c.key AND
a.value=c.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value AND a.value=b.key join myinput1 c on a.key<=>c.key AND
a.value=c.value
@@ -5681,6 +5757,7 @@ Stage-0
TableScan [TS_2]
alias:c
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value AND a.value<=>b.key join myinput1 c on a.key<=>c.key AND
a.value<=>c.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from myinput1 a join myinput1 b on
a.key<=>b.value AND a.value<=>b.key join myinput1 c on a.key<=>c.key AND
a.value<=>c.value
@@ -5734,6 +5811,7 @@ Stage-0
TableScan [TS_2]
alias:c
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * FROM myinput1 a LEFT OUTER JOIN myinput1 b ON
a.key<=>b.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * FROM myinput1 a LEFT OUTER JOIN myinput1 b
ON a.key<=>b.value
@@ -5780,6 +5858,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
ON a.key<=>b.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * FROM myinput1 a RIGHT OUTER JOIN myinput1 b
ON a.key<=>b.value
@@ -5826,6 +5905,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select * FROM myinput1 a FULL OUTER JOIN myinput1 b ON
a.key<=>b.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * FROM myinput1 a FULL OUTER JOIN myinput1 b
ON a.key<=>b.value
@@ -5872,6 +5952,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN
myinput1 b ON a.key<=>b.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM myinput1 a JOIN
myinput1 b ON a.key<=>b.value
@@ -5918,6 +5999,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 3 Data size: 26 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: CREATE TABLE smb_input(key int, value int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -6022,6 +6104,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 26 Data size: 190 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN
smb_input1 b ON a.key <=> b.key AND a.value <=> b.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a JOIN
smb_input1 b ON a.key <=> b.key AND a.value <=> b.value
@@ -6066,6 +6149,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 26 Data size: 190 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT
OUTER JOIN smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ MAPJOIN(a) */ * FROM smb_input1 a RIGHT
OUTER JOIN smb_input1 b ON a.key <=> b.key
@@ -6112,6 +6196,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 26 Data size: 190 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN
smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a JOIN
smb_input1 b ON a.key <=> b.key
@@ -6158,6 +6243,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 26 Data size: 190 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT
OUTER JOIN smb_input1 b ON a.key <=> b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ MAPJOIN(b) */ * FROM smb_input1 a LEFT
OUTER JOIN smb_input1 b ON a.key <=> b.key
@@ -6204,6 +6290,7 @@ Stage-0
TableScan [TS_1]
alias:b
Statistics:Num rows: 26 Data size: 190 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: drop table sales
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table sales
@@ -6316,6 +6403,7 @@ Stage-0
TableScan [TS_2]
alias:things
Statistics:Num rows: 2 Data size: 12 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: drop table sales
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@sales
@@ -6339,8 +6427,8 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Map 3 <- Map 4 (BROADCAST_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -6410,6 +6498,7 @@ Stage-0
TableScan [TS_3]
alias:srcpart
Statistics:Num rows: 2000 Data size: 21248
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select srcpart.key from srcpart join src on
(srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where
srcpart.value > 'val_450'
PREHOOK: type: QUERY
POSTHOOK: query: explain select srcpart.key from srcpart join src on
(srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where
srcpart.value > 'val_450'
@@ -6417,8 +6506,8 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Map 3 <- Map 4 (BROADCAST_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -6488,6 +6577,7 @@ Stage-0
TableScan [TS_3]
alias:srcpart
Statistics:Num rows: 2000 Data size: 21248
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select srcpart.key from srcpart join src on
(srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where
srcpart.value > 'val_450'
PREHOOK: type: QUERY
POSTHOOK: query: explain select srcpart.key from srcpart join src on
(srcpart.value=src.value) join src1 on (srcpart.key=src1.key) where
srcpart.value > 'val_450'
@@ -6495,8 +6585,8 @@ POSTHOOK: type: QUERY
Plan optimized by CBO.
Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Map 3 <- Map 4 (BROADCAST_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -6566,6 +6656,7 @@ Stage-0
TableScan [TS_3]
alias:srcpart
Statistics:Num rows: 2000 Data size: 21248
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -6633,6 +6724,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name,
p_size, p_size - lag(p_size,1,p_size) over (partition by p_mfgr order by
p_name) as deltaSz
@@ -6650,9 +6742,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -6715,6 +6807,7 @@ Stage-0
TableScan [TS_0]
alias:p1
Statistics:Num rows: 26 Data size:
3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -6782,6 +6875,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -6849,6 +6943,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -6876,8 +6971,8 @@ Plan not optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -6940,6 +7035,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data
size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select abc.*
from noop(on part
@@ -7004,6 +7100,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name, p_size desc) as r
@@ -7066,6 +7163,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -7134,6 +7232,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -7199,6 +7298,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -7283,6 +7383,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data
size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name,
sub1.cd, sub1.s1
@@ -7356,6 +7457,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size: 3147
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select abc.p_mfgr, abc.p_name,
rank() over (distribute by abc.p_mfgr sort by abc.p_name) as r,
@@ -7447,6 +7549,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data size:
3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
sum(p_retailprice) as s
@@ -7468,6 +7571,7 @@ Stage-0
sum(p_retailprice) as s
from part
group by p_mfgr, p_brand
+
PREHOOK: query: CREATE TABLE part_4(
p_mfgr STRING,
p_name STRING,
@@ -7549,8 +7653,8 @@ Plan not optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Reducer 2 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Stage-5
Stats-Aggr Operator
@@ -7641,6 +7745,7 @@ Stage-4
Move Operator
table:{"serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"default.part_4","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
select p_mfgr, p_name,
rank() over (partition by p_mfgr,p_name) as r,
@@ -7739,6 +7844,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data
size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -7778,8 +7884,8 @@ Plan not optimized by CBO.
Vertex dependency in root stage
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Stage-0
Fetch Operator
@@ -7848,6 +7954,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26
Data size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain
select p_mfgr, p_name,
rank() over (partition by p_mfgr order by p_name) as r,
@@ -7939,6 +8046,7 @@ Stage-0
TableScan [TS_0]
alias:part
Statistics:Num rows: 26 Data
size: 3147 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select distinct src.* from src
PREHOOK: type: QUERY
POSTHOOK: query: explain select distinct src.* from src
@@ -7984,6 +8092,7 @@ Stage-0
TableScan [TS_0]
alias:src
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select explode(array('a', 'b'))
PREHOOK: type: QUERY
POSTHOOK: query: explain select explode(array('a', 'b'))
@@ -7999,6 +8108,7 @@ Stage-0
outputColumnNames:["_col0"]
TableScan [TS_0]
alias:_dummy_table
+
PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -8136,6 +8246,7 @@ Stage-3
TableScan [TS_2]
alias:src1
Statistics:Num rows: 500 Data size:
5312 Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest_j1 select src1.key, src2.value
PREHOOK: type: QUERY
@@ -8227,6 +8338,7 @@ Stage-0
TableScan [TS_0]
alias:a
Statistics:Num rows: 1 Data size: 30 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain
select /*+ STREAMTABLE(a,c) */ *
FROM T1 a JOIN T2 b ON a.key = b.key
@@ -8306,6 +8418,7 @@ Stage-0
TableScan [TS_0]
alias:a
Statistics:Num rows: 1 Data size: 30 Basic stats:
COMPLETE Column stats: NONE
+
PREHOOK: query: explain FROM T1 a JOIN src c ON c.key+1=a.key select /*+
STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM T1 a JOIN src c ON c.key+1=a.key select /*+
STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
@@ -8313,8 +8426,8 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing feature [Hint].
Vertex dependency in root stage
-Reducer 3 <- Map 2 (SIMPLE_EDGE)
Map 2 <- Map 1 (BROADCAST_EDGE)
+Reducer 3 <- Map 2 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
Stage-0
@@ -8369,6 +8482,7 @@ Stage-0
TableScan [TS_1]
alias:c
Statistics:Num rows: 500 Data size: 5312
Basic stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: FROM T1 a JOIN src c ON c.key+1=a.key select /*+
STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -8445,6 +8559,7 @@ Stage-0
TableScan [TS_2]
alias:src
Statistics:Num rows: 500 Data size: 5312 Basic
stats: COMPLETE Column stats: COMPLETE
+
PREHOOK: query: explain select /*+ mapjoin(k)*/ sum(hash(k.key)),
sum(hash(v.val)) from T1 k join T1 v on k.key=v.val
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ mapjoin(k)*/ sum(hash(k.key)),
sum(hash(v.val)) from T1 k join T1 v on k.key=v.val
@@ -8452,9 +8567,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing feature [Hint].
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -8507,6 +8622,7 @@ Stage-0
TableScan [TS_0]
alias:k
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select sum(hash(k.key)), sum(hash(v.val)) from T1 k
join T1 v on k.key=v.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select sum(hash(k.key)), sum(hash(v.val)) from T1 k
join T1 v on k.key=v.key
@@ -8514,9 +8630,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing statistics. Please check log for more
details.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -8570,6 +8686,7 @@ Stage-0
TableScan [TS_0]
alias:k
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select count(1) from T1 a join T1 b on a.key = b.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(1) from T1 a join T1 b on a.key = b.key
@@ -8577,9 +8694,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing statistics. Please check log for more
details.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -8630,6 +8747,7 @@ Stage-0
TableScan [TS_0]
alias:a
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain FROM T1 a LEFT OUTER JOIN T2 c ON c.key+1=a.key select
sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM T1 a LEFT OUTER JOIN T2 c ON c.key+1=a.key
select sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
@@ -8637,9 +8755,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing statistics. Please check log for more
details.
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -8687,6 +8805,7 @@ Stage-0
|<-TableScan [TS_0]
alias:a
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain FROM T1 a RIGHT OUTER JOIN T2 c ON c.key+1=a.key
select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)),
sum(hash(c.key))
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM T1 a RIGHT OUTER JOIN T2 c ON c.key+1=a.key
select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)),
sum(hash(c.key))
@@ -8694,8 +8813,8 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing feature [Hint].
Vertex dependency in root stage
-Reducer 3 <- Map 2 (SIMPLE_EDGE)
Map 2 <- Map 1 (BROADCAST_EDGE)
+Reducer 3 <- Map 2 (SIMPLE_EDGE)
Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
Stage-0
@@ -8744,6 +8863,7 @@ Stage-0
|<-TableScan [TS_1]
alias:c
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain FROM T1 a FULL OUTER JOIN T2 c ON c.key+1=a.key select
/*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)), sum(hash(c.key))
PREHOOK: type: QUERY
POSTHOOK: query: explain FROM T1 a FULL OUTER JOIN T2 c ON c.key+1=a.key
select /*+ STREAMTABLE(a) */ sum(hash(a.key)), sum(hash(a.val)),
sum(hash(c.key))
@@ -8808,6 +8928,7 @@ Stage-0
TableScan [TS_1]
alias:c
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
PREHOOK: query: explain select /*+ mapjoin(v)*/ sum(hash(k.key)),
sum(hash(v.val)) from T1 k left outer join T1 v on k.key+1=v.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ mapjoin(v)*/ sum(hash(k.key)),
sum(hash(v.val)) from T1 k left outer join T1 v on k.key+1=v.key
@@ -8815,9 +8936,9 @@ POSTHOOK: type: QUERY
Plan not optimized by CBO due to missing feature [Hint].
Vertex dependency in root stage
+Map 1 <- Map 4 (BROADCAST_EDGE)
Reducer 2 <- Map 1 (SIMPLE_EDGE)
Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-Map 1 <- Map 4 (BROADCAST_EDGE)
Stage-0
Fetch Operator
@@ -8865,3 +8986,4 @@ Stage-0
|<-TableScan [TS_0]
alias:k
Statistics:Num rows: 1 Data size: 30 Basic
stats: COMPLETE Column stats: NONE
+
