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/07/26 17:39:59 UTC
svn commit: r1613661 [4/9] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ conf/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/...
Modified: hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out Sat Jul 26 15:39:55 2014
@@ -95,17 +95,17 @@ STAGE PLANS:
TableScan
alias: srcpart
filterExpr: ((key = 86) and (ds = '2008-04-09')) (type: boolean)
- Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 86) (type: boolean)
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: '86' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5812 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/index_stale.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out Sat Jul 26 15:39:55 2014
@@ -71,7 +71,7 @@ STAGE PLANS:
predicate: (key = 86) (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), val (type: string)
+ expressions: '86' (type: string), val (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out Sat Jul 26 15:39:55 2014
@@ -92,7 +92,7 @@ STAGE PLANS:
predicate: (key = 86) (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), val (type: string), foo (type: string)
+ expressions: '86' (type: string), val (type: string), foo (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out Sat Jul 26 15:39:55 2014
@@ -56,12 +56,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: infertypes
- Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (str = 1234)) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
+ expressions: 127 (type: tinyint), 32767 (type: smallint), 12345 (type: int), -12345 (type: bigint), 906.0 (type: float), -307.0 (type: double), '1234' (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -135,7 +135,7 @@ STAGE PLANS:
alias: infertypes
Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
Filter Operator
- predicate: (((((false or false) or false) or false) or false) or false) (type: boolean)
+ predicate: false (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
@@ -199,7 +199,7 @@ STAGE PLANS:
alias: infertypes
Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
Filter Operator
- predicate: ((false or false) or false) (type: boolean)
+ predicate: false (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
@@ -253,12 +253,12 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: infertypes
- Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((ti < 127.0) and (i > 100.0)) and (str = 1.57)) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string)
+ expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), '1.57' (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input18.q.out Sat Jul 26 15:39:55 2014
@@ -36,7 +36,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int)
+ expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Transform Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/input23.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/input26.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input26.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input26.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input26.q.out Sat Jul 26 15:39:55 2014
@@ -85,7 +85,7 @@ STAGE PLANS:
Map Reduce
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string)
+ expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), '2008-04-08' (type: string), '14' (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Limit
Modified: hive/trunk/ql/src/test/results/clientpositive/input38.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input38.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input38.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input38.q.out Sat Jul 26 15:39:55 2014
@@ -39,7 +39,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int)
+ expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Transform Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input39_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input39_hadoop20.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input39_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input39_hadoop20.q.out Sat Jul 26 15:39:55 2014
@@ -73,24 +73,24 @@ STAGE PLANS:
alias: t2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
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
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: t1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean)
- Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean)
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
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
+ Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -98,9 +98,9 @@ STAGE PLANS:
condition expressions:
0
1
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
Select Operator
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
mode: hash
Modified: hive/trunk/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input6.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input6.q.out Sat Jul 26 15:39:55 2014
@@ -34,7 +34,7 @@ STAGE PLANS:
predicate: key is null (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: null (type: void), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part4.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part4.q.out Sat Jul 26 15:39:55 2014
@@ -19,7 +19,7 @@ STAGE PLANS:
predicate: ((ds = '2008-04-08') and (hr = 15)) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
+ expressions: key (type: string), value (type: string), '2008-04-08' (type: string), '15' (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
ListSink
Modified: hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input_part6.q.out Sat Jul 26 15:39:55 2014
@@ -16,12 +16,12 @@ STAGE PLANS:
alias: x
Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (ds = ((2008 - 4) - 8)) (type: boolean)
- Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ predicate: (ds = 1996) (type: boolean)
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
+ expressions: key (type: string), value (type: string), '1996' (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert1.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert1.q.out Sat Jul 26 15:39:55 2014
@@ -48,10 +48,10 @@ STAGE PLANS:
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
- predicate: (key = (- 1)) (type: boolean)
+ predicate: (key = -1) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: int), value (type: string)
+ expressions: -1 (type: int), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -137,10 +137,10 @@ STAGE PLANS:
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
- predicate: (key = (- 1)) (type: boolean)
+ predicate: (key = -1) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: int), value (type: string)
+ expressions: -1 (type: int), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -239,10 +239,10 @@ STAGE PLANS:
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
- predicate: (key = (- 1)) (type: boolean)
+ predicate: (key = -1) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: int), value (type: string)
+ expressions: -1 (type: int), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -328,10 +328,10 @@ STAGE PLANS:
alias: a
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
- predicate: (key = (- 1)) (type: boolean)
+ predicate: (key = -1) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: key (type: int), value (type: string)
+ expressions: -1 (type: int), value (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out Sat Jul 26 15:39:55 2014
@@ -30,7 +30,7 @@ STAGE PLANS:
alias: srcpart
Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (key > 100) (type: boolean)
+ predicate: ((key > 100) and key is not null) (type: boolean)
Statistics: Num rows: 19 Data size: 3807 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -42,7 +42,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (key > 100) (type: boolean)
+ predicate: ((key > 100) and key is not null) (type: boolean)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join38.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join38.q.out Sat Jul 26 15:39:55 2014
@@ -63,17 +63,17 @@ STAGE PLANS:
a
TableScan
alias: a
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key is not null and (key = 111)) (type: boolean)
- Statistics: Num rows: 7 Data size: 1402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 14 Data size: 1453 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
0 {value}
1 {col5}
keys:
- 0 key (type: string)
- 1 col11 (type: string)
+ 0 '111' (type: string)
+ 1 '111' (type: string)
Stage: Stage-1
Map Reduce
@@ -91,25 +91,25 @@ STAGE PLANS:
0 {value}
1 {col5}
keys:
- 0 key (type: string)
- 1 col11 (type: string)
+ 0 '111' (type: string)
+ 1 '111' (type: string)
outputColumnNames: _col1, _col9
- Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col9 (type: string)
outputColumnNames: _col1, _col9
- Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
keys: _col1 (type: string), _col9 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 1598 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: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Local Work:
Map Reduce Local Work
@@ -119,14 +119,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string), KEY._col1 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 745 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/join_cond_pushdown_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out Sat Jul 26 15:39:55 2014
@@ -323,7 +323,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
+ value expressions: p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
TableScan
alias: p1
Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -337,8 +337,8 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+ 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -368,18 +368,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out Sat Jul 26 15:39:55 2014
@@ -340,7 +340,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE
- value expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
+ value expressions: p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string)
TableScan
alias: p1
Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -354,8 +354,8 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+ 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -385,26 +385,26 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean)
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ predicate: (_col23 = _col12) (type: boolean)
+ Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 1535 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/join_cond_pushdown_unqual1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out Sat Jul 26 15:39:55 2014
@@ -377,7 +377,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
+ value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
TableScan
alias: p1
Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -391,8 +391,8 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+ 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -422,18 +422,18 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out Sat Jul 26 15:39:55 2014
@@ -394,7 +394,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
+ value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string)
TableScan
alias: p1
Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
@@ -408,8 +408,8 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
+ 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8}
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -439,26 +439,26 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
+ value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18}
1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7}
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30
Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean)
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ predicate: (_col23 = _col12) (type: boolean)
+ Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 1535 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/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_view.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_view.q.out Sat Jul 26 15:39:55 2014
@@ -50,8 +50,8 @@ STAGE PLANS:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col1}
- 1 {VALUE._col0} {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col5, _col7
+ 1 {VALUE._col0}
+ outputColumnNames: _col1, _col5
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col5 (type: int), _col7 (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_ppd.q.out Sat Jul 26 15:39:55 2014
@@ -12,26 +12,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -39,20 +39,20 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -95,26 +95,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -122,23 +122,23 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Filter Operator
predicate: (col = 1) (type: boolean)
- Statistics: Num rows: 7 Data size: 1402 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 14 Data size: 1427 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 21 Data size: 4207 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 42 Data size: 4282 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -266,35 +266,35 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4, _col5
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -302,20 +302,20 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col1, _col4, _col5
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -323,29 +323,29 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col1, _col4
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4, _col5
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -353,20 +353,20 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 28 Data size: 5610 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 56 Data size: 5710 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
outputColumnNames: _col1, _col4, _col5
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 56 Data size: 11220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 112 Data size: 11420 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -429,26 +429,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = '0') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Forward
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string)
outputColumnNames: value
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -456,23 +456,23 @@ STAGE PLANS:
Select Operator
expressions: array(1,2,3) (type: array<int>)
outputColumnNames: _col0
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
UDTF Operator
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE
function name: explode
Filter Operator
predicate: (col > 1) (type: boolean)
- Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 9 Data size: 917 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
outputColumnNames: _col1, _col4
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col4 (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 18 Data size: 3606 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 37 Data size: 3772 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/list_bucket_dml_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_1.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_14.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_3.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out Sat Jul 26 15:39:55 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out Sat Jul 26 15:39:55 2014 differ