You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/11/19 16:54:21 UTC
svn commit: r1640577 [25/30] - in /hive/trunk:
accumulo-handler/src/test/results/positive/
common/src/java/org/apache/hadoop/hive/conf/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/h...
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out Wed Nov 19 15:54:15 2014
@@ -1513,18 +1513,14 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
+ File Output Operator
+ compressed: false
Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 2221 Data size: 53305 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
- name: default.over1k_part2
+ 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
+ name: default.over1k_part2
Stage: Stage-2
Dependency Collection
@@ -1593,24 +1589,20 @@ STAGE PLANS:
keys: KEY._col0 (type: smallint), KEY._col1 (type: int), KEY._col2 (type: bigint), KEY._col3 (type: float), KEY._col4 (type: tinyint)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col4 (type: tinyint)
- sort order: +
- Map-reduce partition columns: _col4 (type: tinyint)
- Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
+ Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col4 (type: tinyint)
+ sort order: +
+ Map-reduce partition columns: _col4 (type: tinyint)
+ Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: smallint), _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: tinyint)
Reducer 3
Reduce Operator Tree:
Extract
- Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 2221 Data size: 53305 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4442 Data size: 106611 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization2.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization2.q.out Wed Nov 19 15:54:15 2014
@@ -93,20 +93,16 @@ STAGE PLANS:
Filter Operator
predicate: ((ss_sold_date_sk >= 2452617) and (ss_sold_date_sk <= 2452638)) (type: boolean)
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- outputColumnNames: ss_sold_date_sk, ss_net_paid_inc_tax, ss_net_profit
+ Group By Operator
+ keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
+ sort order: +++
+ Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
- sort order: +++
- Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
Group By Operator
@@ -580,20 +576,16 @@ STAGE PLANS:
Filter Operator
predicate: ((ss_sold_date_sk >= 2452617) and (ss_sold_date_sk <= 2452638)) (type: boolean)
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- outputColumnNames: ss_sold_date_sk, ss_net_paid_inc_tax, ss_net_profit
+ Group By Operator
+ keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
+ sort order: +++
+ Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
- sort order: +++
- Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 5 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
Group By Operator
@@ -1121,20 +1113,16 @@ STAGE PLANS:
Filter Operator
predicate: ((ss_sold_date_sk >= 2452617) and (ss_sold_date_sk <= 2452638)) (type: boolean)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- outputColumnNames: ss_sold_date_sk, ss_net_paid_inc_tax, ss_net_profit
+ Group By Operator
+ keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- keys: ss_sold_date_sk (type: int), ss_net_paid_inc_tax (type: float), ss_net_profit (type: float)
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
+ sort order: +++
+ Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: int), _col1 (type: float), _col2 (type: float)
- sort order: +++
- Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/having.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/having.q.out Wed Nov 19 15:54:15 2014
@@ -106,22 +106,18 @@ STAGE PLANS:
Filter Operator
predicate: (key <> 302) (type: boolean)
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: max(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: max(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
+ value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
Group By Operator
@@ -759,22 +755,18 @@ STAGE PLANS:
Filter Operator
predicate: (key > 300) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: max(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: max(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 166 Data size: 1763 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: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
+ value expressions: _col1 (type: string)
Reducer 2
Reduce Operator Tree:
Group By Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out Wed Nov 19 15:54:15 2014
@@ -69,14 +69,10 @@ STAGE PLANS:
1 {VALUE._col0} {VALUE._col1}
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ Reduce Output Operator
+ key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ sort order: ++++
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
- sort order: ++++
- Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out Wed Nov 19 15:54:15 2014
@@ -727,23 +727,19 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: double)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: double)
- sort order: +
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- TopN Hash Memory Usage: 0.3
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: double)
+ sort order: +
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ TopN Hash Memory Usage: 0.3
+ value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: double)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 20
Statistics: Num rows: 20 Data size: 200 Basic stats: COMPLETE Column stats: NONE
@@ -871,22 +867,18 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 2
- Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: _col0 is not null (type: boolean)
+ Limit
+ Number of rows: 2
+ Statistics: Num rows: 2 Data size: 20 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: _col0 is not null (type: boolean)
+ Statistics: Num rows: 1 Data size: 10 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: 10 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: 10 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Merge Join Operator
@@ -919,18 +911,14 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Limit
- Number of rows: 3
+ Limit
+ Number of rows: 3
+ Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE
- TopN Hash Memory Usage: 0.3
- value expressions: _col0 (type: string), _col1 (type: bigint)
+ TopN Hash Memory Usage: 0.3
+ value expressions: _col0 (type: string), _col1 (type: bigint)
Reducer 6
Reduce Operator Tree:
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out Wed Nov 19 15:54:15 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out Wed Nov 19 15:54:15 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out Wed Nov 19 15:54:15 2014
@@ -44,25 +44,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -447,21 +443,17 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col5, _col6
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col5 (type: string), _col6 (type: string)
- outputColumnNames: _col5, _col6
+ Group By Operator
+ aggregations: count(DISTINCT _col6)
+ keys: _col5 (type: string), _col6 (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(DISTINCT _col6)
- keys: _col5 (type: string), _col6 (type: string)
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: string), _col1 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 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: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -469,25 +461,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -870,21 +858,17 @@ STAGE PLANS:
input vertices:
1 Map 1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col5 (type: string), _col6 (type: string)
- outputColumnNames: _col5, _col6
+ Group By Operator
+ aggregations: count(DISTINCT _col6)
+ keys: _col5 (type: string), _col6 (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(DISTINCT _col6)
- keys: _col5 (type: string), _col6 (type: string)
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: string), _col1 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 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: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -892,25 +876,21 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 137 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1299,22 +1279,18 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: count(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 250 Data size: 2656 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: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Map 6
Map Operator Tree:
TableScan
@@ -1323,22 +1299,18 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: count(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 250 Data size: 2656 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: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Map 9
Map Operator Tree:
TableScan
@@ -1347,22 +1319,18 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: count(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 250 Data size: 2656 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: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reducer 10
Reduce Operator Tree:
Group By Operator
@@ -1374,15 +1342,11 @@ STAGE PLANS:
Filter Operator
predicate: (_col1 > 1) (type: boolean)
Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ value expressions: _col0 (type: string)
Reducer 11
Reduce Operator Tree:
Select Operator
@@ -1402,27 +1366,23 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string)
Reducer 3
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 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: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reducer 4
Reduce Operator Tree:
@@ -1435,25 +1395,21 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
2 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: bigint), _col4 (type: string), _col5 (type: bigint)
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: string), _col3 (type: bigint), _col4 (type: string), _col5 (type: bigint)
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: bigint), _col2 (type: string), _col3 (type: bigint), _col4 (type: string), _col5 (type: bigint)
Reducer 5
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint), VALUE._col1 (type: string), VALUE._col2 (type: bigint), VALUE._col3 (type: string), VALUE._col4 (type: bigint)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1465,27 +1421,23 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: bigint)
- sort order: +
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col1 (type: bigint)
+ sort order: +
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string)
Reducer 8
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 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: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Stage: Stage-0
@@ -1686,8 +1638,7 @@ STAGE PLANS:
Stage: Stage-1
Tez
Edges:
- Map 1 <- Reducer 3 (BROADCAST_EDGE)
- Reducer 3 <- Map 2 (SIMPLE_EDGE)
+ Reducer 3 <- Map 1 (BROADCAST_EDGE), Map 2 (SIMPLE_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
@@ -1698,30 +1649,12 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- condition expressions:
- 0 {_col0} {_col1}
- 1 {key} {value}
- keys:
- 0 _col0 (type: string)
- 1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- input vertices:
- 0 Reducer 3
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 275 Data size: 2921 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
+ Reduce Output Operator
+ key expressions: key (type: string)
+ sort order: +
+ Map-reduce partition columns: key (type: string)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
Map 2
Map Operator Tree:
TableScan
@@ -1730,22 +1663,18 @@ STAGE PLANS:
Filter Operator
predicate: key is not null (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: key, value
+ Group By Operator
+ aggregations: count(value)
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: count(value)
- keys: key (type: string)
- mode: hash
- outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 250 Data size: 2656 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: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -1753,17 +1682,31 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 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: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {_col0} {_col1}
+ 1 {key} {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ input vertices:
+ 1 Map 1
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 275 Data size: 2921 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
Stage: Stage-0
Fetch Operator
@@ -1785,503 +1728,503 @@ FROM
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-238 2 238 val_238
-86 1 86 val_86
-311 3 311 val_311
-27 1 27 val_27
-165 2 165 val_165
-409 3 409 val_409
-255 2 255 val_255
-278 2 278 val_278
-98 2 98 val_98
-484 1 484 val_484
-265 2 265 val_265
-193 3 193 val_193
-401 5 401 val_401
-150 1 150 val_150
-273 3 273 val_273
-224 2 224 val_224
-369 3 369 val_369
-66 1 66 val_66
+0 3 0 val_0
+0 3 0 val_0
+0 3 0 val_0
+10 1 10 val_10
+100 2 100 val_100
+100 2 100 val_100
+103 2 103 val_103
+103 2 103 val_103
+104 2 104 val_104
+104 2 104 val_104
+105 1 105 val_105
+11 1 11 val_11
+111 1 111 val_111
+113 2 113 val_113
+113 2 113 val_113
+114 1 114 val_114
+116 1 116 val_116
+118 2 118 val_118
+118 2 118 val_118
+119 3 119 val_119
+119 3 119 val_119
+119 3 119 val_119
+12 2 12 val_12
+12 2 12 val_12
+120 2 120 val_120
+120 2 120 val_120
+125 2 125 val_125
+125 2 125 val_125
+126 1 126 val_126
128 3 128 val_128
-213 2 213 val_213
-146 2 146 val_146
-406 4 406 val_406
-429 2 429 val_429
-374 1 374 val_374
-152 2 152 val_152
-469 5 469 val_469
+128 3 128 val_128
+128 3 128 val_128
+129 2 129 val_129
+129 2 129 val_129
+131 1 131 val_131
+133 1 133 val_133
+134 2 134 val_134
+134 2 134 val_134
+136 1 136 val_136
+137 2 137 val_137
+137 2 137 val_137
+138 4 138 val_138
+138 4 138 val_138
+138 4 138 val_138
+138 4 138 val_138
+143 1 143 val_143
145 1 145 val_145
-495 1 495 val_495
-37 2 37 val_37
-327 3 327 val_327
-281 2 281 val_281
-277 4 277 val_277
-209 2 209 val_209
+146 2 146 val_146
+146 2 146 val_146
+149 2 149 val_149
+149 2 149 val_149
15 2 15 val_15
-82 1 82 val_82
-403 3 403 val_403
-166 1 166 val_166
-417 3 417 val_417
-430 3 430 val_430
-252 1 252 val_252
-292 1 292 val_292
-219 2 219 val_219
-287 1 287 val_287
+15 2 15 val_15
+150 1 150 val_150
+152 2 152 val_152
+152 2 152 val_152
153 1 153 val_153
-193 3 193 val_193
-338 1 338 val_338
-446 1 446 val_446
-459 2 459 val_459
-394 1 394 val_394
-237 2 237 val_237
-482 1 482 val_482
+155 1 155 val_155
+156 1 156 val_156
+157 1 157 val_157
+158 1 158 val_158
+160 1 160 val_160
+162 1 162 val_162
+163 1 163 val_163
+164 2 164 val_164
+164 2 164 val_164
+165 2 165 val_165
+165 2 165 val_165
+166 1 166 val_166
+167 3 167 val_167
+167 3 167 val_167
+167 3 167 val_167
+168 1 168 val_168
+169 4 169 val_169
+169 4 169 val_169
+169 4 169 val_169
+169 4 169 val_169
+17 1 17 val_17
+170 1 170 val_170
+172 2 172 val_172
+172 2 172 val_172
174 2 174 val_174
-413 2 413 val_413
-494 1 494 val_494
-207 2 207 val_207
-199 3 199 val_199
-466 3 466 val_466
-208 3 208 val_208
174 2 174 val_174
-399 2 399 val_399
-396 3 396 val_396
-247 1 247 val_247
-417 3 417 val_417
-489 4 489 val_489
-162 1 162 val_162
-377 1 377 val_377
-397 2 397 val_397
-309 2 309 val_309
-365 1 365 val_365
-266 1 266 val_266
-439 2 439 val_439
-342 2 342 val_342
-367 2 367 val_367
-325 2 325 val_325
-167 3 167 val_167
-195 2 195 val_195
-475 1 475 val_475
-17 1 17 val_17
-113 2 113 val_113
-155 1 155 val_155
-203 2 203 val_203
-339 1 339 val_339
-0 3 0 val_0
-455 1 455 val_455
-128 3 128 val_128
-311 3 311 val_311
-316 3 316 val_316
-57 1 57 val_57
-302 1 302 val_302
-205 2 205 val_205
-149 2 149 val_149
-438 3 438 val_438
-345 1 345 val_345
-129 2 129 val_129
-170 1 170 val_170
-20 1 20 val_20
-489 4 489 val_489
-157 1 157 val_157
-378 1 378 val_378
-221 2 221 val_221
-92 1 92 val_92
-111 1 111 val_111
-47 1 47 val_47
-72 2 72 val_72
-4 1 4 val_4
-280 2 280 val_280
-35 3 35 val_35
-427 1 427 val_427
-277 4 277 val_277
-208 3 208 val_208
-356 1 356 val_356
-399 2 399 val_399
-169 4 169 val_169
-382 2 382 val_382
-498 3 498 val_498
-125 2 125 val_125
-386 1 386 val_386
-437 1 437 val_437
-469 5 469 val_469
-192 1 192 val_192
-286 1 286 val_286
-187 3 187 val_187
+175 2 175 val_175
+175 2 175 val_175
176 2 176 val_176
-54 1 54 val_54
-459 2 459 val_459
-51 2 51 val_51
-138 4 138 val_138
-103 2 103 val_103
-239 2 239 val_239
-213 2 213 val_213
-216 2 216 val_216
-430 3 430 val_430
-278 2 278 val_278
176 2 176 val_176
-289 1 289 val_289
-221 2 221 val_221
-65 1 65 val_65
-318 3 318 val_318
-332 1 332 val_332
-311 3 311 val_311
-275 1 275 val_275
-137 2 137 val_137
-241 1 241 val_241
-83 2 83 val_83
-333 2 333 val_333
+177 1 177 val_177
+178 1 178 val_178
+179 2 179 val_179
+179 2 179 val_179
+18 2 18 val_18
+18 2 18 val_18
180 1 180 val_180
-284 1 284 val_284
-12 2 12 val_12
-230 5 230 val_230
181 1 181 val_181
-67 2 67 val_67
-260 1 260 val_260
-404 2 404 val_404
-384 3 384 val_384
-489 4 489 val_489
-353 2 353 val_353
-373 1 373 val_373
-272 2 272 val_272
-138 4 138 val_138
-217 2 217 val_217
-84 2 84 val_84
-348 5 348 val_348
-466 3 466 val_466
-58 2 58 val_58
-8 1 8 val_8
-411 1 411 val_411
-230 5 230 val_230
-208 3 208 val_208
-348 5 348 val_348
-24 2 24 val_24
-463 2 463 val_463
-431 3 431 val_431
-179 2 179 val_179
-172 2 172 val_172
-42 2 42 val_42
-129 2 129 val_129
-158 1 158 val_158
-119 3 119 val_119
-496 1 496 val_496
-0 3 0 val_0
-322 2 322 val_322
-197 2 197 val_197
-468 4 468 val_468
-393 1 393 val_393
-454 3 454 val_454
-100 2 100 val_100
-298 3 298 val_298
-199 3 199 val_199
-191 2 191 val_191
-418 1 418 val_418
-96 1 96 val_96
-26 2 26 val_26
-165 2 165 val_165
-327 3 327 val_327
-230 5 230 val_230
-205 2 205 val_205
-120 2 120 val_120
-131 1 131 val_131
-51 2 51 val_51
-404 2 404 val_404
-43 1 43 val_43
-436 1 436 val_436
-156 1 156 val_156
-469 5 469 val_469
-468 4 468 val_468
-308 1 308 val_308
-95 2 95 val_95
-196 1 196 val_196
-288 2 288 val_288
-481 1 481 val_481
-457 1 457 val_457
-98 2 98 val_98
-282 2 282 val_282
-197 2 197 val_197
+183 1 183 val_183
+186 1 186 val_186
187 3 187 val_187
-318 3 318 val_318
-318 3 318 val_318
-409 3 409 val_409
-470 1 470 val_470
-137 2 137 val_137
-369 3 369 val_369
-316 3 316 val_316
-169 4 169 val_169
-413 2 413 val_413
-85 1 85 val_85
-77 1 77 val_77
-0 3 0 val_0
-490 1 490 val_490
-87 1 87 val_87
-364 1 364 val_364
-179 2 179 val_179
-118 2 118 val_118
-134 2 134 val_134
-395 2 395 val_395
-282 2 282 val_282
-138 4 138 val_138
-238 2 238 val_238
-419 1 419 val_419
-15 2 15 val_15
-118 2 118 val_118
-72 2 72 val_72
-90 3 90 val_90
-307 2 307 val_307
+187 3 187 val_187
+187 3 187 val_187
+189 1 189 val_189
19 1 19 val_19
-435 1 435 val_435
-10 1 10 val_10
-277 4 277 val_277
-273 3 273 val_273
-306 1 306 val_306
-224 2 224 val_224
-309 2 309 val_309
-389 1 389 val_389
-327 3 327 val_327
-242 2 242 val_242
-369 3 369 val_369
-392 1 392 val_392
-272 2 272 val_272
-331 2 331 val_331
-401 5 401 val_401
-242 2 242 val_242
-452 1 452 val_452
-177 1 177 val_177
-226 1 226 val_226
-5 3 5 val_5
-497 1 497 val_497
-402 1 402 val_402
-396 3 396 val_396
-317 2 317 val_317
-395 2 395 val_395
-58 2 58 val_58
-35 3 35 val_35
-336 1 336 val_336
-95 2 95 val_95
-11 1 11 val_11
-168 1 168 val_168
-34 1 34 val_34
-229 2 229 val_229
-233 2 233 val_233
-143 1 143 val_143
-472 1 472 val_472
-322 2 322 val_322
-498 3 498 val_498
-160 1 160 val_160
+190 1 190 val_190
+191 2 191 val_191
+191 2 191 val_191
+192 1 192 val_192
+193 3 193 val_193
+193 3 193 val_193
+193 3 193 val_193
+194 1 194 val_194
195 2 195 val_195
-42 2 42 val_42
-321 2 321 val_321
-430 3 430 val_430
-119 3 119 val_119
-489 4 489 val_489
-458 2 458 val_458
-78 1 78 val_78
-76 2 76 val_76
-41 1 41 val_41
-223 2 223 val_223
-492 2 492 val_492
-149 2 149 val_149
-449 1 449 val_449
-218 1 218 val_218
-228 1 228 val_228
-138 4 138 val_138
-453 1 453 val_453
-30 1 30 val_30
+195 2 195 val_195
+196 1 196 val_196
+197 2 197 val_197
+197 2 197 val_197
+199 3 199 val_199
+199 3 199 val_199
+199 3 199 val_199
+2 1 2 val_2
+20 1 20 val_20
+200 2 200 val_200
+200 2 200 val_200
+201 1 201 val_201
+202 1 202 val_202
+203 2 203 val_203
+203 2 203 val_203
+205 2 205 val_205
+205 2 205 val_205
+207 2 207 val_207
+207 2 207 val_207
+208 3 208 val_208
+208 3 208 val_208
+208 3 208 val_208
+209 2 209 val_209
209 2 209 val_209
-64 1 64 val_64
-468 4 468 val_468
-76 2 76 val_76
-74 1 74 val_74
-342 2 342 val_342
-69 1 69 val_69
-230 5 230 val_230
-33 1 33 val_33
-368 1 368 val_368
-103 2 103 val_103
-296 1 296 val_296
-113 2 113 val_113
+213 2 213 val_213
+213 2 213 val_213
+214 1 214 val_214
216 2 216 val_216
-367 2 367 val_367
-344 2 344 val_344
-167 3 167 val_167
-274 1 274 val_274
+216 2 216 val_216
+217 2 217 val_217
+217 2 217 val_217
+218 1 218 val_218
219 2 219 val_219
-239 2 239 val_239
-485 1 485 val_485
-116 1 116 val_116
+219 2 219 val_219
+221 2 221 val_221
+221 2 221 val_221
+222 1 222 val_222
223 2 223 val_223
+223 2 223 val_223
+224 2 224 val_224
+224 2 224 val_224
+226 1 226 val_226
+228 1 228 val_228
+229 2 229 val_229
+229 2 229 val_229
+230 5 230 val_230
+230 5 230 val_230
+230 5 230 val_230
+230 5 230 val_230
+230 5 230 val_230
+233 2 233 val_233
+233 2 233 val_233
+235 1 235 val_235
+237 2 237 val_237
+237 2 237 val_237
+238 2 238 val_238
+238 2 238 val_238
+239 2 239 val_239
+239 2 239 val_239
+24 2 24 val_24
+24 2 24 val_24
+241 1 241 val_241
+242 2 242 val_242
+242 2 242 val_242
+244 1 244 val_244
+247 1 247 val_247
+248 1 248 val_248
+249 1 249 val_249
+252 1 252 val_252
+255 2 255 val_255
+255 2 255 val_255
+256 2 256 val_256
256 2 256 val_256
+257 1 257 val_257
+258 1 258 val_258
+26 2 26 val_26
+26 2 26 val_26
+260 1 260 val_260
+262 1 262 val_262
263 1 263 val_263
-70 3 70 val_70
-487 1 487 val_487
-480 3 480 val_480
-401 5 401 val_401
-288 2 288 val_288
-191 2 191 val_191
-5 3 5 val_5
-244 1 244 val_244
-438 3 438 val_438
-128 3 128 val_128
-467 1 467 val_467
-432 1 432 val_432
-202 1 202 val_202
-316 3 316 val_316
-229 2 229 val_229
-469 5 469 val_469
-463 2 463 val_463
+265 2 265 val_265
+265 2 265 val_265
+266 1 266 val_266
+27 1 27 val_27
+272 2 272 val_272
+272 2 272 val_272
+273 3 273 val_273
+273 3 273 val_273
+273 3 273 val_273
+274 1 274 val_274
+275 1 275 val_275
+277 4 277 val_277
+277 4 277 val_277
+277 4 277 val_277
+277 4 277 val_277
+278 2 278 val_278
+278 2 278 val_278
+28 1 28 val_28
280 2 280 val_280
-2 1 2 val_2
-35 3 35 val_35
+280 2 280 val_280
+281 2 281 val_281
+281 2 281 val_281
+282 2 282 val_282
+282 2 282 val_282
283 1 283 val_283
-331 2 331 val_331
-235 1 235 val_235
-80 1 80 val_80
-44 1 44 val_44
-193 3 193 val_193
+284 1 284 val_284
+285 1 285 val_285
+286 1 286 val_286
+287 1 287 val_287
+288 2 288 val_288
+288 2 288 val_288
+289 1 289 val_289
+291 1 291 val_291
+292 1 292 val_292
+296 1 296 val_296
+298 3 298 val_298
+298 3 298 val_298
+298 3 298 val_298
+30 1 30 val_30
+302 1 302 val_302
+305 1 305 val_305
+306 1 306 val_306
+307 2 307 val_307
+307 2 307 val_307
+308 1 308 val_308
+309 2 309 val_309
+309 2 309 val_309
+310 1 310 val_310
+311 3 311 val_311
+311 3 311 val_311
+311 3 311 val_311
+315 1 315 val_315
+316 3 316 val_316
+316 3 316 val_316
+316 3 316 val_316
+317 2 317 val_317
+317 2 317 val_317
+318 3 318 val_318
+318 3 318 val_318
+318 3 318 val_318
321 2 321 val_321
+321 2 321 val_321
+322 2 322 val_322
+322 2 322 val_322
+323 1 323 val_323
+325 2 325 val_325
+325 2 325 val_325
+327 3 327 val_327
+327 3 327 val_327
+327 3 327 val_327
+33 1 33 val_33
+331 2 331 val_331
+331 2 331 val_331
+332 1 332 val_332
+333 2 333 val_333
+333 2 333 val_333
335 1 335 val_335
-104 2 104 val_104
-466 3 466 val_466
+336 1 336 val_336
+338 1 338 val_338
+339 1 339 val_339
+34 1 34 val_34
+341 1 341 val_341
+342 2 342 val_342
+342 2 342 val_342
+344 2 344 val_344
+344 2 344 val_344
+345 1 345 val_345
+348 5 348 val_348
+348 5 348 val_348
+348 5 348 val_348
+348 5 348 val_348
+348 5 348 val_348
+35 3 35 val_35
+35 3 35 val_35
+35 3 35 val_35
+351 1 351 val_351
+353 2 353 val_353
+353 2 353 val_353
+356 1 356 val_356
+360 1 360 val_360
+362 1 362 val_362
+364 1 364 val_364
+365 1 365 val_365
366 1 366 val_366
-175 2 175 val_175
-403 3 403 val_403
-483 1 483 val_483
-53 1 53 val_53
-105 1 105 val_105
-257 1 257 val_257
-406 4 406 val_406
-409 3 409 val_409
-190 1 190 val_190
-406 4 406 val_406
+367 2 367 val_367
+367 2 367 val_367
+368 1 368 val_368
+369 3 369 val_369
+369 3 369 val_369
+369 3 369 val_369
+37 2 37 val_37
+37 2 37 val_37
+373 1 373 val_373
+374 1 374 val_374
+375 1 375 val_375
+377 1 377 val_377
+378 1 378 val_378
+379 1 379 val_379
+382 2 382 val_382
+382 2 382 val_382
+384 3 384 val_384
+384 3 384 val_384
+384 3 384 val_384
+386 1 386 val_386
+389 1 389 val_389
+392 1 392 val_392
+393 1 393 val_393
+394 1 394 val_394
+395 2 395 val_395
+395 2 395 val_395
+396 3 396 val_396
+396 3 396 val_396
+396 3 396 val_396
+397 2 397 val_397
+397 2 397 val_397
+399 2 399 val_399
+399 2 399 val_399
+4 1 4 val_4
+400 1 400 val_400
401 5 401 val_401
-114 1 114 val_114
-258 1 258 val_258
-90 3 90 val_90
-203 2 203 val_203
-262 1 262 val_262
-348 5 348 val_348
+401 5 401 val_401
+401 5 401 val_401
+401 5 401 val_401
+401 5 401 val_401
+402 1 402 val_402
+403 3 403 val_403
+403 3 403 val_403
+403 3 403 val_403
+404 2 404 val_404
+404 2 404 val_404
+406 4 406 val_406
+406 4 406 val_406
+406 4 406 val_406
+406 4 406 val_406
+407 1 407 val_407
+409 3 409 val_409
+409 3 409 val_409
+409 3 409 val_409
+41 1 41 val_41
+411 1 411 val_411
+413 2 413 val_413
+413 2 413 val_413
+414 2 414 val_414
+414 2 414 val_414
+417 3 417 val_417
+417 3 417 val_417
+417 3 417 val_417
+418 1 418 val_418
+419 1 419 val_419
+42 2 42 val_42
+42 2 42 val_42
+421 1 421 val_421
424 2 424 val_424
-12 2 12 val_12
-396 3 396 val_396
-201 1 201 val_201
-217 2 217 val_217
-164 2 164 val_164
+424 2 424 val_424
+427 1 427 val_427
+429 2 429 val_429
+429 2 429 val_429
+43 1 43 val_43
+430 3 430 val_430
+430 3 430 val_430
+430 3 430 val_430
431 3 431 val_431
-454 3 454 val_454
-478 2 478 val_478
-298 3 298 val_298
-125 2 125 val_125
431 3 431 val_431
-164 2 164 val_164
-424 2 424 val_424
-187 3 187 val_187
-382 2 382 val_382
-5 3 5 val_5
-70 3 70 val_70
-397 2 397 val_397
-480 3 480 val_480
-291 1 291 val_291
-24 2 24 val_24
-351 1 351 val_351
-255 2 255 val_255
-104 2 104 val_104
-70 3 70 val_70
-163 1 163 val_163
+431 3 431 val_431
+432 1 432 val_432
+435 1 435 val_435
+436 1 436 val_436
+437 1 437 val_437
+438 3 438 val_438
+438 3 438 val_438
438 3 438 val_438
-119 3 119 val_119
-414 2 414 val_414
-200 2 200 val_200
-491 1 491 val_491
-237 2 237 val_237
439 2 439 val_439
-360 1 360 val_360
-248 1 248 val_248
-479 1 479 val_479
-305 1 305 val_305
-417 3 417 val_417
-199 3 199 val_199
-444 1 444 val_444
-120 2 120 val_120
-429 2 429 val_429
-169 4 169 val_169
+439 2 439 val_439
+44 1 44 val_44
443 1 443 val_443
-323 1 323 val_323
-325 2 325 val_325
-277 4 277 val_277
-230 5 230 val_230
-478 2 478 val_478
-178 1 178 val_178
-468 4 468 val_468
-310 1 310 val_310
-317 2 317 val_317
-333 2 333 val_333
-493 1 493 val_493
+444 1 444 val_444
+446 1 446 val_446
+448 1 448 val_448
+449 1 449 val_449
+452 1 452 val_452
+453 1 453 val_453
+454 3 454 val_454
+454 3 454 val_454
+454 3 454 val_454
+455 1 455 val_455
+457 1 457 val_457
+458 2 458 val_458
+458 2 458 val_458
+459 2 459 val_459
+459 2 459 val_459
460 1 460 val_460
-207 2 207 val_207
-249 1 249 val_249
-265 2 265 val_265
-480 3 480 val_480
-83 2 83 val_83
-136 1 136 val_136
-353 2 353 val_353
-172 2 172 val_172
-214 1 214 val_214
462 2 462 val_462
-233 2 233 val_233
-406 4 406 val_406
-133 1 133 val_133
-175 2 175 val_175
-189 1 189 val_189
-454 3 454 val_454
-375 1 375 val_375
-401 5 401 val_401
-421 1 421 val_421
-407 1 407 val_407
-384 3 384 val_384
-256 2 256 val_256
-26 2 26 val_26
-134 2 134 val_134
-67 2 67 val_67
-384 3 384 val_384
-379 1 379 val_379
-18 2 18 val_18
462 2 462 val_462
+463 2 463 val_463
+463 2 463 val_463
+466 3 466 val_466
+466 3 466 val_466
+466 3 466 val_466
+467 1 467 val_467
+468 4 468 val_468
+468 4 468 val_468
+468 4 468 val_468
+468 4 468 val_468
+469 5 469 val_469
+469 5 469 val_469
+469 5 469 val_469
+469 5 469 val_469
+469 5 469 val_469
+47 1 47 val_47
+470 1 470 val_470
+472 1 472 val_472
+475 1 475 val_475
+477 1 477 val_477
+478 2 478 val_478
+478 2 478 val_478
+479 1 479 val_479
+480 3 480 val_480
+480 3 480 val_480
+480 3 480 val_480
+481 1 481 val_481
+482 1 482 val_482
+483 1 483 val_483
+484 1 484 val_484
+485 1 485 val_485
+487 1 487 val_487
+489 4 489 val_489
+489 4 489 val_489
+489 4 489 val_489
+489 4 489 val_489
+490 1 490 val_490
+491 1 491 val_491
492 2 492 val_492
-100 2 100 val_100
-298 3 298 val_298
-9 1 9 val_9
-341 1 341 val_341
+492 2 492 val_492
+493 1 493 val_493
+494 1 494 val_494
+495 1 495 val_495
+496 1 496 val_496
+497 1 497 val_497
498 3 498 val_498
-146 2 146 val_146
-458 2 458 val_458
-362 1 362 val_362
-186 1 186 val_186
-285 1 285 val_285
-348 5 348 val_348
-167 3 167 val_167
-18 2 18 val_18
-273 3 273 val_273
-183 1 183 val_183
-281 2 281 val_281
-344 2 344 val_344
-97 2 97 val_97
-469 5 469 val_469
-315 1 315 val_315
+498 3 498 val_498
+498 3 498 val_498
+5 3 5 val_5
+5 3 5 val_5
+5 3 5 val_5
+51 2 51 val_51
+51 2 51 val_51
+53 1 53 val_53
+54 1 54 val_54
+57 1 57 val_57
+58 2 58 val_58
+58 2 58 val_58
+64 1 64 val_64
+65 1 65 val_65
+66 1 66 val_66
+67 2 67 val_67
+67 2 67 val_67
+69 1 69 val_69
+70 3 70 val_70
+70 3 70 val_70
+70 3 70 val_70
+72 2 72 val_72
+72 2 72 val_72
+74 1 74 val_74
+76 2 76 val_76
+76 2 76 val_76
+77 1 77 val_77
+78 1 78 val_78
+8 1 8 val_8
+80 1 80 val_80
+82 1 82 val_82
+83 2 83 val_83
+83 2 83 val_83
84 2 84 val_84
-28 1 28 val_28
-37 2 37 val_37
-448 1 448 val_448
-152 2 152 val_152
-348 5 348 val_348
-307 2 307 val_307
-194 1 194 val_194
-414 2 414 val_414
-477 1 477 val_477
-222 1 222 val_222
-126 1 126 val_126
+84 2 84 val_84
+85 1 85 val_85
+86 1 86 val_86
+87 1 87 val_87
+9 1 9 val_9
90 3 90 val_90
-169 4 169 val_169
-403 3 403 val_403
-400 1 400 val_400
-200 2 200 val_200
+90 3 90 val_90
+90 3 90 val_90
+92 1 92 val_92
+95 2 95 val_95
+95 2 95 val_95
+96 1 96 val_96
+97 2 97 val_97
97 2 97 val_97
+98 2 98 val_98
+98 2 98 val_98
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out Wed Nov 19 15:54:15 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/parallel.q.out Wed Nov 19 15:54:15 2014
@@ -69,54 +69,42 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: string), _col1 (type: string)
- sort order: ++
- Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string), _col1 (type: string)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
Forward
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 125 Data size: 1328 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
- name: default.src_a
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 250 Data size: 2656 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
+ name: default.src_a
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: complete
outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 125 Data size: 1328 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
- name: default.src_b
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 250 Data size: 2656 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
+ name: default.src_b
Stage: Stage-3
Dependency Collection
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/script_pipe.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/script_pipe.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/script_pipe.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/script_pipe.q.out Wed Nov 19 15:54:15 2014
@@ -40,24 +40,20 @@ STAGE PLANS:
Limit
Number of rows: 1
Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
+ Transform Operator
+ command: true
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
- Transform Operator
- command: true
- output info:
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 10 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
- Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 10 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
Stage: Stage-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/skewjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/skewjoin.q.out?rev=1640577&r1=1640576&r2=1640577&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/skewjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/skewjoin.q.out Wed Nov 19 15:54:15 2014
@@ -496,19 +496,15 @@ STAGE PLANS:
1 {VALUE._col0}
outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
- outputColumnNames: _col0, _col1, _col5
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col5))
- mode: hash
- outputColumnNames: _col0, _col1, _col2
+ Group By Operator
+ aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col5))
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint)
+ value expressions: _col0 (type: bigint), _col1 (type: bigint), _col2 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -616,19 +612,15 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col2, _col3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col2, _col3
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col2)), sum(hash(_col3))
- mode: hash
- outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations: sum(hash(_col2)), sum(hash(_col3))
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: bigint)
+ value expressions: _col0 (type: bigint), _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -744,19 +736,15 @@ STAGE PLANS:
1 {KEY.reducesinkkey0} {VALUE._col0}
outputColumnNames: _col2, _col3
Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col2 (type: string), _col3 (type: string)
- outputColumnNames: _col2, _col3
- Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col2)), sum(hash(_col3))
- mode: hash
- outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations: sum(hash(_col2)), sum(hash(_col3))
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: bigint)
+ value expressions: _col0 (type: bigint), _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -899,19 +887,15 @@ STAGE PLANS:
2
outputColumnNames: _col0, _col3
Statistics: Num rows: 121 Data size: 1284 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col3
- Statistics: Num rows: 121 Data size: 1284 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col0)), sum(hash(_col3))
- mode: hash
- outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations: sum(hash(_col0)), sum(hash(_col3))
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: bigint)
+ value expressions: _col0 (type: bigint), _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator
@@ -1012,19 +996,15 @@ STAGE PLANS:
1 {VALUE._col1}
outputColumnNames: _col0, _col6
Statistics: Num rows: 0 Data size: 33 Basic stats: PARTIAL Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col6 (type: string)
- outputColumnNames: _col0, _col6
- Statistics: Num rows: 0 Data size: 33 Basic stats: PARTIAL Column stats: NONE
- Group By Operator
- aggregations: sum(hash(_col0)), sum(hash(_col6))
- mode: hash
- outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations: sum(hash(_col0)), sum(hash(_col6))
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: bigint), _col1 (type: bigint)
+ value expressions: _col0 (type: bigint), _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
Group By Operator