You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by we...@apache.org on 2017/09/08 06:35:31 UTC
[39/74] [abbrv] [partial] hive git commit: HIVE-16811 : Estimate
statistics in absence of stats (Vineet Garg, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
index c56c818..4cdb4861 100644
--- a/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_access_stats.q.out
@@ -185,14 +185,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -203,14 +203,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: val (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -273,14 +273,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -291,14 +291,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 60 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 368 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -387,38 +387,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 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: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 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: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -431,10 +431,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -518,19 +518,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(val) = 3.0) and key is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 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: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -538,19 +538,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(val) = 3.0) and key is not null) (type: boolean)
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 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: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -564,10 +564,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -620,38 +620,38 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) = 5.0) and val is not null) (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: val (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 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: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 3
Map Operator Tree:
TableScan
alias: t2
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((UDFToDouble(key) = 6.0) and val is not null) (type: boolean)
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: val (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 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: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 736 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Reducer 2
@@ -664,10 +664,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 809 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -733,58 +733,58 @@ STAGE PLANS:
Map 1
Map Operator Tree:
TableScan
- alias: t1
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ alias: t2
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 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: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 920 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 4
Map Operator Tree:
TableScan
- alias: t2
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ alias: t1
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 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: 5 Data size: 15 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Execution mode: llap
LLAP IO: no inputs
Map 5
Map Operator Tree:
TableScan
alias: t3
- Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), val (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 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: 5 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: llap
LLAP IO: no inputs
@@ -797,13 +797,17 @@ STAGE PLANS:
keys:
0 _col0 (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 5 Data size: 16 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: 5 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ outputColumnNames: _col1
+ Statistics: Num rows: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col1 (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 5 Data size: 1012 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: 5 Data size: 1012 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Execution mode: llap
Reduce Operator Tree:
@@ -814,10 +818,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 5 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1113 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 5 Data size: 17 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 1113 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -850,10 +854,10 @@ PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
PREHOOK: Input: default@t3
#### A masked pattern was here ####
-Table:default@t1
+Table:default@t2
Columns:key
-Table:default@t2
+Table:default@t1
Columns:key
Table:default@t3
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
index 75d8946..c397f80 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out
@@ -73,22 +73,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 10672 Basic stats: COMPLETE Column stats: NONE
Statistics Aggregation Key Prefix: default.s/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 29 Data size: 10672 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
auto parallelism: false
@@ -151,13 +151,13 @@ STAGE PLANS:
aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -332,13 +332,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: spart
- Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
Statistics Aggregation Key Prefix: default.spart/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: key, value, ds, hr
- Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
keys: ds (type: string), hr (type: string)
@@ -749,13 +749,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: spart
- Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
Statistics Aggregation Key Prefix: default.spart/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: key, value, ds, hr
- Statistics: Num rows: 58 Data size: 32968 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 58 Data size: 53944 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
keys: ds (type: string), hr (type: string)
@@ -1166,13 +1166,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: spart
- Statistics: Num rows: 29 Data size: 11148 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 29 Data size: 21820 Basic stats: COMPLETE Column stats: PARTIAL
Statistics Aggregation Key Prefix: default.spart/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string), ds (type: string)
outputColumnNames: key, value, ds
- Statistics: Num rows: 29 Data size: 11148 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 29 Data size: 21820 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
keys: ds (type: string), '11' (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
index c84a37d..c719976 100644
--- a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
+++ b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out
@@ -74,22 +74,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s
- Statistics: Num rows: 1 Data size: 170 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Statistics Aggregation Key Prefix: default.s/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 1 Data size: 170 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
null sort order:
sort order:
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
tag: -1
value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>)
auto parallelism: false
@@ -154,13 +154,13 @@ STAGE PLANS:
aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 880 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 1248 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -329,13 +329,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: spart
- Statistics: Num rows: 2 Data size: 1076 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 2 Data size: 1812 Basic stats: COMPLETE Column stats: PARTIAL
Statistics Aggregation Key Prefix: default.spart/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: key, value, ds, hr
- Statistics: Num rows: 2 Data size: 1076 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 2 Data size: 1812 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
keys: ds (type: string), hr (type: string)
@@ -734,13 +734,13 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: spart
- Statistics: Num rows: 1 Data size: 354 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 1 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
Statistics Aggregation Key Prefix: default.spart/
GatherStats: true
Select Operator
expressions: key (type: string), value (type: string), ds (type: string)
outputColumnNames: key, value, ds
- Statistics: Num rows: 1 Data size: 354 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 1 Data size: 722 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll')
keys: ds (type: string), '11' (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
index 8f51db3..a147d15 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_dpp.q.out
@@ -52,34 +52,34 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_17]
- Merge Join Operator [MERGEJOIN_21] (rows=1 width=0)
+ Merge Join Operator [MERGEJOIN_21] (rows=1 width=4)
Conds:RS_13._col0=RS_14._col0(Left Outer),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_13]
PartitionCols:_col0
- Select Operator [SEL_1] (rows=1 width=0)
+ Select Operator [SEL_1] (rows=1 width=4)
Output:["_col0"]
- TableScan [TS_0] (rows=1 width=0)
- default@tb1,a,Tbl:PARTIAL,Col:NONE,Output:["id"]
+ TableScan [TS_0] (rows=1 width=4)
+ default@tb1,a,Tbl:COMPLETE,Col:NONE,Output:["id"]
<-Reducer 5 [SIMPLE_EDGE] llap
SHUFFLE [RS_14]
PartitionCols:_col0
- Limit [LIM_11] (rows=1 width=0)
+ Limit [LIM_11] (rows=1 width=8)
Number of rows:1
- Select Operator [SEL_10] (rows=1 width=0)
+ Select Operator [SEL_10] (rows=1 width=8)
Output:["_col0"]
<-Union 4 [CUSTOM_SIMPLE_EDGE]
<-Map 3 [CONTAINS] llap
Reduce Output Operator [RS_9]
- Limit [LIM_8] (rows=1 width=0)
+ Limit [LIM_8] (rows=1 width=4)
Number of rows:1
- Select Operator [SEL_3] (rows=1 width=0)
+ Select Operator [SEL_3] (rows=1 width=4)
Output:["_col0"]
- TableScan [TS_2] (rows=1 width=0)
+ TableScan [TS_2] (rows=1 width=4)
Output:["id"]
<-Map 6 [CONTAINS] llap
Reduce Output Operator [RS_9]
- Limit [LIM_8] (rows=1 width=0)
+ Limit [LIM_8] (rows=1 width=4)
Number of rows:1
Select Operator [SEL_5] (rows=1 width=0)
Output:["_col0"]
http://git-wip-us.apache.org/repos/asf/hive/blob/8f7c5788/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
index 4bdb186..935a8b4 100644
--- a/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
+++ b/ql/src/test/results/clientpositive/llap/constprog_semijoin.q.out
@@ -62,29 +62,29 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Select Operator [SEL_11] (rows=5 width=22)
+ Select Operator [SEL_11] (rows=5 width=413)
Output:["_col0","_col1","_col2"]
- Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
Conds:RS_8._col3=RS_9._col0(Left Semi),Output:["_col0","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:_col3
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=376)
Output:["_col0","_col2","_col3"]
- Filter Operator [FIL_15] (rows=5 width=20)
+ Filter Operator [FIL_15] (rows=5 width=376)
predicate:((val = 't1val01') and dimid is not null)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=376)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0
- Group By Operator [GBY_7] (rows=5 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0"],keys:_col0
- Select Operator [SEL_5] (rows=5 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0"]
- Filter Operator [FIL_16] (rows=5 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:id is not null
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id where table1.val = 't1val01'
@@ -116,43 +116,43 @@ Stage-0
Stage-1
Reducer 3 llap
File Output Operator [FS_18]
- Select Operator [SEL_17] (rows=5 width=24)
+ Select Operator [SEL_17] (rows=5 width=232)
Output:["_col0","_col1","_col2"]
- Merge Join Operator [MERGEJOIN_28] (rows=5 width=24)
+ Merge Join Operator [MERGEJOIN_28] (rows=5 width=232)
Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"]
<-Map 5 [SIMPLE_EDGE] llap
SHUFFLE [RS_15]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=3 width=10)
+ Select Operator [SEL_8] (rows=3 width=188)
Output:["_col0","_col1"]
- Filter Operator [FIL_26] (rows=3 width=10)
+ Filter Operator [FIL_26] (rows=3 width=188)
predicate:id is not null
- TableScan [TS_6] (rows=3 width=10)
+ TableScan [TS_6] (rows=3 width=188)
default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_14]
PartitionCols:_col0
- Merge Join Operator [MERGEJOIN_27] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_27] (rows=5 width=211)
Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_11]
PartitionCols:_col2
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=192)
Output:["_col0","_col2"]
- Filter Operator [FIL_24] (rows=5 width=20)
+ Filter Operator [FIL_24] (rows=5 width=192)
predicate:((val = 't1val01') and id is not null and dimid is not null)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=192)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"]
<-Map 4 [SIMPLE_EDGE] llap
SHUFFLE [RS_12]
PartitionCols:_col0
- Group By Operator [GBY_10] (rows=5 width=3)
+ Group By Operator [GBY_10] (rows=5 width=4)
Output:["_col0"],keys:_col0
- Select Operator [SEL_5] (rows=5 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0"]
- Filter Operator [FIL_25] (rows=5 width=3)
+ Filter Operator [FIL_25] (rows=5 width=4)
predicate:id is not null
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 inner join table2 on table1.val = 't1val01' and table1.id = table2.id left semi join table3 on table1.dimid = table3.id
@@ -186,43 +186,43 @@ Stage-0
Stage-1
Reducer 3 llap
File Output Operator [FS_18]
- Select Operator [SEL_17] (rows=5 width=24)
+ Select Operator [SEL_17] (rows=5 width=232)
Output:["_col0","_col1","_col2"]
- Merge Join Operator [MERGEJOIN_28] (rows=5 width=24)
+ Merge Join Operator [MERGEJOIN_28] (rows=5 width=232)
Conds:RS_14._col0=RS_15._col0(Inner),Output:["_col0","_col4"]
<-Map 5 [SIMPLE_EDGE] llap
SHUFFLE [RS_15]
PartitionCols:_col0
- Select Operator [SEL_8] (rows=3 width=10)
+ Select Operator [SEL_8] (rows=3 width=188)
Output:["_col0","_col1"]
- Filter Operator [FIL_26] (rows=3 width=10)
+ Filter Operator [FIL_26] (rows=3 width=188)
predicate:id is not null
- TableScan [TS_6] (rows=3 width=10)
+ TableScan [TS_6] (rows=3 width=188)
default@table2,table2,Tbl:COMPLETE,Col:NONE,Output:["id","val2"]
<-Reducer 2 [SIMPLE_EDGE] llap
SHUFFLE [RS_14]
PartitionCols:_col0
- Merge Join Operator [MERGEJOIN_27] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_27] (rows=5 width=211)
Conds:RS_11._col2=RS_12._col0(Left Semi),Output:["_col0"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_11]
PartitionCols:_col2
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=192)
Output:["_col0","_col2"]
- Filter Operator [FIL_24] (rows=5 width=20)
+ Filter Operator [FIL_24] (rows=5 width=192)
predicate:((val = 't1val01') and dimid is not null and id is not null)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=192)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","dimid"]
<-Map 4 [SIMPLE_EDGE] llap
SHUFFLE [RS_12]
PartitionCols:_col0
- Group By Operator [GBY_10] (rows=5 width=3)
+ Group By Operator [GBY_10] (rows=5 width=4)
Output:["_col0"],keys:_col0
- Select Operator [SEL_5] (rows=5 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0"]
- Filter Operator [FIL_25] (rows=5 width=3)
+ Filter Operator [FIL_25] (rows=5 width=4)
predicate:id is not null
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table2.val2 from table1 left semi join table3 on table1.dimid = table3.id inner join table2 on table1.val = 't1val01' and table1.id = table2.id
@@ -255,27 +255,27 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=2 width=3)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=4)
Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:100, true
- Select Operator [SEL_2] (rows=1 width=20)
+ Select Operator [SEL_2] (rows=1 width=372)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_15] (rows=1 width=20)
+ Filter Operator [FIL_15] (rows=1 width=372)
predicate:false
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=372)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=2 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0","_col1"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=2 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=2 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:(id = 100)
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid <> 100
@@ -303,27 +303,27 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:100, true
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=376)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_15] (rows=5 width=20)
+ Filter Operator [FIL_15] (rows=5 width=376)
predicate:(dimid = 100)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=376)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=2 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0","_col1"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=2 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=2 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:(id = 100)
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid IN (100,200)
@@ -353,27 +353,27 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=2 width=3)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=4)
Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:100, true
- Select Operator [SEL_2] (rows=1 width=20)
+ Select Operator [SEL_2] (rows=1 width=372)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_15] (rows=1 width=20)
+ Filter Operator [FIL_15] (rows=1 width=372)
predicate:false
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=372)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=2 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0","_col1"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=2 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=2 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:(id = 100)
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 200
@@ -401,27 +401,27 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:100, true
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=376)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_15] (rows=5 width=20)
+ Filter Operator [FIL_15] (rows=5 width=376)
predicate:(dimid = 100)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=376)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=2 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0","_col1"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=2 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=2 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:(id = 100)
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100 where table1.dimid = 100
@@ -451,27 +451,27 @@ Stage-0
Stage-1
Reducer 2 llap
File Output Operator [FS_12]
- Merge Join Operator [MERGEJOIN_17] (rows=5 width=22)
+ Merge Join Operator [MERGEJOIN_17] (rows=5 width=413)
Conds:RS_8.100, true=RS_9._col0, _col1(Left Semi),Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] llap
SHUFFLE [RS_8]
PartitionCols:100, true
- Select Operator [SEL_2] (rows=5 width=20)
+ Select Operator [SEL_2] (rows=5 width=376)
Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_15] (rows=5 width=20)
+ Filter Operator [FIL_15] (rows=5 width=376)
predicate:(dimid = 100)
- TableScan [TS_0] (rows=10 width=20)
+ TableScan [TS_0] (rows=10 width=376)
default@table1,table1,Tbl:COMPLETE,Col:NONE,Output:["id","val","val1","dimid"]
<-Map 3 [SIMPLE_EDGE] llap
SHUFFLE [RS_9]
PartitionCols:_col0, _col1
- Group By Operator [GBY_7] (rows=2 width=3)
+ Group By Operator [GBY_7] (rows=5 width=4)
Output:["_col0","_col1"],keys:_col0, _col1
- Select Operator [SEL_5] (rows=2 width=3)
+ Select Operator [SEL_5] (rows=5 width=4)
Output:["_col0","_col1"]
- Filter Operator [FIL_16] (rows=2 width=3)
+ Filter Operator [FIL_16] (rows=5 width=4)
predicate:(id = 100)
- TableScan [TS_3] (rows=5 width=3)
+ TableScan [TS_3] (rows=5 width=4)
default@table3,table3,Tbl:COMPLETE,Col:NONE,Output:["id"]
PREHOOK: query: select table1.id, table1.val, table1.val1 from table1 left semi join table3 on table1.dimid = table3.id and table3.id = 100