You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/10/20 21:46:17 UTC
svn commit: r1633210 [8/14] - in /hive/branches/spark/ql/src:
java/org/apache/hadoop/hive/ql/optimizer/ test/results/clientpositive/spark/
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out?rev=1633210&r1=1633209&r2=1633210&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/multi_insert_lateral_view.q.out Mon Oct 20 19:46:13 2014
@@ -76,6 +76,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_10
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -91,16 +92,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -109,15 +115,20 @@ STAGE PLANS:
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -161,16 +172,21 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -179,15 +195,20 @@ STAGE PLANS:
Select Operator
expressions: array((key + 3),(key + 4)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -309,6 +330,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_10
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -326,43 +348,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Reducer 4
Reduce Operator Tree:
@@ -371,11 +405,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -421,43 +458,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Select Operator
expressions: array((key + 3),(key + 4)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 2 Data size: 228 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: double)
Reducer 5
Reduce Operator Tree:
@@ -466,11 +515,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -576,6 +628,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_10
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
table:
@@ -593,43 +646,55 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: _col1 (type: double)
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: _col1 (type: double)
Reducer 4
Reduce Operator Tree:
@@ -638,11 +703,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -702,29 +770,37 @@ STAGE PLANS:
TableScan
Filter Operator
predicate: ((key > 200) or (key < 200)) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
sort order: +
Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: value (type: string)
Reducer 5
Reduce Operator Tree:
Forward
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
predicate: (KEY._col0 > 200) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string)
mode: complete
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -732,16 +808,20 @@ STAGE PLANS:
name: default.src_lv2
Filter Operator
predicate: (KEY._col0 < 200) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string)
mode: complete
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -867,6 +947,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_10
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
table:
@@ -884,42 +965,54 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col5 (type: double), _col0 (type: string)
outputColumnNames: _col5, _col0
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: double)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col5 (type: double), _col0 (type: string)
outputColumnNames: _col5, _col0
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: double)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 5
Reduce Operator Tree:
Group By Operator
@@ -927,11 +1020,14 @@ STAGE PLANS:
keys: KEY._col0 (type: double)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: double), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -990,42 +1086,54 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col5 (type: double), _col0 (type: string)
outputColumnNames: _col5, _col0
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: double)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: array((key + 3),(key + 4)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col5 (type: double), _col0 (type: string)
outputColumnNames: _col5, _col0
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: double), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: double)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 6
Reduce Operator Tree:
Group By Operator
@@ -1033,11 +1141,14 @@ STAGE PLANS:
keys: KEY._col0 (type: double)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: double), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1056,15 +1167,18 @@ STAGE PLANS:
Select Operator
expressions: value (type: string), key (type: string)
outputColumnNames: value, key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT key)
keys: value (type: string), key (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 7
Reduce Operator Tree:
Group By Operator
@@ -1072,11 +1186,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1232,6 +1349,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_10
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
File Output Operator
compressed: false
table:
@@ -1249,42 +1367,54 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col5)
keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col5)
keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 5
Reduce Operator Tree:
Group By Operator
@@ -1292,11 +1422,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1368,42 +1501,54 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Lateral View Forward
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: key
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col5)
keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: array((key + 3),(key + 4)) (type: array<double>)
outputColumnNames: _col0
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
UDTF Operator
+ Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col5
+ Statistics: Num rows: 0 Data size: 228 Basic stats: PARTIAL Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col5)
keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: double)
sort order: ++
Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 6
Reduce Operator Tree:
Group By Operator
@@ -1411,11 +1556,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1433,28 +1581,36 @@ STAGE PLANS:
TableScan
Filter Operator
predicate: ((key > 200) or (key < 200)) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
key expressions: value (type: string), key (type: string)
sort order: ++
Map-reduce partition columns: value (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 7
Reduce Operator Tree:
Forward
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
predicate: (KEY._col1:0._col0 > 200) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0)
keys: KEY._col0 (type: string)
mode: complete
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1462,16 +1618,20 @@ STAGE PLANS:
name: default.src_lv3
Filter Operator
predicate: (KEY._col1:0._col0 < 200) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0)
keys: KEY._col0 (type: string)
mode: complete
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: double)
outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat