http://git-wip-us.apache.org/repos/asf/hive/blob/73eb9239/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
index 8156789..57fcc3c 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
@@ -335,245 +335,248 @@ Stage-0
limit:100
Stage-1
Reducer 5
- File Output Operator [FS_69]
+ File Output Operator [FS_68]
compressed:false
Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE
Column stats: NONE
table:{"input
format:":"org.apache.hadoop.mapred.TextInputFormat","output
format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
- Limit [LIM_68]
+ Limit [LIM_67]
Number of rows:100
Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE
Column stats: NONE
- Select Operator [SEL_67]
+ Select Operator [SEL_66]
|
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_66]
+ Reduce Output Operator [RS_65]
key expressions:_col0 (type: string), _col1 (type:
string), _col2 (type: string)
sort order:+++
Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
value expressions:_col3 (type: bigint), _col4 (type:
bigint), _col5 (type: bigint)
- Group By Operator [GBY_64]
- |
aggregations:["count(VALUE._col0)","count(VALUE._col1)","count(VALUE._col2)"]
- | keys:KEY._col0 (type: string), KEY._col1 (type:
string), KEY._col2 (type: string)
- |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
- | Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
- |<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_63]
- key expressions:_col0 (type: string), _col1 (type:
string), _col2 (type: string)
- Map-reduce partition columns:_col0 (type: string),
_col1 (type: string), _col2 (type: string)
- sort order:+++
- Statistics:Num rows: 804 Data size: 8552 Basic
stats: COMPLETE Column stats: NONE
- value expressions:_col3 (type: bigint), _col4
(type: bigint), _col5 (type: bigint)
- Group By Operator [GBY_62]
-
aggregations:["count(_col3)","count(_col4)","count(_col5)"]
- keys:_col0 (type: string), _col1 (type: string),
_col2 (type: string)
-
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Select Operator [SEL_64]
+
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
+ Group By Operator [GBY_63]
+ |
aggregations:["count(VALUE._col0)","count(VALUE._col1)","count(VALUE._col2)"]
+ | keys:KEY._col0 (type: string), KEY._col1 (type:
string), KEY._col2 (type: string)
+ |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ | Statistics:Num rows: 402 Data size: 4276 Basic
stats: COMPLETE Column stats: NONE
+ |<-Reducer 3 [SIMPLE_EDGE]
+ Reduce Output Operator [RS_62]
+ key expressions:_col0 (type: string), _col1
(type: string), _col2 (type: string)
+ Map-reduce partition columns:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
+ sort order:+++
Statistics:Num rows: 804 Data size: 8552 Basic
stats: COMPLETE Column stats: NONE
- Select Operator [SEL_60]
+ value expressions:_col3 (type: bigint), _col4
(type: bigint), _col5 (type: bigint)
+ Group By Operator [GBY_61]
+
aggregations:["count(_col13)","count(_col21)","count(_col3)"]
+ keys:_col2 (type: string), _col12 (type:
string), _col20 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_111]
- | condition map:[{"":"Inner Join 0 to 1"}]
- | keys:{"0":"_col1 (type: string), _col3
(type: string)","1":"_col15 (type: string), _col17 (type: string)"}
- |
outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
- | Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
- |<-Reducer 11 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_58]
- | key expressions:_col15 (type: string),
_col17 (type: string)
- | Map-reduce partition columns:_col15
(type: string), _col17 (type: string)
- | sort order:++
- | Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col6 (type: string),
_col7 (type: string), _col14 (type: string)
- | Select Operator [SEL_49]
- |
outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
- | Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_110]
- | | condition map:[{"":"Inner Join 0
to 1"}]
- | | keys:{"0":"_col4 (type: string),
_col6 (type: string)","1":"_col2 (type: string), _col4 (type: string)"}
- | |
outputColumnNames:["_col2","_col3","_col14","_col15","_col17"]
- | | Statistics:Num rows: 731 Data
size: 7775 Basic stats: COMPLETE Column stats: NONE
- | |<-Reducer 10 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_45]
- | | key expressions:_col4 (type:
string), _col6 (type: string)
- | | Map-reduce partition
columns:_col4 (type: string), _col6 (type: string)
- | | sort order:++
- | | Statistics:Num rows: 665 Data
size: 7069 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col2 (type:
string), _col3 (type: string)
- | | Merge Join Operator
[MERGEJOIN_108]
- | | | condition map:[{"":"Inner
Join 0 to 1"}]
- | | | keys:{"0":"_col3 (type:
string)","1":"_col1 (type: string)"}
- | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | | | Statistics:Num rows: 665
Data size: 7069 Basic stats: COMPLETE Column stats: NONE
- | | |<-Map 14 [SIMPLE_EDGE]
- | | | Reduce Output Operator
[RS_42]
- | | | key expressions:_col1
(type: string)
- | | | Map-reduce partition
columns:_col1 (type: string)
- | | | sort order:+
- | | | Statistics:Num rows: 6
Data size: 45 Basic stats: COMPLETE Column stats: NONE
- | | | Select Operator [SEL_16]
- | | |
outputColumnNames:["_col1"]
- | | | Statistics:Num rows:
6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator
[FIL_102]
- | | | predicate:((key =
'src1key') and value is not null) (type: boolean)
- | | | Statistics:Num
rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
- | | | TableScan [TS_14]
- | | | alias:src1
- | | | Statistics:Num
rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | |<-Reducer 9 [SIMPLE_EDGE]
- | | Reduce Output Operator
[RS_40]
- | | key expressions:_col3
(type: string)
- | | Map-reduce partition
columns:_col3 (type: string)
- | | sort order:+
- | | Statistics:Num rows: 605
Data size: 6427 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col2
(type: string), _col4 (type: string), _col6 (type: string)
- | | Merge Join Operator
[MERGEJOIN_107]
- | | | condition
map:[{"":"Inner Join 0 to 1"}]
- | | | keys:{"0":"_col2
(type: string)","1":"_col0 (type: string)"}
- | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | | | Statistics:Num rows:
605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
- | | |<-Map 13 [SIMPLE_EDGE]
- | | | Reduce Output
Operator [RS_37]
- | | | key
expressions:_col0 (type: string)
- | | | Map-reduce
partition columns:_col0 (type: string)
- | | | sort order:+
- | | | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | | | Select Operator
[SEL_13]
- | | |
outputColumnNames:["_col0"]
- | | | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator
[FIL_101]
- | | |
predicate:((value = 'd1value') and key is not null) (type: boolean)
- | | |
Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats:
NONE
- | | | TableScan
[TS_11]
- | | | alias:d1
- | | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
- | | |<-Reducer 8
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_35]
- | | key
expressions:_col2 (type: string)
- | | Map-reduce
partition columns:_col2 (type: string)
- | | sort order:+
- | | Statistics:Num
rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- | | value
expressions:_col3 (type: string), _col4 (type: string), _col6 (type: string)
- | | Merge Join
Operator [MERGEJOIN_106]
- | | | condition
map:[{"":"Inner Join 0 to 1"}]
- | | |
keys:{"0":"_col1 (type: string)","1":"_col3 (type: string)"}
- | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | | | Statistics:Num
rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- | | |<-Map 12
[SIMPLE_EDGE]
- | | | Reduce Output
Operator [RS_32]
- | | | key
expressions:_col3 (type: string)
- | | | Map-reduce
partition columns:_col3 (type: string)
- | | | sort order:+
- | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | | value
expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string),
_col4 (type: string)
- | | | Select
Operator [SEL_10]
- | | |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
- | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | | Filter
Operator [FIL_100]
- | | |
predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is
not null) and k2 is not null) and k3 is not null) (type: boolean)
- | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | |
TableScan [TS_8]
- | | |
alias:ss
- | | |
Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
- | | |<-Map 7
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_30]
- | | key
expressions:_col1 (type: string)
- | | Map-reduce
partition columns:_col1 (type: string)
- | | sort order:+
- | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
- | | Select
Operator [SEL_7]
- | |
outputColumnNames:["_col1"]
- | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
- | | Filter
Operator [FIL_99]
- | |
predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
- | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
- | |
TableScan [TS_5]
- | |
alias:srcpart
- | |
Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats:
NONE
- | |<-Reducer 16 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_47]
- | key expressions:_col2 (type:
string), _col4 (type: string)
- | Map-reduce partition
columns:_col2 (type: string), _col4 (type: string)
- | sort order:++
- | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col3 (type:
string), _col5 (type: string)
- | Merge Join Operator
[MERGEJOIN_109]
- | | condition map:[{"":"Inner
Join 0 to 1"}]
- | | keys:{"0":"_col0 (type:
string)","1":"_col0 (type: string)"}
- | |
outputColumnNames:["_col2","_col3","_col4","_col5"]
- | | Statistics:Num rows: 137
Data size: 1460 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 15 [SIMPLE_EDGE]
- | | Reduce Output Operator
[RS_24]
- | | key expressions:_col0
(type: string)
- | | Map-reduce partition
columns:_col0 (type: string)
- | | sort order:+
- | | Statistics:Num rows: 2
Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col2
(type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
- | | Select Operator [SEL_19]
- | |
outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
- | | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator
[FIL_103]
- | | predicate:((((((v1
= 'srv1') and k1 is not null) and k2 is not null) and k3 is not null) and v2 is
not null) and v3 is not null) (type: boolean)
- | | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_17]
- | | alias:sr
- | | Statistics:Num
rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 17 [SIMPLE_EDGE]
- | Reduce Output Operator
[RS_26]
- | key expressions:_col0
(type: string)
- | Map-reduce partition
columns:_col0 (type: string)
- | sort order:+
- | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_22]
- |
outputColumnNames:["_col0"]
- | Statistics:Num rows:
125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator
[FIL_104]
- | predicate:((value)
IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
- | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_20]
- | alias:d1
- | Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- |<-Reducer 2 [SIMPLE_EDGE]
- Reduce Output Operator [RS_56]
- key expressions:_col1 (type: string),
_col3 (type: string)
- Map-reduce partition columns:_col1
(type: string), _col3 (type: string)
- sort order:++
- Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
- value expressions:_col2 (type: string)
- Merge Join Operator [MERGEJOIN_105]
- | condition map:[{"":"Inner Join 0 to
1"}]
- | keys:{"0":"_col0 (type:
string)","1":"_col0 (type: string)"}
- |
outputColumnNames:["_col1","_col2","_col3"]
- | Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
- |<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_51]
- | key expressions:_col0 (type:
string)
- | Map-reduce partition
columns:_col0 (type: string)
- | sort order:+
- | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col1 (type:
string), _col2 (type: string), _col3 (type: string)
- | Select Operator [SEL_1]
- |
outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_97]
- | predicate:((k1 is not null
and v2 is not null) and v3 is not null) (type: boolean)
- | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_0]
- | alias:cs
- | Statistics:Num rows: 170
Data size: 5890 Basic stats: COMPLETE Column stats: NONE
- |<-Map 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_53]
- key expressions:_col0 (type:
string)
- Map-reduce partition
columns:_col0 (type: string)
- sort order:+
- Statistics:Num rows: 125 Data
size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_4]
- outputColumnNames:["_col0"]
+ Select Operator [SEL_60]
+
outputColumnNames:["_col2","_col12","_col20","_col13","_col21","_col3"]
+ Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
+ Merge Join Operator [MERGEJOIN_110]
+ | condition map:[{"":"Inner Join 0 to 1"}]
+ | keys:{"0":"_col1 (type: string), _col3
(type: string)","1":"_col15 (type: string), _col17 (type: string)"}
+ |
outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
+ | Statistics:Num rows: 804 Data size:
8552 Basic stats: COMPLETE Column stats: NONE
+ |<-Reducer 11 [SIMPLE_EDGE]
+ | Reduce Output Operator [RS_58]
+ | key expressions:_col15 (type:
string), _col17 (type: string)
+ | Map-reduce partition columns:_col15
(type: string), _col17 (type: string)
+ | sort order:++
+ | Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
+ | value expressions:_col6 (type:
string), _col7 (type: string), _col14 (type: string)
+ | Select Operator [SEL_49]
+ |
outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
+ | Statistics:Num rows: 731 Data
size: 7775 Basic stats: COMPLETE Column stats: NONE
+ | Merge Join Operator
[MERGEJOIN_109]
+ | | condition map:[{"":"Inner Join
0 to 1"}]
+ | | keys:{"0":"_col4 (type:
string), _col6 (type: string)","1":"_col2 (type: string), _col4 (type: string)"}
+ | |
outputColumnNames:["_col2","_col3","_col14","_col15","_col17"]
+ | | Statistics:Num rows: 731 Data
size: 7775 Basic stats: COMPLETE Column stats: NONE
+ | |<-Reducer 10 [SIMPLE_EDGE]
+ | | Reduce Output Operator [RS_45]
+ | | key expressions:_col4
(type: string), _col6 (type: string)
+ | | Map-reduce partition
columns:_col4 (type: string), _col6 (type: string)
+ | | sort order:++
+ | | Statistics:Num rows: 665
Data size: 7069 Basic stats: COMPLETE Column stats: NONE
+ | | value expressions:_col2
(type: string), _col3 (type: string)
+ | | Merge Join Operator
[MERGEJOIN_107]
+ | | | condition
map:[{"":"Inner Join 0 to 1"}]
+ | | | keys:{"0":"_col3 (type:
string)","1":"_col1 (type: string)"}
+ | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
+ | | | Statistics:Num rows: 665
Data size: 7069 Basic stats: COMPLETE Column stats: NONE
+ | | |<-Map 14 [SIMPLE_EDGE]
+ | | | Reduce Output Operator
[RS_42]
+ | | | key expressions:_col1
(type: string)
+ | | | Map-reduce partition
columns:_col1 (type: string)
+ | | | sort order:+
+ | | | Statistics:Num rows:
6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ | | | Select Operator
[SEL_16]
+ | | |
outputColumnNames:["_col1"]
+ | | | Statistics:Num
rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ | | | Filter Operator
[FIL_101]
+ | | | predicate:((key
= 'src1key') and value is not null) (type: boolean)
+ | | | Statistics:Num
rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ | | | TableScan
[TS_14]
+ | | | alias:src1
+ | | |
Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ | | |<-Reducer 9 [SIMPLE_EDGE]
+ | | Reduce Output Operator
[RS_40]
+ | | key expressions:_col3
(type: string)
+ | | Map-reduce partition
columns:_col3 (type: string)
+ | | sort order:+
+ | | Statistics:Num rows:
605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+ | | value
expressions:_col2 (type: string), _col4 (type: string), _col6 (type: string)
+ | | Merge Join Operator
[MERGEJOIN_106]
+ | | | condition
map:[{"":"Inner Join 0 to 1"}]
+ | | | keys:{"0":"_col2
(type: string)","1":"_col0 (type: string)"}
+ | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
+ | | | Statistics:Num
rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+ | | |<-Map 13
[SIMPLE_EDGE]
+ | | | Reduce Output
Operator [RS_37]
+ | | | key
expressions:_col0 (type: string)
+ | | | Map-reduce
partition columns:_col0 (type: string)
+ | | | sort order:+
+ | | | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | | | Select Operator
[SEL_13]
+ | | |
outputColumnNames:["_col0"]
+ | | |
Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats:
NONE
+ | | | Filter
Operator [FIL_100]
+ | | |
predicate:((value = 'd1value') and key is not null) (type: boolean)
+ | | |
Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats:
NONE
+ | | | TableScan
[TS_11]
+ | | |
alias:d1
+ | | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
+ | | |<-Reducer 8
[SIMPLE_EDGE]
+ | | Reduce Output
Operator [RS_35]
+ | | key
expressions:_col2 (type: string)
+ | | Map-reduce
partition columns:_col2 (type: string)
+ | | sort order:+
+ | | Statistics:Num
rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ | | value
expressions:_col3 (type: string), _col4 (type: string), _col6 (type: string)
+ | | Merge Join
Operator [MERGEJOIN_105]
+ | | | condition
map:[{"":"Inner Join 0 to 1"}]
+ | | |
keys:{"0":"_col1 (type: string)","1":"_col3 (type: string)"}
+ | | |
outputColumnNames:["_col2","_col3","_col4","_col6"]
+ | | |
Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats:
NONE
+ | | |<-Map 12
[SIMPLE_EDGE]
+ | | | Reduce
Output Operator [RS_32]
+ | | | key
expressions:_col3 (type: string)
+ | | |
Map-reduce partition columns:_col3 (type: string)
+ | | | sort
order:+
+ | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | | value
expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string),
_col4 (type: string)
+ | | | Select
Operator [SEL_10]
+ | | |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+ | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | | Filter
Operator [FIL_99]
+ | | |
predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is
not null) and k2 is not null) and k3 is not null) (type: boolean)
+ | | |
Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | |
TableScan [TS_8]
+ | | |
alias:ss
+ | | |
Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+ | | |<-Map 7
[SIMPLE_EDGE]
+ | | Reduce
Output Operator [RS_30]
+ | | key
expressions:_col1 (type: string)
+ | |
Map-reduce partition columns:_col1 (type: string)
+ | | sort
order:+
+ | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
+ | | Select
Operator [SEL_7]
+ | |
outputColumnNames:["_col1"]
+ | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
+ | | Filter
Operator [FIL_98]
+ | |
predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
+ | |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
+ | |
TableScan [TS_5]
+ | |
alias:srcpart
+ | |
Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats:
NONE
+ | |<-Reducer 16 [SIMPLE_EDGE]
+ | Reduce Output Operator [RS_47]
+ | key expressions:_col2
(type: string), _col4 (type: string)
+ | Map-reduce partition
columns:_col2 (type: string), _col4 (type: string)
+ | sort order:++
+ | Statistics:Num rows: 137
Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+ | value expressions:_col3
(type: string), _col5 (type: string)
+ | Merge Join Operator
[MERGEJOIN_108]
+ | | condition
map:[{"":"Inner Join 0 to 1"}]
+ | | keys:{"0":"_col0 (type:
string)","1":"_col0 (type: string)"}
+ | |
outputColumnNames:["_col2","_col3","_col4","_col5"]
+ | | Statistics:Num rows: 137
Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+ | |<-Map 15 [SIMPLE_EDGE]
+ | | Reduce Output Operator
[RS_24]
+ | | key expressions:_col0
(type: string)
+ | | Map-reduce partition
columns:_col0 (type: string)
+ | | sort order:+
+ | | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | value
expressions:_col2 (type: string), _col3 (type: string), _col4 (type: string),
_col5 (type: string)
+ | | Select Operator
[SEL_19]
+ | |
outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
+ | | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | Filter Operator
[FIL_102]
+ | |
predicate:((((((v1 = 'srv1') and k1 is not null) and k2 is not null) and k3 is
not null) and v2 is not null) and v3 is not null) (type: boolean)
+ | | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | TableScan
[TS_17]
+ | | alias:sr
+ | |
Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+ | |<-Map 17 [SIMPLE_EDGE]
+ | Reduce Output Operator
[RS_26]
+ | key expressions:_col0
(type: string)
+ | Map-reduce partition
columns:_col0 (type: string)
+ | sort order:+
+ | Statistics:Num rows:
125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Select Operator
[SEL_22]
+ |
outputColumnNames:["_col0"]
+ | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator
[FIL_103]
+ |
predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null)
(type: boolean)
+ | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | TableScan
[TS_20]
+ | alias:d1
+ |
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats:
NONE
+ |<-Reducer 2 [SIMPLE_EDGE]
+ Reduce Output Operator [RS_56]
+ key expressions:_col1 (type:
string), _col3 (type: string)
+ Map-reduce partition columns:_col1
(type: string), _col3 (type: string)
+ sort order:++
+ Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
+ value expressions:_col2 (type:
string)
+ Merge Join Operator [MERGEJOIN_104]
+ | condition map:[{"":"Inner Join 0
to 1"}]
+ | keys:{"0":"_col0 (type:
string)","1":"_col0 (type: string)"}
+ |
outputColumnNames:["_col1","_col2","_col3"]
+ | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 1 [SIMPLE_EDGE]
+ | Reduce Output Operator [RS_51]
+ | key expressions:_col0 (type:
string)
+ | Map-reduce partition
columns:_col0 (type: string)
+ | sort order:+
+ | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
+ | value expressions:_col1 (type:
string), _col2 (type: string), _col3 (type: string)
+ | Select Operator [SEL_1]
+ |
outputColumnNames:["_col0","_col1","_col2","_col3"]
+ | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator [FIL_96]
+ | predicate:((k1 is not
null and v2 is not null) and v3 is not null) (type: boolean)
+ | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_0]
+ | alias:cs
+ | Statistics:Num rows:
170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 6 [SIMPLE_EDGE]
+ Reduce Output Operator [RS_53]
+ key expressions:_col0 (type:
string)
+ Map-reduce partition
columns:_col0 (type: string)
+ sort order:+
Statistics:Num rows: 125 Data
size: 1328 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_98]
- predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+ Select Operator [SEL_4]
+ outputColumnNames:["_col0"]
Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- TableScan [TS_2]
- alias:d1
- Statistics:Num rows: 500
Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator [FIL_97]
+ predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+ Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ TableScan [TS_2]
+ alias:d1
+ Statistics:Num rows:
500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: explain
SELECT x.key, z.value, y.value
@@ -1522,199 +1525,202 @@ Stage-0
limit:100
Stage-1
Reducer 5
- File Output Operator [FS_69]
+ File Output Operator [FS_68]
compressed:false
Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE
Column stats: NONE
table:{"input
format:":"org.apache.hadoop.mapred.TextInputFormat","output
format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
- Limit [LIM_68]
+ Limit [LIM_67]
Number of rows:100
Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE
Column stats: NONE
- Select Operator [SEL_67]
+ Select Operator [SEL_66]
|
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_66]
+ Reduce Output Operator [RS_65]
key expressions:_col0 (type: string), _col1 (type:
string), _col2 (type: string)
sort order:+++
Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
value expressions:_col3 (type: bigint), _col4 (type:
bigint), _col5 (type: bigint)
- Group By Operator [GBY_64]
- |
aggregations:["count(VALUE._col0)","count(VALUE._col1)","count(VALUE._col2)"]
- | keys:KEY._col0 (type: string), KEY._col1 (type:
string), KEY._col2 (type: string)
- |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
- | Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
- |<-Map 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_63]
- key expressions:_col0 (type: string), _col1 (type:
string), _col2 (type: string)
- Map-reduce partition columns:_col0 (type: string),
_col1 (type: string), _col2 (type: string)
- sort order:+++
- Statistics:Num rows: 804 Data size: 8552 Basic
stats: COMPLETE Column stats: NONE
- value expressions:_col3 (type: bigint), _col4
(type: bigint), _col5 (type: bigint)
- Group By Operator [GBY_62]
-
aggregations:["count(_col3)","count(_col4)","count(_col5)"]
- keys:_col0 (type: string), _col1 (type: string),
_col2 (type: string)
-
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Select Operator [SEL_64]
+
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ Statistics:Num rows: 402 Data size: 4276 Basic stats:
COMPLETE Column stats: NONE
+ Group By Operator [GBY_63]
+ |
aggregations:["count(VALUE._col0)","count(VALUE._col1)","count(VALUE._col2)"]
+ | keys:KEY._col0 (type: string), KEY._col1 (type:
string), KEY._col2 (type: string)
+ |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ | Statistics:Num rows: 402 Data size: 4276 Basic
stats: COMPLETE Column stats: NONE
+ |<-Map 3 [SIMPLE_EDGE]
+ Reduce Output Operator [RS_62]
+ key expressions:_col0 (type: string), _col1
(type: string), _col2 (type: string)
+ Map-reduce partition columns:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
+ sort order:+++
Statistics:Num rows: 804 Data size: 8552 Basic
stats: COMPLETE Column stats: NONE
- Select Operator [SEL_60]
+ value expressions:_col3 (type: bigint), _col4
(type: bigint), _col5 (type: bigint)
+ Group By Operator [GBY_61]
+
aggregations:["count(_col13)","count(_col21)","count(_col3)"]
+ keys:_col2 (type: string), _col12 (type:
string), _col20 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
- Map Join Operator [MAPJOIN_111]
- | condition map:[{"":"Inner Join 0 to 1"}]
- | keys:{"Map 2":"_col1 (type: string), _col3
(type: string)","Map 3":"_col15 (type: string), _col17 (type: string)"}
- |
outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
- | Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
- |<-Map 2 [BROADCAST_EDGE]
- | Reduce Output Operator [RS_56]
- | key expressions:_col1 (type: string),
_col3 (type: string)
- | Map-reduce partition columns:_col1
(type: string), _col3 (type: string)
- | sort order:++
- | Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col2 (type: string)
- | Map Join Operator [MAPJOIN_105]
- | | condition map:[{"":"Inner Join 0 to
1"}]
- | | keys:{"Map 1":"_col0 (type:
string)","Map 2":"_col0 (type: string)"}
- | |
outputColumnNames:["_col1","_col2","_col3"]
- | | Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 1 [BROADCAST_EDGE]
- | | Reduce Output Operator [RS_51]
- | | key expressions:_col0 (type:
string)
- | | Map-reduce partition
columns:_col0 (type: string)
- | | sort order:+
- | | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col1 (type:
string), _col2 (type: string), _col3 (type: string)
- | | Select Operator [SEL_1]
- | |
outputColumnNames:["_col0","_col1","_col2","_col3"]
- | | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_97]
- | | predicate:((k1 is not null
and v2 is not null) and v3 is not null) (type: boolean)
- | | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_0]
- | | alias:cs
- | | Statistics:Num rows: 170
Data size: 5890 Basic stats: COMPLETE Column stats: NONE
- | |<-Select Operator [SEL_4]
- | outputColumnNames:["_col0"]
- | Statistics:Num rows: 125 Data
size: 1328 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_98]
- | predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
- | Statistics:Num rows: 125 Data
size: 1328 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_2]
- | alias:d1
- | Statistics:Num rows: 500
Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- |<-Select Operator [SEL_49]
-
outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
- Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator [MAPJOIN_110]
- | condition map:[{"":"Inner Join 0 to
1"}]
- | keys:{"Map 3":"_col4 (type: string),
_col6 (type: string)","Map 10":"_col2 (type: string), _col4 (type: string)"}
- |
outputColumnNames:["_col2","_col3","_col14","_col15","_col17"]
- | Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
- |<-Map 10 [BROADCAST_EDGE]
- | Reduce Output Operator [RS_47]
- | key expressions:_col2 (type:
string), _col4 (type: string)
- | Map-reduce partition
columns:_col2 (type: string), _col4 (type: string)
- | sort order:++
- | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col3 (type:
string), _col5 (type: string)
- | Map Join Operator [MAPJOIN_109]
- | | condition map:[{"":"Inner Join
0 to 1"}]
- | | keys:{"Map 9":"_col0 (type:
string)","Map 10":"_col0 (type: string)"}
- | |
outputColumnNames:["_col2","_col3","_col4","_col5"]
- | | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 9 [BROADCAST_EDGE]
- | | Reduce Output Operator [RS_24]
- | | key expressions:_col0
(type: string)
- | | Map-reduce partition
columns:_col0 (type: string)
- | | sort order:+
- | | Statistics:Num rows: 2 Data
size: 69 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col2
(type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
- | | Select Operator [SEL_19]
- | |
outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
- | | Statistics:Num rows: 2
Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_103]
- | | predicate:((((((v1 =
'srv1') and k1 is not null) and k2 is not null) and k3 is not null) and v2 is
not null) and v3 is not null) (type: boolean)
- | | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_17]
- | | alias:sr
- | | Statistics:Num
rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
- | |<-Select Operator [SEL_22]
- | outputColumnNames:["_col0"]
- | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_104]
- | predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
- | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_20]
- | alias:d1
- | Statistics:Num rows:
500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- |<-Map Join Operator [MAPJOIN_108]
+ Select Operator [SEL_60]
+
outputColumnNames:["_col2","_col12","_col20","_col13","_col21","_col3"]
+ Statistics:Num rows: 804 Data size: 8552
Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator [MAPJOIN_110]
+ | condition map:[{"":"Inner Join 0 to 1"}]
+ | keys:{"Map 2":"_col1 (type: string),
_col3 (type: string)","Map 3":"_col15 (type: string), _col17 (type: string)"}
+ |
outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
+ | Statistics:Num rows: 804 Data size:
8552 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 2 [BROADCAST_EDGE]
+ | Reduce Output Operator [RS_56]
+ | key expressions:_col1 (type:
string), _col3 (type: string)
+ | Map-reduce partition columns:_col1
(type: string), _col3 (type: string)
+ | sort order:++
+ | Statistics:Num rows: 137 Data size:
1460 Basic stats: COMPLETE Column stats: NONE
+ | value expressions:_col2 (type:
string)
+ | Map Join Operator [MAPJOIN_104]
+ | | condition map:[{"":"Inner Join 0
to 1"}]
+ | | keys:{"Map 1":"_col0 (type:
string)","Map 2":"_col0 (type: string)"}
+ | |
outputColumnNames:["_col1","_col2","_col3"]
+ | | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
+ | |<-Map 1 [BROADCAST_EDGE]
+ | | Reduce Output Operator [RS_51]
+ | | key expressions:_col0 (type:
string)
+ | | Map-reduce partition
columns:_col0 (type: string)
+ | | sort order:+
+ | | Statistics:Num rows: 22 Data
size: 762 Basic stats: COMPLETE Column stats: NONE
+ | | value expressions:_col1 (type:
string), _col2 (type: string), _col3 (type: string)
+ | | Select Operator [SEL_1]
+ | |
outputColumnNames:["_col0","_col1","_col2","_col3"]
+ | | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
+ | | Filter Operator [FIL_96]
+ | | predicate:((k1 is not
null and v2 is not null) and v3 is not null) (type: boolean)
+ | | Statistics:Num rows: 22
Data size: 762 Basic stats: COMPLETE Column stats: NONE
+ | | TableScan [TS_0]
+ | | alias:cs
+ | | Statistics:Num rows:
170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
+ | |<-Select Operator [SEL_4]
+ | outputColumnNames:["_col0"]
+ | Statistics:Num rows: 125 Data
size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator [FIL_97]
+ | predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+ | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_2]
+ | alias:d1
+ | Statistics:Num rows: 500
Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ |<-Select Operator [SEL_49]
+
outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
+ Statistics:Num rows: 731 Data size:
7775 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator [MAPJOIN_109]
| condition map:[{"":"Inner Join 0
to 1"}]
- | keys:{"Map 3":"_col3 (type:
string)","Map 8":"_col1 (type: string)"}
- |
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | Statistics:Num rows: 665 Data
size: 7069 Basic stats: COMPLETE Column stats: NONE
- |<-Map 8 [BROADCAST_EDGE]
- | Reduce Output Operator [RS_42]
- | key expressions:_col1 (type:
string)
- | Map-reduce partition
columns:_col1 (type: string)
- | sort order:+
- | Statistics:Num rows: 6 Data
size: 45 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_16]
- | outputColumnNames:["_col1"]
- | Statistics:Num rows: 6 Data
size: 45 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_102]
- | predicate:((key =
'src1key') and value is not null) (type: boolean)
- | Statistics:Num rows: 6
Data size: 45 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_14]
- | alias:src1
- | Statistics:Num rows:
25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ | keys:{"Map 3":"_col4 (type:
string), _col6 (type: string)","Map 10":"_col2 (type: string), _col4 (type:
string)"}
+ |
outputColumnNames:["_col2","_col3","_col14","_col15","_col17"]
+ | Statistics:Num rows: 731 Data
size: 7775 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 10 [BROADCAST_EDGE]
+ | Reduce Output Operator [RS_47]
+ | key expressions:_col2 (type:
string), _col4 (type: string)
+ | Map-reduce partition
columns:_col2 (type: string), _col4 (type: string)
+ | sort order:++
+ | Statistics:Num rows: 137 Data
size: 1460 Basic stats: COMPLETE Column stats: NONE
+ | value expressions:_col3 (type:
string), _col5 (type: string)
+ | Map Join Operator [MAPJOIN_108]
+ | | condition map:[{"":"Inner
Join 0 to 1"}]
+ | | keys:{"Map 9":"_col0 (type:
string)","Map 10":"_col0 (type: string)"}
+ | |
outputColumnNames:["_col2","_col3","_col4","_col5"]
+ | | Statistics:Num rows: 137
Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+ | |<-Map 9 [BROADCAST_EDGE]
+ | | Reduce Output Operator
[RS_24]
+ | | key expressions:_col0
(type: string)
+ | | Map-reduce partition
columns:_col0 (type: string)
+ | | sort order:+
+ | | Statistics:Num rows: 2
Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | value expressions:_col2
(type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+ | | Select Operator [SEL_19]
+ | |
outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
+ | | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | Filter Operator
[FIL_102]
+ | | predicate:((((((v1
= 'srv1') and k1 is not null) and k2 is not null) and k3 is not null) and v2 is
not null) and v3 is not null) (type: boolean)
+ | | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | | TableScan [TS_17]
+ | | alias:sr
+ | | Statistics:Num
rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+ | |<-Select Operator [SEL_22]
+ |
outputColumnNames:["_col0"]
+ | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator [FIL_103]
+ | predicate:((value) IN
('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+ | Statistics:Num rows:
125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_20]
+ | alias:d1
+ | Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Map Join Operator [MAPJOIN_107]
| condition map:[{"":"Inner Join
0 to 1"}]
- | keys:{"Map 3":"_col2 (type:
string)","Map 7":"_col0 (type: string)"}
+ | keys:{"Map 3":"_col3 (type:
string)","Map 8":"_col1 (type: string)"}
|
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | Statistics:Num rows: 605 Data
size: 6427 Basic stats: COMPLETE Column stats: NONE
- |<-Map 7 [BROADCAST_EDGE]
- | Reduce Output Operator [RS_37]
- | key expressions:_col0
(type: string)
- | Map-reduce partition
columns:_col0 (type: string)
+ | Statistics:Num rows: 665 Data
size: 7069 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 8 [BROADCAST_EDGE]
+ | Reduce Output Operator [RS_42]
+ | key expressions:_col1
(type: string)
+ | Map-reduce partition
columns:_col1 (type: string)
| sort order:+
- | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_13]
- |
outputColumnNames:["_col0"]
- | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 6 Data
size: 45 Basic stats: COMPLETE Column stats: NONE
+ | Select Operator [SEL_16]
+ |
outputColumnNames:["_col1"]
+ | Statistics:Num rows: 6
Data size: 45 Basic stats: COMPLETE Column stats: NONE
| Filter Operator [FIL_101]
- | predicate:((value =
'd1value') and key is not null) (type: boolean)
- | Statistics:Num rows:
125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_11]
- | alias:d1
- | Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ | predicate:((key =
'src1key') and value is not null) (type: boolean)
+ | Statistics:Num rows:
6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_14]
+ | alias:src1
+ | Statistics:Num
rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
|<-Map Join Operator [MAPJOIN_106]
| condition map:[{"":"Inner
Join 0 to 1"}]
- | keys:{"Map 3":"_col1 (type:
string)","Map 6":"_col3 (type: string)"}
+ | keys:{"Map 3":"_col2 (type:
string)","Map 7":"_col0 (type: string)"}
|
outputColumnNames:["_col2","_col3","_col4","_col6"]
- | Statistics:Num rows: 550
Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- |<-Map 6 [BROADCAST_EDGE]
- | Reduce Output Operator
[RS_32]
- | key expressions:_col3
(type: string)
- | Map-reduce partition
columns:_col3 (type: string)
+ | Statistics:Num rows: 605
Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 7 [BROADCAST_EDGE]
+ | Reduce Output Operator
[RS_37]
+ | key expressions:_col0
(type: string)
+ | Map-reduce partition
columns:_col0 (type: string)
| sort order:+
- | Statistics:Num rows: 2
Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col0
(type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
- | Select Operator [SEL_10]
- |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
- | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | Statistics:Num rows: 125
Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | Select Operator [SEL_13]
+ |
outputColumnNames:["_col0"]
+ | Statistics:Num rows:
125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
| Filter Operator
[FIL_100]
- | predicate:((((((v3
= 'ssv3') and v2 is not null) and k1 is not null) and v1 is not null) and k2 is
not null) and k3 is not null) (type: boolean)
- | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_8]
- | alias:ss
- | Statistics:Num
rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
- |<-Select Operator [SEL_7]
-
outputColumnNames:["_col1"]
- Statistics:Num rows: 500
Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_99]
- predicate:((key =
'srcpartkey') and value is not null) (type: boolean)
+ | predicate:((value
= 'd1value') and key is not null) (type: boolean)
+ | Statistics:Num
rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_11]
+ | alias:d1
+ | Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ |<-Map Join Operator
[MAPJOIN_105]
+ | condition
map:[{"":"Inner Join 0 to 1"}]
+ | keys:{"Map 3":"_col1
(type: string)","Map 6":"_col3 (type: string)"}
+ |
outputColumnNames:["_col2","_col3","_col4","_col6"]
+ | Statistics:Num rows: 550
Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ |<-Map 6 [BROADCAST_EDGE]
+ | Reduce Output Operator
[RS_32]
+ | key expressions:_col3
(type: string)
+ | Map-reduce partition
columns:_col3 (type: string)
+ | sort order:+
+ | Statistics:Num rows:
2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | value
expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string),
_col4 (type: string)
+ | Select Operator
[SEL_10]
+ |
outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+ | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator
[FIL_99]
+ |
predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is
not null) and k2 is not null) and k3 is not null) (type: boolean)
+ | Statistics:Num
rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+ | TableScan [TS_8]
+ | alias:ss
+ |
Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+ |<-Select Operator [SEL_7]
+
outputColumnNames:["_col1"]
Statistics:Num rows:
500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- TableScan [TS_5]
- alias:srcpart
- Statistics:Num
rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
[FIL_98]
+ predicate:((key =
'srcpartkey') and value is not null) (type: boolean)
+ Statistics:Num
rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ TableScan [TS_5]
+ 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
