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