You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/10/30 13:31:52 UTC
svn commit: r1635477 [15/17] - in /hive/branches/spark:
common/src/java/org/apache/hadoop/hive/common/ data/conf/spark/
ql/src/java/org/apache/hadoop/hive/ql/exec/spark/
ql/src/java/org/apache/hadoop/hive/ql/exec/spark/counter/
ql/src/java/org/apache/h...
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