You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/07/27 01:46:00 UTC
svn commit: r1613740 [24/29] - in /hive/branches/spark: ./
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/resources/
beeline/src/test/org/apache/hive/beeline/ bin/ bin/ext/ common/
common/src/java/org/apache/hadoop/hive/ant/ common/src/java...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/quotedid_basic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/quotedid_basic.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/quotedid_basic.q.out Sat Jul 26 23:45:46 2014
@@ -76,7 +76,7 @@ STAGE PLANS:
predicate: (!@#$%^&*()_q = '1') (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+ expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -112,7 +112,7 @@ STAGE PLANS:
predicate: (!@#$%^&*()_q = '1') (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+ expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
outputColumnNames: x+1, y&y, !@#$%^&*()_q
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -171,7 +171,7 @@ STAGE PLANS:
predicate: (!@#$%^&*()_q = '1') (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+ expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
outputColumnNames: x+1, y&y, !@#$%^&*()_q
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
@@ -254,7 +254,7 @@ STAGE PLANS:
predicate: (!@#$%^&*()_q = '1') (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+ expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
outputColumnNames: x+1, y&y, !@#$%^&*()_q
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/quotedid_partition.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/quotedid_partition.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/quotedid_partition.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/quotedid_partition.q.out Sat Jul 26 23:45:46 2014
@@ -45,7 +45,7 @@ STAGE PLANS:
predicate: (x+1 = '10') (type: boolean)
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+ expressions: '10' (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
outputColumnNames: x+1, y&y, !@#$%^&*()_q
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Group By Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/reduce_deduplicate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/reduce_deduplicate.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/reduce_deduplicate.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/reduce_deduplicate.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/regex_col.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/regex_col.q.out Sat Jul 26 23:45:46 2014
@@ -179,26 +179,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
- Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key = 103) and key is not null) (type: boolean)
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: string), hr (type: string), ds (type: string)
+ key expressions: '103' (type: string), hr (type: string), ds (type: string)
sort order: +++
- Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string)
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map-reduce partition columns: hr (type: string), ds (type: string)
+ Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: a
- Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((key = 103) and key is not null) (type: boolean)
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: string), hr (type: string), ds (type: string)
+ key expressions: '103' (type: string), hr (type: string), ds (type: string)
sort order: +++
- Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string)
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Map-reduce partition columns: hr (type: string), ds (type: string)
+ Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -207,11 +207,11 @@ STAGE PLANS:
0
1 {KEY.reducesinkkey2} {KEY.reducesinkkey1}
outputColumnNames: _col8, _col9
- Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col8 (type: string), _col9 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -226,15 +226,15 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
sort order: ++
- Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2130 Data size: 6393 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/branches/spark/ql/src/test/results/clientpositive/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/regexp_extract.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/regexp_extract.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/router_join_ppr.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/router_join_ppr.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/router_join_ppr.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sample10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sample10.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sample10.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sample10.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sample6.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sample6.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sample6.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sample8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sample8.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sample8.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sample8.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/select_dummy_source.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/select_dummy_source.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/select_dummy_source.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/select_dummy_source.q.out Sat Jul 26 23:45:46 2014
@@ -64,7 +64,7 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- expressions: (1 + 1) (type: int)
+ expressions: 2 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
File Output Operator
@@ -193,7 +193,7 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- expressions: (1 + 1) (type: int)
+ expressions: 2 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
ListSink
@@ -277,7 +277,7 @@ STAGE PLANS:
Row Limit Per Split: 1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
- expressions: (2 + 3) (type: int), (1 + 2) (type: int)
+ expressions: 5 (type: int), (1 + 2) (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_and.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_and.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_and.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_and.q.out Sat Jul 26 23:45:46 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
alias: npe_test
Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((ds > ((2012 - 11) - 31)) and (ds < ((2012 - 12) - 15))) (type: boolean)
+ predicate: ((ds > 1970) and (ds < 1985)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), ds (type: string)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_not.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_not.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_not.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_not.q.out Sat Jul 26 23:45:46 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
alias: npe_test
Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (not (ds < ((2012 - 11) - 31))) (type: boolean)
+ predicate: (not (ds < 1970)) (type: boolean)
Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), ds (type: string)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_or.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_or.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_or.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/select_unquote_or.q.out Sat Jul 26 23:45:46 2014
@@ -58,7 +58,7 @@ STAGE PLANS:
alias: npe_test
Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((ds > ((2012 - 11) - 31)) or (ds < ((2012 - 12) - 15))) (type: boolean)
+ predicate: ((ds > 1970) or (ds < 1985)) (type: boolean)
Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), ds (type: string)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/set_processor_namespaces.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/set_processor_namespaces.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/set_processor_namespaces.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/set_processor_namespaces.q.out Sat Jul 26 23:45:46 2014
@@ -17,17 +17,17 @@ 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 = 5) (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
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: '5' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- 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
File Output Operator
compressed: false
- 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
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/set_variable_sub.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/set_variable_sub.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/set_variable_sub.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/set_variable_sub.q.out Sat Jul 26 23:45:46 2014
@@ -12,17 +12,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 'value1') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: 'value1' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -48,17 +48,17 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 'value1') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: 'value1' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -84,17 +84,17 @@ 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 = '1') (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
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: '1' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- 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
File Output Operator
compressed: false
- 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
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_alter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_alter.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_alter.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_alter.q.out Sat Jul 26 23:45:46 2014
@@ -51,7 +51,7 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE `tmp_showcrt1`(
+CREATE TABLE `tmp_showcrt1`(
`key` smallint,
`value` float)
COMMENT 'temporary table'
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_db_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_db_table.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_db_table.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_db_table.q.out Sat Jul 26 23:45:46 2014
@@ -29,7 +29,7 @@ PREHOOK: Input: tmp_feng@tmp_showcrt
POSTHOOK: query: SHOW CREATE TABLE tmp_feng.tmp_showcrt
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: tmp_feng@tmp_showcrt
-CREATE TABLE `tmp_feng.tmp_showcrt`(
+CREATE TABLE `tmp_feng.tmp_showcrt`(
`key` string,
`value` int)
ROW FORMAT SERDE
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_delimited.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_delimited.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_delimited.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_delimited.q.out Sat Jul 26 23:45:46 2014
@@ -23,7 +23,7 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE `tmp_showcrt1`(
+CREATE TABLE `tmp_showcrt1`(
`key` int,
`value` string,
`newvalue` bigint)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_serde.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_serde.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_create_table_serde.q.out Sat Jul 26 23:45:46 2014
@@ -25,7 +25,7 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE `tmp_showcrt1`(
+CREATE TABLE `tmp_showcrt1`(
`key` int,
`value` string,
`newvalue` bigint)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/show_roles.q.out Sat Jul 26 23:45:46 2014
@@ -14,3 +14,4 @@ admin
public
role1
role2
+
Modified: hive/branches/spark/ql/src/test/results/clientpositive/skewjoin_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/skewjoin_noskew.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/skewjoin_noskew.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/skewjoin_noskew.q.out Sat Jul 26 23:45:46 2014
@@ -146,6 +146,7 @@ STAGE PLANS:
columns: key string, value string
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: noskew
Stage: Stage-3
Modified: hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Sat Jul 26 23:45:46 2014
@@ -349,6 +349,7 @@ STAGE PLANS:
columns: k1 int, value string, ds string, k2 int
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: smb_mapjoin9_results
Stage: Stage-3
Modified: hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out Sat Jul 26 23:45:46 2014
@@ -208,12 +208,14 @@ POSTHOOK: Input: default@test_table2@ds=
253
PREHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table
-- This should be a map-only operation, one of the buckets should be empty
+
EXPLAIN
INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2')
SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238
PREHOOK: type: QUERY
POSTHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table
-- This should be a map-only operation, one of the buckets should be empty
+
EXPLAIN
INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2')
SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238
Modified: hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Sat Jul 26 23:45:46 2014
@@ -66,9 +66,8 @@ STAGE PLANS:
predicate: (key is not null and (key = 5)) (type: boolean)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: int)
+ key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: key (type: int)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: a
@@ -77,21 +76,19 @@ STAGE PLANS:
predicate: (key is not null and (key = 5)) (type: boolean)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: int)
+ key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: key (type: int)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0}
+ 0
1
- outputColumnNames: _col0
Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int)
+ expressions: 5 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -129,7 +126,7 @@ STAGE PLANS:
predicate: (_col1 = 5) (type: boolean)
Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: int)
+ expressions: _col0 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -150,9 +147,8 @@ STAGE PLANS:
predicate: (key is not null and (key = 5)) (type: boolean)
Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: int)
+ key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: key (type: int)
Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: c
@@ -161,21 +157,19 @@ STAGE PLANS:
predicate: (key is not null and (key = 5)) (type: boolean)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions: key (type: int)
+ key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: key (type: int)
Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0}
+ 0
1
- outputColumnNames: _col0
Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int)
+ expressions: 5 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Sat Jul 26 23:45:46 2014
@@ -28,26 +28,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: 51 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 'no_such_value') (type: boolean)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
+ expressions: 'no_such_value' (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string)
sort order: +
Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
Reduce Operator Tree:
Extract
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2849 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/branches/spark/ql/src/test/results/clientpositive/subq_where_serialization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/subq_where_serialization.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/subq_where_serialization.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/subq_where_serialization.q.out Sat Jul 26 23:45:46 2014
@@ -93,17 +93,15 @@ STAGE PLANS:
0 key (type: string)
1 _col0 (type: string)
outputColumnNames: _col0
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Select Operator
- expressions: _col0 (type: string)
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
@@ -136,20 +134,17 @@ STAGE PLANS:
1
outputColumnNames: _col0
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists.q.out Sat Jul 26 23:45:46 2014
@@ -66,20 +66,17 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists_having.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists_having.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/subquery_exists_having.q.out Sat Jul 26 23:45:46 2014
@@ -104,20 +104,17 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: bigint)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: bigint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -153,6 +150,164 @@ POSTHOOK: Input: default@src
96 1
97 2
98 2
+PREHOOK: query: -- no agg, corr
+explain
+select b.key, count(*)
+from src b
+group by b.key
+having exists
+ (select a.key
+ from src a
+ where a.key = b.key and a.value > 'val_9'
+ )
+PREHOOK: type: QUERY
+POSTHOOK: query: -- no agg, corr
+explain
+select b.key, count(*)
+from src b
+group by b.key
+having exists
+ (select a.key
+ from src a
+ where a.key = b.key and a.value > 'val_9'
+ )
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: b
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string)
+ outputColumnNames: key
+ Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count()
+ keys: key (type: string)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: bigint)
+ TableScan
+ alias: a
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((value > 'val_9') and key is not null) (type: boolean)
+ Statistics: Num rows: 5 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: string)
+ outputColumnNames: _col1
+ Statistics: Num rows: 5 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ keys: _col1 (type: string)
+ mode: hash
+ outputColumnNames: _col0
+ Statistics: Num rows: 5 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 5 Data size: 1002 Basic stats: COMPLETE Column stats: NONE
+ Reduce Operator Tree:
+ Demux Operator
+ Statistics: Num rows: 34 Data size: 3908 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: string)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 17 Data size: 1954 Basic stats: COMPLETE Column stats: NONE
+ Mux Operator
+ Statistics: Num rows: 51 Data size: 5862 Basic stats: COMPLETE Column stats: NONE
+ Join Operator
+ condition map:
+ Left Semi Join 0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: bigint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Mux Operator
+ Statistics: Num rows: 51 Data size: 5862 Basic stats: COMPLETE Column stats: NONE
+ Join Operator
+ condition map:
+ Left Semi Join 0 to 1
+ condition expressions:
+ 0 {KEY.reducesinkkey0} {VALUE._col0}
+ 1
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: bigint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select b.key, count(*)
+from src b
+group by b.key
+having exists
+ (select a.key
+ from src a
+ where a.key = b.key and a.value > 'val_9'
+ )
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select b.key, count(*)
+from src b
+group by b.key
+having exists
+ (select a.key
+ from src a
+ where a.key = b.key and a.value > 'val_9'
+ )
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+90 3
+92 1
+95 2
+96 1
+97 2
+98 2
PREHOOK: query: -- view test
create view cv1 as
select b.key, count(*) as c
Modified: hive/branches/spark/ql/src/test/results/clientpositive/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/subquery_in.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/subquery_in.q.out Sat Jul 26 23:45:46 2014
@@ -157,20 +157,17 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 8 Data size: 1653 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 1653 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 8 Data size: 1653 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -269,20 +266,17 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -447,20 +441,17 @@ STAGE PLANS:
1
outputColumnNames: _col1, _col5
Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 8 Data size: 872 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: string), _col5 (type: int)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 872 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 8 Data size: 872 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col1 (type: string), _col5 (type: int)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -618,20 +609,17 @@ STAGE PLANS:
1
outputColumnNames: _col1, _col2, _col5
Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 2 Data size: 465 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 2 Data size: 465 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 2 Data size: 465 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -763,20 +751,17 @@ STAGE PLANS:
1
outputColumnNames: _col0, _col1
Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (1 = 1) (type: boolean)
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 4 Data size: 881 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -947,24 +932,24 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col3 (type: int)
TableScan
alias: lineitem
- Statistics: Num rows: 116 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1728 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((l_shipmode = 'AIR') and l_orderkey is not null) (type: boolean)
- Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_orderkey (type: int)
outputColumnNames: _col0
- Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map: