hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject svn commit: r1635477 [17/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...
Date Thu, 30 Oct 2014 12:31:52 GMT
Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_bucketmapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_bucketmapjoin1.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_bucketmapjoin1.q.out
(original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_bucketmapjoin1.q.out
Thu Oct 30 12:31:47 2014
@@ -58,7 +58,6 @@ PREHOOK: query: insert into table vsmb_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@vsmb_bucket_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 into table vsmb_bucket_1 select cint, cstring1 from alltypesorc limit
2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -69,7 +68,6 @@ PREHOOK: query: insert into table vsmb_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@vsmb_bucket_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 into table vsmb_bucket_2 select cint, cstring1 from alltypesorc limit
2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -80,7 +78,6 @@ PREHOOK: query: insert into table vsmb_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@vsmb_bucket_rc
-[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 into table vsmb_bucket_RC select cint, cstring1 from alltypesorc
limit 2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -91,7 +88,6 @@ PREHOOK: query: insert into table vsmb_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@vsmb_bucket_txt
-[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 into table vsmb_bucket_TXT select cint, cstring1 from alltypesorc
limit 2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -119,30 +115,30 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 3 Data size: 369 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 2 Data size: 246 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 104 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: 2 Data size: 246 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
             Execution mode: vectorized
         Map 3 
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 3 Data size: 369 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 2 Data size: 246 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 104 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: 2 Data size: 246 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
             Execution mode: vectorized
         Reducer 2 
@@ -154,14 +150,14 @@ STAGE PLANS:
                   0 {KEY.reducesinkkey0} {VALUE._col0}
                   1 {KEY.reducesinkkey0} {VALUE._col0}
                 outputColumnNames: _col0, _col1, _col5, _col6
-                Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 114 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: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -208,29 +204,29 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 1 Data size: 129 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 50 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 1 Data size: 129 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 25 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: 1 Data size: 129 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 25 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
         Map 3 
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 3 Data size: 369 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 2 Data size: 246 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 104 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: 2 Data size: 246 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
             Execution mode: vectorized
         Reducer 2 
@@ -242,14 +238,14 @@ STAGE PLANS:
                   0 {KEY.reducesinkkey0} {VALUE._col0}
                   1 {KEY.reducesinkkey0} {VALUE._col0}
                 outputColumnNames: _col0, _col1, _col5, _col6
-                Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 114 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: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -306,29 +302,29 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: b
-                  Statistics: Num rows: 0 Data size: 54 Basic stats: PARTIAL Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 52 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: 1 Data size: 26 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: 0 Data size: 0 Basic stats: NONE Column stats:
NONE
+                      Statistics: Num rows: 1 Data size: 26 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
         Map 3 
             Map Operator Tree:
                 TableScan
                   alias: a
-                  Statistics: Num rows: 3 Data size: 369 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 2 Data size: 208 Basic stats: COMPLETE Column stats:
NONE
                   Filter Operator
                     predicate: key is not null (type: boolean)
-                    Statistics: Num rows: 2 Data size: 246 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 104 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: 2 Data size: 246 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 1 Data size: 104 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: value (type: string)
             Execution mode: vectorized
         Reducer 2 
@@ -340,14 +336,14 @@ STAGE PLANS:
                   0 {KEY.reducesinkkey0} {VALUE._col0}
                   1 {KEY.reducesinkkey0} {VALUE._col0}
                 outputColumnNames: _col0, _col1, _col5, _col6
-                Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 1 Data size: 114 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: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats:
NONE
                   File Output Operator
                     compressed: false
-                    Statistics: Num rows: 2 Data size: 270 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 1 Data size: 114 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/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out (original)
and hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out Thu
Oct 30 12:31:47 2014 differ

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_rcfile_columnar.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_rcfile_columnar.q.out
(original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_rcfile_columnar.q.out
Thu Oct 30 12:31:47 2014
@@ -27,7 +27,6 @@ INSERT OVERWRITE TABLE columnTable SELEC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@columntable
-[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
 INSERT OVERWRITE TABLE columnTable SELECT src.key, src.value LIMIT 10
 POSTHOOK: type: QUERY

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out
(original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/vectorized_timestamp_funcs.q.out
Thu Oct 30 12:31:47 2014
@@ -25,7 +25,6 @@ LIMIT 40
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@alltypesorc_string
-[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 alltypesorc_string
 SELECT
   to_utc_timestamp(ctimestamp1, 'America/Los_Angeles'),
@@ -49,7 +48,6 @@ PREHOOK: query: INSERT INTO TABLE alltyp
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@alltypesorc_wrong
-[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 INTO TABLE alltypesorc_wrong SELECT 'abcd' FROM alltypesorc LIMIT
1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -59,7 +57,6 @@ PREHOOK: query: INSERT INTO TABLE alltyp
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@alltypesorc_wrong
-[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 INTO TABLE alltypesorc_wrong SELECT '2000:01:01 00-00-00' FROM alltypesorc
LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -69,7 +66,6 @@ PREHOOK: query: INSERT INTO TABLE alltyp
 PREHOOK: type: QUERY
 PREHOOK: Input: default@alltypesorc
 PREHOOK: Output: default@alltypesorc_wrong
-[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 INTO TABLE alltypesorc_wrong SELECT '0000-00-00 99:99:99' FROM alltypesorc
LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@alltypesorc
@@ -116,15 +112,15 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: to_unix_timestamp(ctimestamp1) (type: bigint), year(ctimestamp1)
(type: int), month(ctimestamp1) (type: int), day(ctimestamp1) (type: int), dayofmonth(ctimestamp1)
(type: int), weekofyear(ctimestamp1) (type: int), hour(ctimestamp1) (type: int), minute(ctimestamp1)
(type: int), second(ctimestamp1) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                    Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: bigint)
                       sort order: +
-                      Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type:
int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type:
int)
             Execution mode: vectorized
         Reducer 2 
@@ -132,10 +128,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int),
VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type:
int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -259,15 +255,15 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 8 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1)
(type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1)
(type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1)
(type: int), second(stimestamp1) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                    Statistics: Num rows: 8 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: bigint)
                       sort order: +
-                      Statistics: Num rows: 8 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type:
int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type:
int)
             Execution mode: vectorized
         Reducer 2 
@@ -275,10 +271,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int),
VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type:
int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                Statistics: Num rows: 8 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 8 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -402,15 +398,15 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 5 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: (to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1))
(type: boolean), (year(ctimestamp1) = year(stimestamp1)) (type: boolean), (month(ctimestamp1)
= month(stimestamp1)) (type: boolean), (day(ctimestamp1) = day(stimestamp1)) (type: boolean),
(dayofmonth(ctimestamp1) = dayofmonth(stimestamp1)) (type: boolean), (weekofyear(ctimestamp1)
= weekofyear(stimestamp1)) (type: boolean), (hour(ctimestamp1) = hour(stimestamp1)) (type:
boolean), (minute(ctimestamp1) = minute(stimestamp1)) (type: boolean), (second(ctimestamp1)
= second(stimestamp1)) (type: boolean)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                    Statistics: Num rows: 5 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: boolean)
                       sort order: +
-                      Statistics: Num rows: 5 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3
(type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7
(type: boolean), _col8 (type: boolean)
             Execution mode: vectorized
         Reducer 2 
@@ -418,10 +414,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: boolean),
VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4
(type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type:
boolean)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                Statistics: Num rows: 5 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 5 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -549,15 +545,15 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_wrong
-                  Statistics: Num rows: 6 Data size: 678 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1)
(type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1)
(type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1)
(type: int), second(stimestamp1) (type: int)
                     outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                    Statistics: Num rows: 6 Data size: 678 Basic stats: COMPLETE Column stats:
NONE
+                    Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats:
NONE
                     Reduce Output Operator
                       key expressions: _col0 (type: bigint)
                       sort order: +
-                      Statistics: Num rows: 6 Data size: 678 Basic stats: COMPLETE Column
stats: NONE
+                      Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column
stats: NONE
                       value expressions: _col1 (type: int), _col2 (type: int), _col3 (type:
int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type:
int)
             Execution mode: vectorized
         Reducer 2 
@@ -565,10 +561,10 @@ STAGE PLANS:
               Select Operator
                 expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int),
VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type:
int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
                 outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8
-                Statistics: Num rows: 6 Data size: 678 Basic stats: COMPLETE Column stats:
NONE
+                Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats:
NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 6 Data size: 678 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats:
NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -643,11 +639,11 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: ctimestamp1 (type: timestamp)
                     outputColumnNames: ctimestamp1
-                    Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: min(ctimestamp1), max(ctimestamp1), count(ctimestamp1),
count()
                       mode: hash
@@ -728,11 +724,11 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: ctimestamp1 (type: timestamp)
                     outputColumnNames: ctimestamp1
-                    Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: sum(ctimestamp1)
                       mode: hash
@@ -818,11 +814,11 @@ STAGE PLANS:
             Map Operator Tree:
                 TableScan
                   alias: alltypesorc_string
-                  Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column stats:
NONE
+                  Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats:
NONE
                   Select Operator
                     expressions: ctimestamp1 (type: timestamp)
                     outputColumnNames: ctimestamp1
-                    Statistics: Num rows: 20 Data size: 829 Basic stats: COMPLETE Column
stats: NONE
+                    Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column
stats: NONE
                     Group By Operator
                       aggregations: avg(ctimestamp1), variance(ctimestamp1), var_pop(ctimestamp1),
var_samp(ctimestamp1), std(ctimestamp1), stddev(ctimestamp1), stddev_pop(ctimestamp1), stddev_samp(ctimestamp1)
                       mode: hash

Modified: hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out?rev=1635477&r1=1635476&r2=1635477&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/windowing.q.out Thu Oct 30
12:31:47 2014
@@ -1351,9 +1351,6 @@ PREHOOK: Input: default@part
 PREHOOK: Output: default@part_1
 PREHOOK: Output: default@part_2
 PREHOOK: Output: default@part_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
-[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 part 
 INSERT OVERWRITE TABLE part_1 
 select p_mfgr, p_name, p_size, 



Mime
View raw message