Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_6.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_6.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_6.q.out Thu Oct 30 12:31:47 2014 @@ -35,7 +35,6 @@ select * from src PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from src POSTHOOK: type: QUERY @@ -48,7 +47,6 @@ select * from src PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from src POSTHOOK: type: QUERY @@ -81,29 +79,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Reducer 2 Reduce Operator Tree: @@ -114,14 +112,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6 - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -150,7 +148,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -1202,7 +1199,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@normal_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket4_1 @@ -1255,29 +1251,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 24 Data size: 2504 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 2406 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Reducer 2 Reduce Operator Tree: @@ -1288,14 +1284,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6 - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 26 Data size: 2754 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 275 Data size: 2646 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1324,7 +1320,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -1341,7 +1336,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -2393,7 +2387,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@normal_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket4_1 @@ -2446,29 +2439,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Reducer 2 Reduce Operator Tree: @@ -2479,14 +2472,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6 - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -2515,7 +2508,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(a)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000 POSTHOOK: type: QUERY @@ -2551,29 +2543,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Reducer 2 Reduce Operator Tree: @@ -2584,14 +2576,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6 - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 917 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 877 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -2620,7 +2612,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(b)*/ * from smb_bucket4_1 a join smb_bucket4_2 b on a.key = b.key where a.key>1000 POSTHOOK: type: QUERY @@ -2652,43 +2643,43 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: c - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 48 Data size: 5008 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 4812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key > 1000)) (type: boolean) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 8 Data size: 834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 798 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Reducer 2 Reduce Operator Tree: @@ -2701,14 +2692,14 @@ STAGE PLANS: 1 {KEY.reducesinkkey0} {VALUE._col0} 2 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 - Statistics: Num rows: 17 Data size: 1834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 182 Data size: 1755 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string), _col10 (type: int), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 17 Data size: 1834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 182 Data size: 1755 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 17 Data size: 1834 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 182 Data size: 1755 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/spark/smb_mapjoin_7.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_7.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_7.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_7.q.out Thu Oct 30 12:31:47 2014 @@ -59,7 +59,6 @@ select * from src PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from src POSTHOOK: type: QUERY @@ -73,7 +72,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results_empty_bigtable -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results_empty_bigtable select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -90,7 +88,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results_empty_bigtable -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results_empty_bigtable select /*+mapjoin(b)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -634,12 +631,12 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 55 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: int) sort order: + Map-reduce partition columns: key (type: int) - Statistics: Num rows: 55 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: @@ -661,14 +658,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} outputColumnNames: _col0, _col1, _col5, _col6 - Statistics: Num rows: 60 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 60 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 60 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -697,7 +694,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@smb_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_join_results select /*+mapjoin(a)*/ * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY @@ -1221,7 +1217,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket4_1 PREHOOK: Input: default@smb_bucket4_2 PREHOOK: Output: default@normal_join_results -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table normal_join_results select * from smb_bucket4_1 a full outer join smb_bucket4_2 b on a.key = b.key POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket4_1 Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_8.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_8.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/smb_mapjoin_8.q.out Thu Oct 30 12:31:47 2014 @@ -42,7 +42,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4 or key=2000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -53,7 +52,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=484 or key=3000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -96,7 +94,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=2000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -107,7 +104,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=3000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -146,7 +142,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -157,7 +152,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -192,7 +186,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -203,7 +196,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -240,7 +232,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -251,7 +242,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -262,7 +252,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -291,7 +280,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -302,7 +290,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=1000 or key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -313,7 +300,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=1000 or key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -341,7 +327,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -352,7 +337,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -363,7 +347,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -390,7 +373,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=00000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -401,7 +383,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -412,7 +393,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -439,7 +419,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_1 select * from smb_bucket_input where key=1000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -450,7 +429,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_2 select * from smb_bucket_input where key=4000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input @@ -461,7 +439,6 @@ PREHOOK: query: insert overwrite table s PREHOOK: type: QUERY PREHOOK: Input: default@smb_bucket_input PREHOOK: Output: default@smb_bucket4_3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table smb_bucket4_3 select * from smb_bucket_input where key=5000 POSTHOOK: type: QUERY POSTHOOK: Input: default@smb_bucket_input Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_1.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_1.q.out Thu Oct 30 12:31:47 2014 @@ -26,7 +26,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc1 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -37,7 +36,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc2 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -72,28 +70,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key < 10)) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 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: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key < 10)) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 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: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -102,9 +100,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 9 Data size: 991 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 9 Data size: 991 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_2.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_2.q.out Thu Oct 30 12:31:47 2014 @@ -30,7 +30,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc1 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -41,7 +40,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc2 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -80,28 +78,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -110,9 +108,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_3.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_3.q.out Thu Oct 30 12:31:47 2014 @@ -30,7 +30,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc1 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -41,7 +40,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc2 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -80,28 +78,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -110,9 +108,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_4.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_4.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_4.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_4.q.out Thu Oct 30 12:31:47 2014 @@ -30,7 +30,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc1 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -41,7 +40,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc2 select key, value from src POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -78,28 +76,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value (type: string) - Statistics: Num rows: 2 Data size: 400 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -108,9 +106,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 478 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_5.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_5.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_5.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_5.q.out Thu Oct 30 12:31:47 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_6.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_6.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_6.q.out Thu Oct 30 12:31:47 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_7.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_7.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_7.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_7.q.out Thu Oct 30 12:31:47 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_8.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_8.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sort_merge_join_desc_8.q.out Thu Oct 30 12:31:47 2014 @@ -58,7 +58,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc1 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc1 select key, value from src sort by key DESC POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -69,7 +68,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc2 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc2 select key, value from src sort by key DESC POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -80,7 +78,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc3 select key, value, concat(value,"_2") as value2 from src sort by key, value, value2 DESC POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -92,7 +89,6 @@ PREHOOK: query: insert overwrite table t PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@table_desc4 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: insert overwrite table table_desc4 select key, concat(value,"_2") as value2 from src sort by key, value2 DESC POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -127,28 +123,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key < 10)) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 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: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and (key < 10)) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 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: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -157,9 +153,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 9 Data size: 991 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 9 Data size: 991 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash @@ -235,28 +231,28 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 34 Data size: 6812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 6312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value2 is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 517 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value2 (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value2 (type: string) - Statistics: Num rows: 3 Data size: 601 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 517 Basic stats: COMPLETE Column stats: NONE Map 4 Map Operator Tree: TableScan alias: a - Statistics: Num rows: 53 Data size: 10718 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 10218 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key is not null and value2 is not null) and (key < 10)) (type: boolean) - Statistics: Num rows: 4 Data size: 808 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 837 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: key (type: string), value2 (type: string) sort order: ++ Map-reduce partition columns: key (type: string), value2 (type: string) - Statistics: Num rows: 4 Data size: 808 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 837 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -265,9 +261,9 @@ STAGE PLANS: condition expressions: 0 1 - Statistics: Num rows: 4 Data size: 888 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 920 Basic stats: COMPLETE Column stats: NONE Select Operator - Statistics: Num rows: 4 Data size: 888 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 45 Data size: 920 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() mode: hash Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.out Thu Oct 30 12:31:47 2014 @@ -289,8 +289,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@src_4 PREHOOK: Output: default@src_5 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: from src b INSERT OVERWRITE TABLE src_4 select * @@ -724,8 +722,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@src_4 PREHOOK: Output: default@src_5 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: from src b INSERT OVERWRITE TABLE src_4 select * Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/table_access_keys_stats.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/table_access_keys_stats.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/table_access_keys_stats.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/table_access_keys_stats.q.out Thu Oct 30 12:31:47 2014 @@ -260,8 +260,6 @@ PREHOOK: type: QUERY PREHOOK: Input: default@t1 PREHOOK: Output: default@t2 PREHOOK: Output: default@t3 -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to Operator:GBY_2 Table:default@t1 Keys:key Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table.q.out Thu Oct 30 12:31:47 2014 @@ -63,7 +63,6 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src PREHOOK: Output: database:default PREHOOK: Output: default@foo -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src @@ -134,7 +133,6 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src PREHOOK: Output: database:default PREHOOK: Output: default@bar -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src @@ -170,14 +168,14 @@ STAGE PLANS: Processor Tree: TableScan alias: foo - Statistics: Num rows: 14 Data size: 2856 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 247 Data size: 2609 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2856 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 247 Data size: 2609 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 10 Data size: 2040 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select * from foo limit 10 @@ -247,13 +245,13 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 28 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 100 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -299,7 +297,6 @@ PREHOOK: query: INSERT OVERWRITE TABLE b PREHOOK: type: QUERY PREHOOK: Input: default@foo PREHOOK: Output: default@baz -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: INSERT OVERWRITE TABLE baz SELECT * from foo POSTHOOK: type: QUERY POSTHOOK: Input: default@foo @@ -326,7 +323,6 @@ PREHOOK: query: INSERT OVERWRITE TABLE b PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@bay -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: INSERT OVERWRITE TABLE bay SELECT * FROM src ORDER BY key POSTHOOK: type: QUERY POSTHOOK: Input: default@src @@ -389,7 +385,6 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@foo PREHOOK: Output: database:two PREHOOK: Output: two@foo -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@foo Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/spark/temp_table_join1.q.out Thu Oct 30 12:31:47 2014 @@ -3,7 +3,6 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src PREHOOK: Output: database:default PREHOOK: Output: default@src_nontemp -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src @@ -14,7 +13,6 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src PREHOOK: Output: database:default PREHOOK: Output: default@src_temp -[Error 30017]: Skipping stats aggregation by error org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30015]: Stats aggregator of type counter cannot be connected to POSTHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src @@ -45,29 +43,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 - Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: src1 - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -77,14 +75,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} outputColumnNames: _col0, _col6 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -141,29 +139,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 - Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: src1 - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -173,14 +171,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} outputColumnNames: _col0, _col6 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -239,29 +237,29 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src2 - Statistics: Num rows: 0 Data size: 114 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 0 Data size: 0 Basic stats: NONE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE value expressions: value (type: string) Map 3 Map Operator Tree: TableScan alias: src1 - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 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: 1 Data size: 114 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reducer 2 Reduce Operator Tree: Join Operator @@ -271,14 +269,14 @@ STAGE PLANS: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} outputColumnNames: _col0, _col6 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
