You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by rh...@apache.org on 2014/04/09 19:32:31 UTC
svn commit: r1586050 [2/4] - in /hive/branches/branch-0.13/ql/src:
java/org/apache/hadoop/hive/ql/optimizer/
java/org/apache/hadoop/hive/ql/optimizer/correlation/
java/org/apache/hadoop/hive/ql/parse/ test/queries/clientpositive/
test/results/clientpos...
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map.q.out Wed Apr 9 17:32:30 2014
@@ -57,7 +57,7 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,input:string>), _col3 (type: struct<count:bigint,sum:double,input:string>), _col4 (type: string), _col5 (type: string), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: struct<count:bigint,sum:double,variance:double>), _col9 (type: struct<count:bigint,sum:double,variance:double>)
+ value expressions: _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,input:string>), _col4 (type: string), _col5 (type: string), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: struct<count:bigint,sum:double,variance:double>), _col9 (type: struct<count:bigint,sum:double,variance:double>)
Reduce Operator Tree:
Group By Operator
aggregations: sum(VALUE._col0), avg(VALUE._col1), avg(DISTINCT KEY._col0:0._col0), max(VALUE._col3), min(VALUE._col4), std(VALUE._col5), stddev_samp(VALUE._col6), variance(VALUE._col7), var_samp(VALUE._col8)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map_skew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map_skew.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map_skew.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby3_map_skew.q.out Wed Apr 9 17:32:30 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,input:string>), _col3 (type: struct<count:bigint,sum:double,input:string>), _col4 (type: string), _col5 (type: string), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: struct<count:bigint,sum:double,variance:double>), _col9 (type: struct<count:bigint,sum:double,variance:double>)
+ value expressions: _col1 (type: double), _col2 (type: struct<count:bigint,sum:double,input:string>), _col4 (type: string), _col5 (type: string), _col6 (type: struct<count:bigint,sum:double,variance:double>), _col7 (type: struct<count:bigint,sum:double,variance:double>), _col8 (type: struct<count:bigint,sum:double,variance:double>), _col9 (type: struct<count:bigint,sum:double,variance:double>)
Reduce Operator Tree:
Group By Operator
aggregations: sum(VALUE._col0), avg(VALUE._col1), avg(DISTINCT KEY._col0:0._col0), max(VALUE._col3), min(VALUE._col4), std(VALUE._col5), stddev_samp(VALUE._col6), variance(VALUE._col7), var_samp(VALUE._col8)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_cube1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_cube1.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_cube1.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_cube1.q.out Wed Apr 9 17:32:30 2014
@@ -129,7 +129,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
@@ -310,7 +309,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out Wed Apr 9 17:32:30 2014
@@ -46,14 +46,14 @@ STAGE PLANS:
alias: t1
Statistics: Num rows: 8 Data size: 120 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: int1 (type: int), int2 (type: int), str1 (type: string), str2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
+ expressions: int1 (type: int)
+ outputColumnNames: _col0
Statistics: Num rows: 8 Data size: 120 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 8 Data size: 120 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: string), _col3 (type: string)
+ value expressions: _col0 (type: int)
Reduce Operator Tree:
Extract
Statistics: Num rows: 8 Data size: 120 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Wed Apr 9 17:32:30 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out Wed Apr 9 17:32:30 2014
@@ -258,7 +258,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
@@ -317,7 +316,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: double)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out Wed Apr 9 17:32:30 2014
@@ -236,8 +236,8 @@ STAGE PLANS:
predicate: (((((key + key) = 200) or ((key - 100) = 100)) or ((key = 300) and value is not null)) or (((key + key) = 400) or (((key - 100) = 500) and value is not null))) (type: boolean)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: string), key (type: string)
- outputColumnNames: value, key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: value (type: string)
@@ -648,8 +648,8 @@ STAGE PLANS:
predicate: (((((key + key) = 200) or ((key - 100) = 100)) or ((key = 300) and value is not null)) or (((key + key) = 400) or (((key - 100) = 500) and value is not null))) (type: boolean)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: string), key (type: string)
- outputColumnNames: value, key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: value (type: string)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_position.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_position.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_position.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_position.q.out Wed Apr 9 17:32:30 2014
@@ -59,7 +59,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Filter Operator
predicate: (key < 20) (type: boolean)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
@@ -121,7 +120,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
@@ -274,7 +272,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Filter Operator
predicate: (key < 20) (type: boolean)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
@@ -336,7 +333,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 9 Data size: 1803 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
@@ -663,7 +659,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_rollup1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_rollup1.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_rollup1.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_rollup1.q.out Wed Apr 9 17:32:30 2014
@@ -123,7 +123,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
@@ -298,7 +297,6 @@ STAGE PLANS:
sort order: +++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- value expressions: _col3 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col2:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_11.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_11.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_11.q.out Wed Apr 9 17:32:30 2014
@@ -348,7 +348,6 @@ STAGE PLANS:
key expressions: _col0 (type: double)
sort order: +
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col0:0._col0)
@@ -413,7 +412,6 @@ STAGE PLANS:
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 10 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col0:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_8.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_8.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/groupby_sort_8.q.out Wed Apr 9 17:32:30 2014
@@ -141,7 +141,6 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col0:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/join18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/join18.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/join18.q.out Wed Apr 9 17:32:30 2014
@@ -52,7 +52,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown.q.out Wed Apr 9 17:32:30 2014
@@ -446,7 +446,6 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: tinyint)
Statistics: Num rows: 31436 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
- value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0)
@@ -536,7 +535,6 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: tinyint)
Statistics: Num rows: 1849 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.3
- value expressions: _col3 (type: bigint), _col4 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0), count(DISTINCT KEY._col1:1._col0)
@@ -954,8 +952,8 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: string), key (type: string)
- outputColumnNames: value, key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: value (type: string)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/limit_pushdown_negative.q.out Wed Apr 9 17:32:30 2014
@@ -241,8 +241,8 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: string), key (type: string)
- outputColumnNames: value, key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: value (type: string)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/metadataonly1.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/metadataonly1.q.out Wed Apr 9 17:32:30 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby2.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby2.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby2.q.out Wed Apr 9 17:32:30 2014
@@ -51,7 +51,7 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: double)
+ value expressions: _col1 (type: double)
Reduce Operator Tree:
Extract
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -73,7 +73,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: double), 0.5 (type: double)
+ value expressions: _col1 (type: double)
Reduce Operator Tree:
Forward
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby3.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby3.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_gby3.q.out Wed Apr 9 17:32:30 2014
@@ -1678,7 +1678,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Select Operator
expressions: value (type: string), key (type: string)
outputColumnNames: value, key
@@ -1737,7 +1736,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col1:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Wed Apr 9 17:32:30 2014
@@ -1060,7 +1060,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: double)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
@@ -1086,7 +1085,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: double)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Lateral View Forward
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1196,7 +1194,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: double)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Reduce Operator Tree:
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0)
@@ -1239,7 +1236,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Reduce Operator Tree:
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0)
@@ -1552,7 +1548,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Select Operator
expressions: array((key + 1),(key + 2)) (type: array<double>)
outputColumnNames: _col0
@@ -1578,7 +1573,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Lateral View Forward
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -1634,8 +1628,8 @@ STAGE PLANS:
predicate: ((key > 200) or (key < 200)) (type: boolean)
Statistics: Num rows: 6 Data size: 62 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: string), key (type: string)
- outputColumnNames: value, key
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: key, value
Statistics: Num rows: 6 Data size: 62 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1685,7 +1679,6 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: double)
Reduce Operator Tree:
Group By Operator
aggregations: sum(DISTINCT KEY._col1:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup.q.out Wed Apr 9 17:32:30 2014
@@ -149,7 +149,6 @@ STAGE PLANS:
sort order:
Map-reduce partition columns: rand() (type: double)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1)
@@ -227,7 +226,6 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup2.q.out Wed Apr 9 17:32:30 2014
@@ -187,7 +187,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: rand() (type: double)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1)
@@ -272,7 +271,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: key (type: string)
Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4.q.out Wed Apr 9 17:32:30 2014
@@ -34,7 +34,7 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0), count(DISTINCT KEY._col0:0._col0)
@@ -121,7 +121,7 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: bigint)
+ value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0), count(DISTINCT KEY._col0:0._col0)
@@ -183,7 +183,6 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: value (type: string)
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1), count(DISTINCT KEY._col0:0._col0)
@@ -264,7 +263,6 @@ STAGE PLANS:
key expressions: value (type: string)
sort order: +
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1), count(DISTINCT KEY._col0:0._col0)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out Wed Apr 9 17:32:30 2014
@@ -32,7 +32,7 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint)
+ value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0), count(DISTINCT KEY._col0:0._col0), count(DISTINCT KEY._col0:1._col0)
@@ -92,7 +92,6 @@ STAGE PLANS:
key expressions: value (type: string), substr(value, 5) (type: string)
sort order: ++
Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
- value expressions: 1 (type: int)
Reduce Operator Tree:
Group By Operator
aggregations: count(1), count(DISTINCT KEY._col0:0._col0), count(DISTINCT KEY._col0:1._col0)
Added: hive/branches/branch-0.13/ql/src/test/results/clientpositive/order_within_subquery.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/order_within_subquery.q.out?rev=1586050&view=auto
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/order_within_subquery.q.out (added)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/order_within_subquery.q.out Wed Apr 9 17:32:30 2014
@@ -0,0 +1,52 @@
+PREHOOK: query: CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+POSTHOOK: query: CREATE TABLE part(
+ p_partkey INT,
+ p_name STRING,
+ p_mfgr STRING,
+ p_brand STRING,
+ p_type STRING,
+ p_size INT,
+ p_container STRING,
+ p_retailprice DOUBLE,
+ p_comment STRING
+)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part
+PREHOOK: query: select t1.p_name, t2.p_name
+from (select * from part order by p_size limit 10) t1 join part t2 on t1.p_partkey = t2.p_partkey and t1.p_size = t2.p_size
+where t1.p_partkey < 100000
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.p_name, t2.p_name
+from (select * from part order by p_size limit 10) t1 join part t2 on t1.p_partkey = t2.p_partkey and t1.p_size = t2.p_size
+where t1.p_partkey < 100000
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part
+#### A masked pattern was here ####
+almond aquamarine yellow dodger mint almond aquamarine yellow dodger mint
+almond azure aquamarine papaya violet almond azure aquamarine papaya violet
+almond antique misty red olive almond antique misty red olive
+almond antique medium spring khaki almond antique medium spring khaki
+almond antique gainsboro frosted violet almond antique gainsboro frosted violet
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out Wed Apr 9 17:32:30 2014
@@ -32,7 +32,7 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
Extract
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2516,7 +2516,7 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
Extract
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_count.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_count.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_count.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_count.q.out Wed Apr 9 17:32:30 2014
@@ -100,7 +100,6 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col0:0._col0)
@@ -161,7 +160,6 @@ STAGE PLANS:
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
aggregations: count(DISTINCT KEY._col0:0._col0, KEY._col0:0._col1)
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union11.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union11.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union11.q.out Wed Apr 9 17:32:30 2014
@@ -48,9 +48,9 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 'tst1' (type: string), _col0 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ expressions: 'tst1' (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -63,11 +63,11 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
@@ -82,11 +82,11 @@ STAGE PLANS:
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
@@ -101,11 +101,11 @@ STAGE PLANS:
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
@@ -161,9 +161,9 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 'tst2' (type: string), _col0 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ expressions: 'tst2' (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -195,9 +195,9 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 'tst3' (type: string), _col0 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE
+ expressions: 'tst3' (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union14.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union14.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union14.q.out Wed Apr 9 17:32:30 2014
@@ -44,9 +44,9 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 'tst1' (type: string), UDFToString(_col0) (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE
+ expressions: 'tst1' (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -59,47 +59,47 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Union
- Statistics: Num rows: 2 Data size: 488 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 304 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 488 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 304 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
TableScan
Union
- Statistics: Num rows: 2 Data size: 488 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 304 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 2 Data size: 488 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 304 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union15.q.out?rev=1586050&r1=1586049&r2=1586050&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union15.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union15.q.out Wed Apr 9 17:32:30 2014
@@ -46,9 +46,9 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
- expressions: 'tst1' (type: string), UDFToString(_col0) (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE
+ expressions: 'tst1' (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
table:
@@ -61,72 +61,72 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
value expressions: _col1 (type: bigint)
TableScan
alias: s2
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Union
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
value expressions: _col1 (type: bigint)
TableScan
alias: s3
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Union
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: _col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 3 Data size: 704 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 520 Basic stats: COMPLETE Column stats: PARTIAL
Group By Operator
aggregations: count(1)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 3 Data size: 264 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 5 Data size: 440 Basic stats: COMPLETE Column stats: PARTIAL
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -134,14 +134,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 88 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 2 Data size: 176 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: PARTIAL
+ Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: PARTIAL
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat