You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/11/23 06:59:26 UTC
svn commit: r1641162 [21/24] - in /hive/trunk:
hbase-handler/src/test/results/positive/
metastore/src/java/org/apache/hadoop/hive/metastore/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/results/clientnegative/ ql/src/test/results/clientposi...
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out Sun Nov 23 05:59:20 2014
@@ -30,26 +30,12 @@ STAGE PLANS:
Stage: Stage-1
Tez
Edges:
- Reducer 3 <- Map 1 (BROADCAST_EDGE), Map 2 (SIMPLE_EDGE), Map 4 (BROADCAST_EDGE)
+ Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
Map Operator Tree:
TableScan
- alias: li
- Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: ((l_partkey is not null and l_orderkey is not null) and (l_linenumber = 1)) (type: boolean)
- Statistics: Num rows: 12 Data size: 1439 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: l_partkey (type: int)
- sort order: +
- Map-reduce partition columns: l_partkey (type: int)
- Statistics: Num rows: 12 Data size: 1439 Basic stats: COMPLETE Column stats: NONE
- value expressions: l_orderkey (type: int), l_suppkey (type: int)
- Map 2
- Map Operator Tree:
- TableScan
alias: lineitem
Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -65,6 +51,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: li
+ Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((l_partkey is not null and l_orderkey is not null) and (l_linenumber = 1)) (type: boolean)
+ Statistics: Num rows: 12 Data size: 1439 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: l_partkey (type: int)
+ sort order: +
+ Map-reduce partition columns: l_partkey (type: int)
+ Statistics: Num rows: 12 Data size: 1439 Basic stats: COMPLETE Column stats: NONE
+ value expressions: l_orderkey (type: int), l_suppkey (type: int)
Map 4
Map Operator Tree:
TableScan
@@ -87,7 +87,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 25 Data size: 2999 Basic stats: COMPLETE Column stats: NONE
- Reducer 3
+ Reducer 2
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int)
@@ -105,7 +105,7 @@ STAGE PLANS:
1 l_partkey (type: int)
outputColumnNames: _col0, _col1, _col3
input vertices:
- 1 Map 1
+ 1 Map 3
Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -185,26 +185,12 @@ STAGE PLANS:
Stage: Stage-1
Tez
Edges:
- Reducer 3 <- Map 1 (BROADCAST_EDGE), Map 2 (SIMPLE_EDGE), Map 4 (BROADCAST_EDGE)
+ Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
#### A masked pattern was here ####
Vertices:
Map 1
Map Operator Tree:
TableScan
- alias: li
- Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (((l_partkey is not null and l_orderkey is not null) and l_linenumber is not null) and (l_linenumber = 1)) (type: boolean)
- Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: l_partkey (type: int)
- sort order: +
- Map-reduce partition columns: l_partkey (type: int)
- Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
- value expressions: l_orderkey (type: int), l_suppkey (type: int)
- Map 2
- Map Operator Tree:
- TableScan
alias: lineitem
Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -220,6 +206,20 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 50 Data size: 5999 Basic stats: COMPLETE Column stats: NONE
+ Map 3
+ Map Operator Tree:
+ TableScan
+ alias: li
+ Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((l_partkey is not null and l_orderkey is not null) and l_linenumber is not null) and (l_linenumber = 1)) (type: boolean)
+ Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: l_partkey (type: int)
+ sort order: +
+ Map-reduce partition columns: l_partkey (type: int)
+ Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
+ value expressions: l_orderkey (type: int), l_suppkey (type: int)
Map 4
Map Operator Tree:
TableScan
@@ -242,7 +242,7 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
- Reducer 3
+ Reducer 2
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: int)
@@ -260,7 +260,7 @@ STAGE PLANS:
1 l_partkey (type: int)
outputColumnNames: _col0, _col1, _col3
input vertices:
- 1 Map 1
+ 1 Map 3
Statistics: Num rows: 55 Data size: 6598 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_bucketmapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_bucketmapjoin1.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_bucketmapjoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_bucketmapjoin1.q.out Sun Nov 23 05:59:20 2014
@@ -114,7 +114,7 @@ STAGE PLANS:
Map 1
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -129,7 +129,7 @@ STAGE PLANS:
Map 3
Map Operator Tree:
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -203,32 +203,32 @@ STAGE PLANS:
Map 1
Map Operator Tree:
TableScan
- alias: b
- Statistics: Num rows: 2 Data size: 50 Basic stats: COMPLETE Column stats: NONE
+ alias: a
+ Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 25 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 25 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
+ Execution mode: vectorized
Map 3
Map Operator Tree:
TableScan
- alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ alias: b
+ Statistics: Num rows: 2 Data size: 50 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 25 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
- Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Merge Join Operator
@@ -301,32 +301,32 @@ STAGE PLANS:
Map 1
Map Operator Tree:
TableScan
- alias: b
- Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+ alias: a
+ Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 26 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
+ Execution mode: vectorized
Map 3
Map Operator Tree:
TableScan
- alias: a
- Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats: NONE
+ alias: b
+ Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 26 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 26 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
- Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Merge Join Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_context.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_context.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_context.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_context.q.out Sun Nov 23 05:59:20 2014
@@ -110,16 +110,17 @@ STAGE PLANS:
Map 1
Map Operator Tree:
TableScan
- alias: household_demographics
- Statistics: Num rows: 6075 Data size: 24300 Basic stats: COMPLETE Column stats: NONE
+ alias: store_sales
+ Statistics: Num rows: 6075 Data size: 72736 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: hd_demo_sk is not null (type: boolean)
- Statistics: Num rows: 3038 Data size: 12152 Basic stats: COMPLETE Column stats: NONE
+ predicate: (ss_store_sk is not null and ss_hdemo_sk is not null) (type: boolean)
+ Statistics: Num rows: 1519 Data size: 18186 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: hd_demo_sk (type: int)
+ key expressions: ss_store_sk (type: int)
sort order: +
- Map-reduce partition columns: hd_demo_sk (type: int)
- Statistics: Num rows: 3038 Data size: 12152 Basic stats: COMPLETE Column stats: NONE
+ Map-reduce partition columns: ss_store_sk (type: int)
+ Statistics: Num rows: 1519 Data size: 18186 Basic stats: COMPLETE Column stats: NONE
+ value expressions: ss_hdemo_sk (type: int), ss_net_profit (type: double)
Execution mode: vectorized
Map 2
Map Operator Tree:
@@ -140,7 +141,7 @@ STAGE PLANS:
1 s_store_sk (type: int)
outputColumnNames: _col1, _col2, _col7
input vertices:
- 0 Map 3
+ 0 Map 1
Statistics: Num rows: 3341 Data size: 338652 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -153,7 +154,7 @@ STAGE PLANS:
1 hd_demo_sk (type: int)
outputColumnNames: _col2, _col7
input vertices:
- 1 Map 1
+ 1 Map 3
Statistics: Num rows: 3675 Data size: 372517 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col7 (type: string), _col2 (type: double)
@@ -173,17 +174,16 @@ STAGE PLANS:
Map 3
Map Operator Tree:
TableScan
- alias: store_sales
- Statistics: Num rows: 6075 Data size: 72736 Basic stats: COMPLETE Column stats: NONE
+ alias: household_demographics
+ Statistics: Num rows: 6075 Data size: 24300 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (ss_store_sk is not null and ss_hdemo_sk is not null) (type: boolean)
- Statistics: Num rows: 1519 Data size: 18186 Basic stats: COMPLETE Column stats: NONE
+ predicate: hd_demo_sk is not null (type: boolean)
+ Statistics: Num rows: 3038 Data size: 12152 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: ss_store_sk (type: int)
+ key expressions: hd_demo_sk (type: int)
sort order: +
- Map-reduce partition columns: ss_store_sk (type: int)
- Statistics: Num rows: 1519 Data size: 18186 Basic stats: COMPLETE Column stats: NONE
- value expressions: ss_hdemo_sk (type: int), ss_net_profit (type: double)
+ Map-reduce partition columns: hd_demo_sk (type: int)
+ Statistics: Num rows: 3038 Data size: 12152 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Stage: Stage-0