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:
