Modified: hive/branches/spark/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out Sat Jul 26 23:45:46 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/drop_udf.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/drop_udf.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/drop_udf.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/drop_udf.q.out Sat Jul 26 23:45:46 2014 @@ -1,9 +1,9 @@ PREHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate' PREHOOK: type: CREATEFUNCTION -PREHOOK: Output: database:default +PREHOOK: Output: test_translate POSTHOOK: query: CREATE TEMPORARY FUNCTION test_translate AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestTranslate' POSTHOOK: type: CREATEFUNCTION -POSTHOOK: Output: database:default +POSTHOOK: Output: test_translate PREHOOK: query: EXPLAIN DROP TEMPORARY FUNCTION test_translate PREHOOK: type: DROPFUNCTION @@ -18,7 +18,7 @@ STAGE PLANS: PREHOOK: query: DROP TEMPORARY FUNCTION test_translate PREHOOK: type: DROPFUNCTION -PREHOOK: Output: database:default +PREHOOK: Output: test_translate POSTHOOK: query: DROP TEMPORARY FUNCTION test_translate POSTHOOK: type: DROPFUNCTION -POSTHOOK: Output: database:default +POSTHOOK: Output: test_translate Modified: hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out Sat Jul 26 23:45:46 2014 @@ -713,7 +713,7 @@ v5:srcpart predicate: (ds = '10') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator (SEL_2) - expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) + expressions: key (type: string), value (type: string), '10' (type: string), hr (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator (FS_4) Modified: hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out Sat Jul 26 23:45:46 2014 @@ -139,6 +139,7 @@ STAGE PLANS: columns: key string, dummy1 string, dummy2 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: dummy Stage: Stage-2 Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppd.q.out Sat Jul 26 23:45:46 2014 @@ -26,13 +26,13 @@ STAGE PLANS: predicate: (bar = 1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: bar (type: int), foo (type: int) - outputColumnNames: _col0, _col1 + expressions: foo (type: int) + outputColumnNames: _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Union Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col1 (type: int), _col0 (type: int) + expressions: _col1 (type: int), 1 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator @@ -52,13 +52,13 @@ STAGE PLANS: predicate: (bar = 1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: bar (type: int), foo (type: int) - outputColumnNames: _col0, _col1 + expressions: foo (type: int) + outputColumnNames: _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Union Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col1 (type: int), _col0 (type: int) + expressions: _col1 (type: int), 1 (type: int) outputColumnNames: _col0, _col1 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/groupby_ppr.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_1_23.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_6.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_6.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_6.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out Sat Jul 26 23:45:46 2014 @@ -59,7 +59,7 @@ STAGE PLANS: predicate: (key = 86) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: string), val (type: string) + expressions: '86' (type: string), val (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_file_format.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_file_format.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_file_format.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_file_format.q.out Sat Jul 26 23:45:46 2014 @@ -73,17 +73,17 @@ STAGE PLANS: TableScan alias: src filterExpr: (key = 86) (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '86' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 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: 28 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 @@ -189,17 +189,17 @@ STAGE PLANS: TableScan alias: src filterExpr: (key = 86) (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '86' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 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: 28 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 Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_multiple.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_multiple.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_multiple.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_multiple.q.out Sat Jul 26 23:45:46 2014 @@ -91,17 +91,17 @@ STAGE PLANS: TableScan alias: src filterExpr: (key = 86) (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '86' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 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: 28 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 Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_partitioned.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_partitioned.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_partitioned.q.out Sat Jul 26 23:45:46 2014 @@ -87,17 +87,17 @@ STAGE PLANS: TableScan alias: srcpart filterExpr: ((key = 86) and (ds = '2008-04-09')) (type: boolean) - Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 112 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '86' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_update.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_update.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_update.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_update.q.out Sat Jul 26 23:45:46 2014 @@ -259,7 +259,7 @@ STAGE PLANS: predicate: (key = 86) (type: boolean) Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), val (type: string) + expressions: '86' (type: string), val (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out Sat Jul 26 23:45:46 2014 @@ -95,17 +95,17 @@ STAGE PLANS: TableScan alias: srcpart filterExpr: ((key = 86) and (ds = '2008-04-09')) (type: boolean) - Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 112 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 86) (type: boolean) - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '86' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_stale.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_stale.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_stale.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_stale.q.out Sat Jul 26 23:45:46 2014 @@ -71,7 +71,7 @@ STAGE PLANS: predicate: (key = 86) (type: boolean) Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), val (type: string) + expressions: '86' (type: string), val (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_stale_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_stale_partitioned.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_stale_partitioned.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_stale_partitioned.q.out Sat Jul 26 23:45:46 2014 @@ -92,7 +92,7 @@ STAGE PLANS: predicate: (key = 86) (type: boolean) Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), val (type: string), foo (type: string) + expressions: '86' (type: string), val (type: string), foo (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/infer_const_type.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/infer_const_type.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/infer_const_type.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/infer_const_type.q.out Sat Jul 26 23:45:46 2014 @@ -56,12 +56,12 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes - Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (str = 1234)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) + expressions: 127 (type: tinyint), 32767 (type: smallint), 12345 (type: int), -12345 (type: bigint), 906.0 (type: float), -307.0 (type: double), '1234' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -135,7 +135,7 @@ STAGE PLANS: alias: infertypes Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE Filter Operator - predicate: (((((false or false) or false) or false) or false) or false) (type: boolean) + predicate: false (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) @@ -199,7 +199,7 @@ STAGE PLANS: alias: infertypes Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE Filter Operator - predicate: ((false or false) or false) (type: boolean) + predicate: false (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) @@ -253,12 +253,12 @@ STAGE PLANS: Map Operator Tree: TableScan alias: infertypes - Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((ti < 127.0) and (i > 100.0)) and (str = 1.57)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) + expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), '1.57' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out Sat Jul 26 23:45:46 2014 @@ -15,6 +15,7 @@ STAGE PLANS: field delimiter: 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: TEST15 PREHOOK: query: CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE Modified: hive/branches/spark/ql/src/test/results/clientpositive/input18.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input18.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input18.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input18.q.out Sat Jul 26 23:45:46 2014 @@ -36,7 +36,7 @@ STAGE PLANS: alias: src Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int) + expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Transform Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/input26.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input26.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input26.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input26.q.out Sat Jul 26 23:45:46 2014 @@ -85,7 +85,7 @@ STAGE PLANS: Map Reduce Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string) + expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), '2008-04-08' (type: string), '14' (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Limit Modified: hive/branches/spark/ql/src/test/results/clientpositive/input38.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input38.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input38.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input38.q.out Sat Jul 26 23:45:46 2014 @@ -39,7 +39,7 @@ STAGE PLANS: alias: src Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string), (1 + 2) (type: int), (3 + 4) (type: int) + expressions: key (type: string), value (type: string), 3 (type: int), 7 (type: int) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Transform Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/input39_hadoop20.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input39_hadoop20.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input39_hadoop20.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input39_hadoop20.q.out Sat Jul 26 23:45:46 2014 @@ -73,24 +73,24 @@ STAGE PLANS: alias: t2 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean) + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE TableScan alias: t1 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (((hash(rand(460476415)) & 2147483647) % 32) = 0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + predicate: ((((hash(rand(460476415)) & 2147483647) % 32) = 0) and key is not null) (type: boolean) + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) sort order: + Map-reduce partition columns: key (type: string) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -98,9 +98,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(1) mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/input6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input6.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input6.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input6.q.out Sat Jul 26 23:45:46 2014 @@ -34,7 +34,7 @@ STAGE PLANS: predicate: key is null (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: null (type: void), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/input_part2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input_part2.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/input_part2.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/input_part2.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/input_part4.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input_part4.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input_part4.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input_part4.q.out Sat Jul 26 23:45:46 2014 @@ -19,7 +19,7 @@ STAGE PLANS: predicate: ((ds = '2008-04-08') and (hr = 15)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) + expressions: key (type: string), value (type: string), '2008-04-08' (type: string), '15' (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE ListSink Modified: hive/branches/spark/ql/src/test/results/clientpositive/input_part6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input_part6.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input_part6.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input_part6.q.out Sat Jul 26 23:45:46 2014 @@ -16,12 +16,12 @@ STAGE PLANS: alias: x Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (ds = ((2008 - 4) - 8)) (type: boolean) - Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE + predicate: (ds = 1996) (type: boolean) + Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) + expressions: key (type: string), value (type: string), '1996' (type: string), hr (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 116 Data size: 23248 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 Statistics: Num rows: 10 Data size: 2000 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/spark/ql/src/test/results/clientpositive/input_part7.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input_part7.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/input_part7.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/input_part7.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out Sat Jul 26 23:45:46 2014 @@ -14,6 +14,7 @@ STAGE PLANS: columns: key int, 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: INPUTDDL1 PREHOOK: query: CREATE TABLE INPUTDDL1(key INT, value STRING) STORED AS TEXTFILE Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out Sat Jul 26 23:45:46 2014 @@ -15,6 +15,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat partition columns: ds string, country string + serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: INPUTDDL2 PREHOOK: query: CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds STRING, country STRING) STORED AS TEXTFILE Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out Sat Jul 26 23:45:46 2014 @@ -15,6 +15,7 @@ STAGE PLANS: field delimiter: 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: INPUTDDL3 PREHOOK: query: CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE Modified: hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out Sat Jul 26 23:45:46 2014 @@ -48,10 +48,10 @@ STAGE PLANS: alias: a Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator - predicate: (key = (- 1)) (type: boolean) + predicate: (key = -1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: int), value (type: string) + expressions: -1 (type: int), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -137,10 +137,10 @@ STAGE PLANS: alias: a Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator - predicate: (key = (- 1)) (type: boolean) + predicate: (key = -1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: int), value (type: string) + expressions: -1 (type: int), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -239,10 +239,10 @@ STAGE PLANS: alias: a Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator - predicate: (key = (- 1)) (type: boolean) + predicate: (key = -1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: int), value (type: string) + expressions: -1 (type: int), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -328,10 +328,10 @@ STAGE PLANS: alias: a Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Filter Operator - predicate: (key = (- 1)) (type: boolean) + predicate: (key = -1) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: int), value (type: string) + expressions: -1 (type: int), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/join14_hadoop20.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join14_hadoop20.q.out Sat Jul 26 23:45:46 2014 @@ -30,7 +30,7 @@ STAGE PLANS: alias: srcpart Statistics: Num rows: 58 Data size: 11624 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (key > 100) (type: boolean) + predicate: ((key > 100) and key is not null) (type: boolean) Statistics: Num rows: 19 Data size: 3807 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) @@ -42,7 +42,7 @@ STAGE PLANS: alias: src Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (key > 100) (type: boolean) + predicate: ((key > 100) and key is not null) (type: boolean) Statistics: Num rows: 19 Data size: 1903 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string) Modified: hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join35.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join35.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join35.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join35.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out Sat Jul 26 23:45:46 2014 @@ -63,17 +63,17 @@ STAGE PLANS: a TableScan alias: a - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key = 111)) (type: boolean) - Statistics: Num rows: 7 Data size: 1402 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 14 Data size: 1453 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator condition expressions: 0 {value} 1 {col5} keys: - 0 key (type: string) - 1 col11 (type: string) + 0 '111' (type: string) + 1 '111' (type: string) Stage: Stage-1 Map Reduce @@ -91,25 +91,25 @@ STAGE PLANS: 0 {value} 1 {col5} keys: - 0 key (type: string) - 1 col11 (type: string) + 0 '111' (type: string) + 1 '111' (type: string) outputColumnNames: _col1, _col9 - Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: string), _col9 (type: string) outputColumnNames: _col1, _col9 - Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(1) keys: _col1 (type: string), _col9 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 7 Data size: 1542 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: bigint) Local Work: Map Reduce Local Work @@ -119,14 +119,14 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 3 Data size: 660 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 7 Data size: 745 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out Sat Jul 26 23:45:46 2014 @@ -323,7 +323,7 @@ STAGE PLANS: Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE - value expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string) + value expressions: p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string) TableScan alias: p1 Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE @@ -337,8 +337,8 @@ STAGE PLANS: Inner Join 0 to 1 condition expressions: 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -368,18 +368,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col12 (type: string) Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} 1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out Sat Jul 26 23:45:46 2014 @@ -340,7 +340,7 @@ STAGE PLANS: Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 634 Basic stats: COMPLETE Column stats: NONE - value expressions: p_partkey (type: int), p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string) + value expressions: p_name (type: string), p_mfgr (type: string), p_brand (type: string), p_type (type: string), p_size (type: int), p_container (type: string), p_retailprice (type: double), p_comment (type: string) TableScan alias: p1 Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE @@ -354,8 +354,8 @@ STAGE PLANS: Inner Join 0 to 1 condition expressions: 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -385,26 +385,26 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col12 (type: string) Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} 1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean) - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + predicate: (_col23 = _col12) (type: boolean) + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26 - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out Sat Jul 26 23:45:46 2014 @@ -377,7 +377,7 @@ STAGE PLANS: Reduce Output Operator sort order: Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string) + value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string) TableScan alias: p1 Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE @@ -391,8 +391,8 @@ STAGE PLANS: Inner Join 0 to 1 condition expressions: 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -422,18 +422,18 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col12 (type: string) Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} 1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out Sat Jul 26 23:45:46 2014 @@ -394,7 +394,7 @@ STAGE PLANS: Reduce Output Operator sort order: Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: p2_partkey (type: int), p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string) + value expressions: p2_name (type: string), p2_mfgr (type: string), p2_brand (type: string), p2_type (type: string), p2_size (type: int), p2_container (type: string), p2_retailprice (type: double), p2_comment (type: string) TableScan alias: p1 Statistics: Num rows: 5 Data size: 3173 Basic stats: COMPLETE Column stats: NONE @@ -408,8 +408,8 @@ STAGE PLANS: Inner Join 0 to 1 condition expressions: 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - 1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 + 1 {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19 Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -439,26 +439,26 @@ STAGE PLANS: sort order: + Map-reduce partition columns: _col12 (type: string) Statistics: Num rows: 5 Data size: 3490 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) + value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {VALUE._col11} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} + 0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} {VALUE._col8} {KEY.reducesinkkey0} {VALUE._col12} {VALUE._col13} {VALUE._col14} {VALUE._col15} {VALUE._col16} {VALUE._col17} {VALUE._col18} 1 {VALUE._col0} {KEY.reducesinkkey0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5} {VALUE._col6} {VALUE._col7} - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col22, _col23, _col24, _col25, _col26, _col27, _col28, _col29, _col30 Statistics: Num rows: 5 Data size: 3839 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: ((_col11 = 1) and (_col23 = _col12)) (type: boolean) - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + predicate: (_col23 = _col12) (type: boolean) + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), _col11 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: double), _col8 (type: string), 1 (type: int), _col12 (type: string), _col13 (type: string), _col14 (type: string), _col15 (type: string), _col16 (type: int), _col17 (type: string), _col18 (type: double), _col19 (type: string), _col22 (type: int), _col23 (type: string), _col24 (type: string), _col25 (type: string), _col26 (type: string), _col27 (type: int), _col28 (type: string), _col29 (type: double), _col30 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18, _col19, _col20, _col21, _col22, _col23, _col24, _col25, _col26 - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 767 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1535 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out Sat Jul 26 23:45:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out Sat Jul 26 23:45:46 2014 @@ -50,8 +50,8 @@ STAGE PLANS: Inner Join 0 to 1 condition expressions: 0 {VALUE._col1} - 1 {VALUE._col0} {KEY.reducesinkkey0} - outputColumnNames: _col1, _col5, _col7 + 1 {VALUE._col0} + outputColumnNames: _col1, _col5 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: _col1 (type: string), _col5 (type: int), _col7 (type: string) Modified: hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out?rev=1613740&r1=1613739&r2=1613740&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/keyword_1.q.out Sat Jul 26 23:45:46 2014 @@ -52,7 +52,7 @@ PREHOOK: query: show grant user hive_tes PREHOOK: type: SHOW_GRANT POSTHOOK: query: show grant user hive_test on table test_user POSTHOOK: type: SHOW_GRANT -default test_user hive_test USER Select false -1 hive_test_user +default test_user hive_test USER SELECT false -1 hive_test_user PREHOOK: query: drop table test_user PREHOOK: type: DROPTABLE PREHOOK: Input: default@test_user @@ -111,7 +111,7 @@ PREHOOK: query: show grant user hive_tes PREHOOK: type: SHOW_GRANT POSTHOOK: query: show grant user hive_test on table test_user POSTHOOK: type: SHOW_GRANT -default test_user hive_test USER Select false -1 hive_test_user +default test_user hive_test USER SELECT false -1 hive_test_user PREHOOK: query: drop table test_user PREHOOK: type: DROPTABLE PREHOOK: Input: default@test_user
