You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/01/28 06:48:10 UTC
svn commit: r1561947 [14/17] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/ cli/
cli/src/java/org/apache/hadoop/hive/cli/ common/ common/src/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out?rev=1561947&r1=1561946&r2=1561947&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/metadata_only_queries.q.out Tue Jan 28 05:48:03 2014
@@ -7,7 +7,7 @@ PREHOOK: query: create table over10k(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
row format delimited
@@ -22,7 +22,7 @@ POSTHOOK: query: create table over10k(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
row format delimited
@@ -232,10 +232,10 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -282,7 +282,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -313,6 +313,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -322,7 +324,7 @@ STAGE PLANS:
expr: min(b)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
sort order:
tag: -1
@@ -332,7 +334,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -340,23 +342,29 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
+ expr: max(VALUE._col8)
+ expr: min(VALUE._col9)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Select Operator
expressions:
expr: _col0
@@ -364,7 +372,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -372,10 +380,14 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
File Output Operator
compressed: false
GlobalTableId: 0
@@ -389,10 +401,10 @@ STAGE PLANS:
limit: -1
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -439,7 +451,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -470,6 +482,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -479,7 +493,7 @@ STAGE PLANS:
expr: min(b)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
sort order:
tag: -1
@@ -489,7 +503,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -497,23 +511,29 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
+ expr: max(VALUE._col8)
+ expr: min(VALUE._col9)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Select Operator
expressions:
expr: _col0
@@ -521,7 +541,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -529,10 +549,14 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
File Output Operator
compressed: false
GlobalTableId: 0
@@ -760,10 +784,10 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -810,7 +834,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -820,10 +844,10 @@ STAGE PLANS:
Fetch Operator
limit: 1
-PREHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
PREHOOK: type: QUERY
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
POSTHOOK: type: QUERY
#### A masked pattern was here ####
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
@@ -870,12 +894,12 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).si SIMPLE [(over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
-9999 9999 9999 9999 9999 9999 65791 0 99.9800033569336 0.0
+9999 9999 1999.8 9999 9999 9999 9999 9999 65791 0 99.9800033569336 0.0
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -922,7 +946,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -932,10 +956,10 @@ STAGE PLANS:
Fetch Operator
limit: 1
-PREHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
PREHOOK: type: QUERY
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
POSTHOOK: type: QUERY
#### A masked pattern was here ####
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
@@ -982,7 +1006,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).si SIMPLE [(over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
-9489 9489 9489 9489 9489 9489 65791 0 99.9800033569336 0.0
+9489 9489 1897.8 9489 9489 9489 9489 9489 65791 0 99.9800033569336 0.0
PREHOOK: query: explain select count(ts) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(ts) from stats_tbl_part
Modified: hive/branches/tez/ql/src/test/results/clientpositive/overridden_confs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/overridden_confs.q.out?rev=1561947&r1=1561946&r2=1561947&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/overridden_confs.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/overridden_confs.q.out Tue Jan 28 05:48:03 2014
@@ -2,7 +2,6 @@ PREHOOK: query: select count(*) from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-Key: mapred.job.tracker, Value: local
Key: hive.exec.post.hooks, Value: org.apache.hadoop.hive.ql.hooks.VerifyOverriddenConfigsHook
Key: hive.config.doesnt.exit, Value: abc
500
Modified: hive/branches/tez/ql/src/test/results/clientpositive/partition_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/partition_date.q.out?rev=1561947&r1=1561946&r2=1561947&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/partition_date.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/partition_date.q.out Tue Jan 28 05:48:03 2014
@@ -2,29 +2,29 @@ PREHOOK: query: drop table partition_dat
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table partition_date_1
POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int)
+PREHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region int)
+POSTHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@partition_date_1
-PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1)
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region= '1')
select * from src tablesample (10 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1
-POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=1)
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region= '1')
select * from src tablesample (10 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@partition_date_1@dt=2000-01-01/region=1
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=2)
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region= '2')
select * from src tablesample (5 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_date_1@dt=2000-01-01/region=2
-POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region=2)
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2000-01-01', region= '2')
select * from src tablesample (5 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -33,12 +33,28 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=1)
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-12-10', region= '2020-20-20')
+ select * from src tablesample (5 rows)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-12-10', region= '2020-20-20')
+ select * from src tablesample (5 rows)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region= '1')
select * from src tablesample (20 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=1
-POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=1)
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region= '1')
select * from src tablesample (20 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -49,12 +65,14 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10)
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region= '10')
select * from src tablesample (11 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@partition_date_1@dt=2013-08-08/region=10
-POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region=10)
+POSTHOOK: query: insert overwrite table partition_date_1 partition(dt='2013-08-08', region= '10')
select * from src tablesample (11 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
@@ -67,6 +85,8 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select distinct dt from partition_date_1
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
@@ -74,6 +94,7 @@ PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+PREHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
#### A masked pattern was here ####
POSTHOOK: query: select distinct dt from partition_date_1
POSTHOOK: type: QUERY
@@ -82,6 +103,7 @@ POSTHOOK: Input: default@partition_date_
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
+POSTHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
#### A masked pattern was here ####
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -91,14 +113,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
2000-01-01
2013-08-08
-PREHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = 2 order by key,value
+2013-12-10
+PREHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = '2' order by key,value
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
-POSTHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = 2 order by key,value
+POSTHOOK: query: select * from partition_date_1 where dt = '2000-01-01' and region = '2' order by key,value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
@@ -111,6 +136,8 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
165 val_165 2000-01-01 2
238 val_238 2000-01-01 2
27 val_27 2000-01-01 2
@@ -138,6 +165,8 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
15
PREHOOK: query: -- 15. Also try with string value in predicate
select count(*) from partition_date_1 where dt = '2000-01-01'
@@ -161,15 +190,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
15
PREHOOK: query: -- 5
-select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = '2'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
#### A masked pattern was here ####
POSTHOOK: query: -- 5
-select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 2
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = '2'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=2
@@ -182,15 +213,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
5
PREHOOK: query: -- 11
-select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10
+select count(*) from partition_date_1 where dt = date '2013-08-08' and region = '10'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
#### A masked pattern was here ####
POSTHOOK: query: -- 11
-select count(*) from partition_date_1 where dt = date '2013-08-08' and region = 10
+select count(*) from partition_date_1 where dt = date '2013-08-08' and region = '10'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=10
@@ -203,16 +236,18 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
11
PREHOOK: query: -- 30
-select count(*) from partition_date_1 where region = 1
+select count(*) from partition_date_1 where region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 30
-select count(*) from partition_date_1 where region = 1
+select count(*) from partition_date_1 where region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
@@ -226,14 +261,16 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
30
PREHOOK: query: -- 0
-select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = '3'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
#### A masked pattern was here ####
POSTHOOK: query: -- 0
-select count(*) from partition_date_1 where dt = date '2000-01-01' and region = 3
+select count(*) from partition_date_1 where dt = date '2000-01-01' and region = '3'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
#### A masked pattern was here ####
@@ -245,6 +282,8 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0
PREHOOK: query: -- 0
select count(*) from partition_date_1 where dt = date '1999-01-01'
@@ -264,11 +303,13 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0
PREHOOK: query: -- Try other comparison operations
-- 20
-select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt > date '2000-01-01' and region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
@@ -276,7 +317,7 @@ PREHOOK: Input: default@partition_date_1
POSTHOOK: query: -- Try other comparison operations
-- 20
-select count(*) from partition_date_1 where dt > date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt > date '2000-01-01' and region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
@@ -289,15 +330,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
20
PREHOOK: query: -- 10
-select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1
+select count(*) from partition_date_1 where dt < date '2000-01-02' and region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 10
-select count(*) from partition_date_1 where dt < date '2000-01-02' and region = 1
+select count(*) from partition_date_1 where dt < date '2000-01-02' and region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
@@ -310,15 +353,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
10
PREHOOK: query: -- 20
-select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1
+select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 20
-select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = 1
+select count(*) from partition_date_1 where dt >= date '2000-01-02' and region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
@@ -331,15 +376,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
20
PREHOOK: query: -- 10
-select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 10
-select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt <= date '2000-01-01' and region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
@@ -352,15 +399,17 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
10
PREHOOK: query: -- 20
-select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = '1'
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_date_1
PREHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
#### A masked pattern was here ####
POSTHOOK: query: -- 20
-select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = 1
+select count(*) from partition_date_1 where dt <> date '2000-01-01' and region = '1'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@partition_date_1
POSTHOOK: Input: default@partition_date_1@dt=2013-08-08/region=1
@@ -373,7 +422,82 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
20
+PREHOOK: query: -- 10
+select count(*) from partition_date_1 where dt between date '1999-12-30' and date '2000-01-03' and region = '1'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 10
+select count(*) from partition_date_1 where dt between date '1999-12-30' and date '2000-01-03' and region = '1'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2000-01-01/region=1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+10
+PREHOOK: query: -- Try a string key with date-like strings
+
+-- 5
+select count(*) from partition_date_1 where region = '2020-20-20'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+#### A masked pattern was here ####
+POSTHOOK: query: -- Try a string key with date-like strings
+
+-- 5
+select count(*) from partition_date_1 where region = '2020-20-20'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+5
+PREHOOK: query: -- 5
+select count(*) from partition_date_1 where region > '2010-01-01'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partition_date_1
+PREHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+#### A masked pattern was here ####
+POSTHOOK: query: -- 5
+select count(*) from partition_date_1 where region > '2010-01-01'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partition_date_1
+POSTHOOK: Input: default@partition_date_1@dt=2013-12-10/region=2020-20-20
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2000-01-01,region=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+5
PREHOOK: query: drop table partition_date_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partition_date_1
@@ -390,3 +514,5 @@ POSTHOOK: Lineage: partition_date_1 PART
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=10).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-08-08,region=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partition_date_1 PARTITION(dt=2013-12-10,region=2020-20-20).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/partitions_json.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/partitions_json.q.out?rev=1561947&r1=1561946&r2=1561947&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/partitions_json.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/partitions_json.q.out Tue Jan 28 05:48:03 2014
@@ -23,11 +23,9 @@ POSTHOOK: type: SHOWPARTITIONS
PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@add_part_test
-PREHOOK: Output: default@add_part_test@ds=2010-01-01
POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@add_part_test
-POSTHOOK: Output: default@add_part_test@ds=2010-01-01
PREHOOK: query: SHOW PARTITIONS add_part_test
PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: SHOW PARTITIONS add_part_test
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out?rev=1561947&r1=1561946&r2=1561947&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out Tue Jan 28 05:48:03 2014
@@ -7,7 +7,7 @@ PREHOOK: query: create table over10k(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
row format delimited
@@ -22,7 +22,7 @@ POSTHOOK: query: create table over10k(
d double,
bo boolean,
s string,
- ts timestamp,
+ ts timestamp,
dec decimal,
bin binary)
row format delimited
@@ -232,10 +232,10 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -282,7 +282,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -313,6 +313,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -322,7 +324,7 @@ STAGE PLANS:
expr: min(b)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
sort order:
tag: -1
@@ -332,7 +334,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -340,23 +342,29 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
+ expr: max(VALUE._col8)
+ expr: min(VALUE._col9)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Select Operator
expressions:
expr: _col0
@@ -364,7 +372,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -372,10 +380,14 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
File Output Operator
compressed: false
GlobalTableId: 0
@@ -389,10 +401,10 @@ STAGE PLANS:
limit: -1
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b) from stats_tbl_part
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -439,7 +451,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -470,6 +482,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -479,7 +493,7 @@ STAGE PLANS:
expr: min(b)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Reduce Output Operator
sort order:
tag: -1
@@ -489,7 +503,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -497,23 +511,29 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
+ expr: max(VALUE._col8)
+ expr: min(VALUE._col9)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
Select Operator
expressions:
expr: _col0
@@ -521,7 +541,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -529,10 +549,14 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
+ expr: _col8
+ type: int
+ expr: _col9
+ type: bigint
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
File Output Operator
compressed: false
GlobalTableId: 0
@@ -760,10 +784,10 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -810,7 +834,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -845,6 +869,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -856,7 +882,7 @@ STAGE PLANS:
expr: min(d)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Reduce Output Operator
sort order:
tag: -1
@@ -866,7 +892,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -874,29 +900,35 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
expr: _col8
- type: float
+ type: int
expr: _col9
+ type: bigint
+ expr: _col10
+ type: float
+ expr: _col11
type: double
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
expr: max(VALUE._col8)
expr: min(VALUE._col9)
+ expr: max(VALUE._col10)
+ expr: min(VALUE._col11)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Select Operator
expressions:
expr: _col0
@@ -904,7 +936,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -912,14 +944,18 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
expr: _col8
- type: float
+ type: int
expr: _col9
+ type: bigint
+ expr: _col10
+ type: float
+ expr: _col11
type: double
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
File Output Operator
compressed: false
GlobalTableId: 0
@@ -932,11 +968,11 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
PREHOOK: type: QUERY
PREHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_tbl
#### A masked pattern was here ####
@@ -984,12 +1020,12 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).si SIMPLE [(over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
-9999 9999 9999 9999 9999 9999 65791 4294967296 99.98 0.01
+9999 9999 1999.8000000003176 9999 9999 9999 9999 9999 65791 4294967296 99.98 0.01
PREHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
POSTHOOK: type: QUERY
POSTHOOK: Lineage: stats_tbl.b SIMPLE [(over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), ]
POSTHOOK: Lineage: stats_tbl.bin SIMPLE [(over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), ]
@@ -1036,7 +1072,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME stats_tbl_part))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTIONSTAR count)) (TOK_SELEXPR (TOK_FUNCTION sum 1)) (TOK_SELEXPR (TOK_FUNCTION sum 0.2)) (TOK_SELEXPR (TOK_FUNCTION count 1)) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL s))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bo))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL bin))) (TOK_SELEXPR (TOK_FUNCTION count (TOK_TABLE_OR_COL si))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL i))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL b))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_TABLE_OR_COL f))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_TABLE_OR_COL d))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1071,6 +1107,8 @@ STAGE PLANS:
Group By Operator
aggregations:
expr: count()
+ expr: sum(1)
+ expr: sum(0.2)
expr: count(1)
expr: count(s)
expr: count(bo)
@@ -1082,7 +1120,7 @@ STAGE PLANS:
expr: min(d)
bucketGroup: false
mode: hash
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Reduce Output Operator
sort order:
tag: -1
@@ -1092,7 +1130,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -1100,29 +1138,35 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
expr: _col8
- type: float
+ type: int
expr: _col9
+ type: bigint
+ expr: _col10
+ type: float
+ expr: _col11
type: double
Reduce Operator Tree:
Group By Operator
aggregations:
expr: count(VALUE._col0)
- expr: count(VALUE._col1)
- expr: count(VALUE._col2)
+ expr: sum(VALUE._col1)
+ expr: sum(VALUE._col2)
expr: count(VALUE._col3)
expr: count(VALUE._col4)
expr: count(VALUE._col5)
- expr: max(VALUE._col6)
- expr: min(VALUE._col7)
+ expr: count(VALUE._col6)
+ expr: count(VALUE._col7)
expr: max(VALUE._col8)
expr: min(VALUE._col9)
+ expr: max(VALUE._col10)
+ expr: min(VALUE._col11)
bucketGroup: false
mode: mergepartial
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
Select Operator
expressions:
expr: _col0
@@ -1130,7 +1174,7 @@ STAGE PLANS:
expr: _col1
type: bigint
expr: _col2
- type: bigint
+ type: double
expr: _col3
type: bigint
expr: _col4
@@ -1138,14 +1182,18 @@ STAGE PLANS:
expr: _col5
type: bigint
expr: _col6
- type: int
+ type: bigint
expr: _col7
type: bigint
expr: _col8
- type: float
+ type: int
expr: _col9
+ type: bigint
+ expr: _col10
+ type: float
+ expr: _col11
type: double
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11
File Output Operator
compressed: false
GlobalTableId: 0
@@ -1158,14 +1206,14 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+PREHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
PREHOOK: type: QUERY
PREHOOK: Input: default@stats_tbl_part
PREHOOK: Input: default@stats_tbl_part@dt=2010
PREHOOK: Input: default@stats_tbl_part@dt=2011
PREHOOK: Input: default@stats_tbl_part@dt=2012
#### A masked pattern was here ####
-POSTHOOK: query: select count(*), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
+POSTHOOK: query: select count(*), sum(1), sum(0.2), count(1), count(s), count(bo), count(bin), count(si), max(i), min(b), max(f), min(d) from stats_tbl_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@stats_tbl_part
POSTHOOK: Input: default@stats_tbl_part@dt=2010
@@ -1216,7 +1264,7 @@ POSTHOOK: Lineage: stats_tbl_part PARTIT
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).si SIMPLE [(over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).t SIMPLE [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), ]
POSTHOOK: Lineage: stats_tbl_part PARTITION(dt=2012).ts SIMPLE [(over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), ]
-9489 9489 9489 9489 9489 9489 65791 4294967296 99.98 0.01
+9489 9489 1897.8000000002944 9489 9489 9489 9489 9489 65791 4294967296 99.98 0.01
PREHOOK: query: explain select count(ts) from stats_tbl_part
PREHOOK: type: QUERY
POSTHOOK: query: explain select count(ts) from stats_tbl_part