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/02/14 11:53:39 UTC
svn commit: r1568236 [20/25] - in /hive/branches/tez: ./ bin/
cli/src/java/org/apache/hadoop/hive/cli/
cli/src/test/org/apache/hadoop/hive/cli/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/ conf/ data/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out Fri Feb 14 10:53:31 2014
@@ -181,7 +181,31 @@ POSTHOOK: type: QUERY
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL ds) '1') (= (TOK_TABLE_OR_COL x) 484)))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ and
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ =
+ TOK_TABLE_OR_COL
+ x
+ 484
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -190,34 +214,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 484)
- type: boolean
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (x = 484) (type: boolean)
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: _col0
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -311,7 +326,31 @@ POSTHOOK: type: QUERY
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL ds) '1') (= (TOK_TABLE_OR_COL x) 495)))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ and
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ =
+ TOK_TABLE_OR_COL
+ x
+ 495
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -320,34 +359,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 495)
- type: boolean
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (x = 495) (type: boolean)
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: _col0
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -437,7 +467,31 @@ POSTHOOK: type: QUERY
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL ds) '1') (= (TOK_TABLE_OR_COL x) 1)))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ and
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ =
+ TOK_TABLE_OR_COL
+ x
+ 1
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -446,34 +500,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 1)
- type: boolean
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (x = 1) (type: boolean)
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: _col0
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Fri Feb 14 10:53:31 2014
@@ -201,7 +201,43 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '1')))) subq)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (= (TOK_TABLE_OR_COL x) 484))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_SUBQUERY
+ TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ subq
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ x
+ 484
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -210,34 +246,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- subq:fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 484)
- type: boolean
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (x = 484) (type: boolean)
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: _col0
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -335,7 +362,58 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x) x1) (TOK_SELEXPR (TOK_TABLE_OR_COL y) y1)) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '1')))) subq)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x1)) (TOK_SELEXPR (TOK_TABLE_OR_COL y1))) (TOK_WHERE (= (TOK_TABLE_OR_COL x1) 484)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL x1)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL y1)))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_SUBQUERY
+ TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ x1
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ y
+ y1
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ subq
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x1
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ y1
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ x1
+ 484
+ TOK_ORDERBY
+ TOK_TABSORTCOLNAMEASC
+ TOK_TABLE_OR_COL
+ x1
+ TOK_TABSORTCOLNAMEASC
+ TOK_TABLE_OR_COL
+ y1
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -344,44 +422,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- subq:fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 0 dataSize: 24 basicStatsState: PARTIAL colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 24 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 484)
- type: boolean
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ predicate: (x = 484) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
- expr: y
- type: string
+ expressions: x (type: int), y (type: string)
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
+ key expressions: _col0 (type: int), _col1 (type: string)
sort order: ++
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
+ value expressions: _col0 (type: int), _col1 (type: string)
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -432,15 +491,13 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -491,7 +548,38 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL y)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL ds) '1') (= (TOK_TABLE_OR_COL x) 484))) (TOK_GROUPBY (TOK_TABLE_OR_COL y))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ y
+ TOK_SELEXPR
+ TOK_FUNCTION
+ count
+ 1
+ TOK_WHERE
+ and
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ =
+ TOK_TABLE_OR_COL
+ x
+ 484
+ TOK_GROUPBY
+ TOK_TABLE_OR_COL
+ y
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -500,52 +588,32 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 0 dataSize: 24 basicStatsState: PARTIAL colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 24 Basic stats: PARTIAL Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 484)
- type: boolean
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ predicate: (x = 484) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions:
- expr: y
- type: string
+ expressions: y (type: string)
outputColumnNames: y
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- keys:
- expr: y
- type: string
+ aggregations: count(1)
+ keys: y (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
+ key expressions: _col0 (type: string)
sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Map-reduce partition columns: _col0 (type: string)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ value expressions: _col1 (type: bigint)
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -596,32 +664,21 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
- aggregations:
- expr: count(VALUE._col0)
- bucketGroup: false
- keys:
- expr: KEY._col0
- type: string
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: bigint
+ expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -672,7 +729,54 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x)) (TOK_SELEXPR (TOK_FUNCTION count 1) c)) (TOK_WHERE (= (TOK_TABLE_OR_COL ds) '1')) (TOK_GROUPBY (TOK_TABLE_OR_COL x)))) subq)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x)) (TOK_SELEXPR (TOK_TABLE_OR_COL c))) (TOK_WHERE (= (TOK_TABLE_OR_COL x) 484))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_SUBQUERY
+ TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_SELEXPR
+ TOK_FUNCTION
+ count
+ 1
+ c
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ TOK_GROUPBY
+ TOK_TABLE_OR_COL
+ x
+ subq
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ c
+ TOK_WHERE
+ =
+ TOK_TABLE_OR_COL
+ x
+ 484
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -681,52 +785,32 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- subq:fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (x = 484)
- type: boolean
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (x = 484) (type: boolean)
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: x
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations:
- expr: count(1)
- bucketGroup: false
- keys:
- expr: x
- type: int
+ aggregations: count(1)
+ keys: x (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
+ key expressions: _col0 (type: int)
sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: int
- Statistics:
- numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE
+ Map-reduce partition columns: _col0 (type: int)
+ Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: NONE
tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ value expressions: _col1 (type: bigint)
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -777,32 +861,21 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
- aggregations:
- expr: count(VALUE._col0)
- bucketGroup: false
- keys:
- expr: KEY._col0
- type: int
+ aggregations: count(VALUE._col0)
+ keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col1
- type: bigint
+ expressions: _col0 (type: int), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out Fri Feb 14 10:53:31 2014
@@ -265,7 +265,36 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).z SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME fact_daily))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL x))) (TOK_WHERE (and (= (TOK_TABLE_OR_COL ds) '1') (not (= (TOK_TABLE_OR_COL x) 86)))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL x)))))
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ fact_daily
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_TABLE_OR_COL
+ x
+ TOK_WHERE
+ and
+ =
+ TOK_TABLE_OR_COL
+ ds
+ '1'
+ not
+ =
+ TOK_TABLE_OR_COL
+ x
+ 86
+ TOK_ORDERBY
+ TOK_TABSORTCOLNAMEASC
+ TOK_TABLE_OR_COL
+ x
+
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -274,38 +303,25 @@ STAGE DEPENDENCIES:
STAGE PLANS:
Stage: Stage-1
Map Reduce
- Alias -> Map Operator Tree:
- fact_daily
+ Map Operator Tree:
TableScan
alias: fact_daily
- Statistics:
- numRows: 29 dataSize: 117 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 29 Data size: 117 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate:
- expr: (not (x = 86))
- type: boolean
- Statistics:
- numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
+ predicate: (not (x = 86)) (type: boolean)
+ Statistics: Num rows: 15 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions:
- expr: x
- type: int
+ expressions: x (type: int)
outputColumnNames: _col0
- Statistics:
- numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 15 Data size: 60 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
- key expressions:
- expr: _col0
- type: int
+ key expressions: _col0 (type: int)
sort order: +
- Statistics:
- numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 15 Data size: 60 Basic stats: COMPLETE Column stats: NONE
tag: -1
- value expressions:
- expr: _col0
- type: int
+ value expressions: _col0 (type: int)
Path -> Alias:
#### A masked pattern was here ####
Path -> Partition:
@@ -442,15 +458,13 @@ STAGE PLANS:
Needs Tagging: false
Reduce Operator Tree:
Extract
- Statistics:
- numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 15 Data size: 60 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
GlobalTableId: 0
#### A masked pattern was here ####
NumFilesPerFileSink: 1
- Statistics:
- numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE
+ Statistics: Num rows: 15 Data size: 60 Basic stats: COMPLETE Column stats: NONE
#### A masked pattern was here ####
table:
input format: org.apache.hadoop.mapred.TextInputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Fri Feb 14 10:53:31 2014
@@ -494,7 +494,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_pred
- filterExpr:
+ filterExpr: ((t is not null and (t < 0)) and (t > (- 2))) (type: boolean)
Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: ((t is not null and (t < 0)) and (t > (- 2))) (type: boolean)
@@ -686,7 +686,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_pred
- filterExpr:
+ filterExpr: (((t = (- 1)) and s is not null) and (s like 'bob%')) (type: boolean)
Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((t = (- 1)) and s is not null) and (s like 'bob%')) (type: boolean)
@@ -877,7 +877,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_pred
- filterExpr:
+ filterExpr: (((s is not null and (s like 'bob%')) and (not (t) IN ((- 1), (- 2), (- 3)))) and t BETWEEN 25 AND 30) (type: boolean)
Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((s is not null and (s like 'bob%')) and (not (t) IN ((- 1), (- 2), (- 3)))) and t BETWEEN 25 AND 30) (type: boolean)
@@ -1103,7 +1103,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_pred
- filterExpr:
+ filterExpr: (((((((d >= round(9.99)) and (d < 12.0)) and t is not null) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((((((d >= round(9.99)) and (d < 12.0)) and t is not null) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
@@ -1368,7 +1368,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: orc_pred
- filterExpr:
+ filterExpr: (((((((((t > 10) and (t <> 101)) and (d >= round(9.99))) and (d < 12.0)) and t is not null) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (((((((((t > 10) and (t <> 101)) and (d >= round(9.99))) and (d < 12.0)) and t is not null) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out Fri Feb 14 10:53:31 2014
@@ -261,23 +261,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default__lineitem_lineitem_lshipdate_idx__
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string), _count_of_l_shipdate (type: bigint)
outputColumnNames: l_shipdate, _count_of_l_shipdate
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_l_shipdate)
bucketGroup: true
keys: l_shipdate (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -285,14 +285,14 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -597,22 +597,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default__lineitem_lineitem_lshipdate_idx__
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string), _count_of_l_shipdate (type: bigint)
outputColumnNames: l_shipdate, _count_of_l_shipdate
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_l_shipdate)
keys: year(l_shipdate) (type: int), month(l_shipdate) (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: int)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -620,11 +620,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -639,14 +639,14 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: int)
sort order: ++
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint)
Reduce Operator Tree:
Extract
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -777,25 +777,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lastyear:default__lineitem_lineitem_lshipdate_idx__
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (year(l_shipdate) = 1997) (type: boolean)
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string), _count_of_l_shipdate (type: bigint)
outputColumnNames: l_shipdate, _count_of_l_shipdate
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_l_shipdate)
keys: year(l_shipdate) (type: int), month(l_shipdate) (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: int)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -803,11 +803,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col2 (type: bigint)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -823,14 +823,14 @@ STAGE PLANS:
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: bigint)
TableScan
Reduce Output Operator
key expressions: _col1 (type: int)
sort order: +
Map-reduce partition columns: _col1 (type: int)
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: bigint)
Reduce Operator Tree:
Join Operator
@@ -840,14 +840,14 @@ STAGE PLANS:
0 {VALUE._col1} {VALUE._col2}
1 {VALUE._col1} {VALUE._col2}
outputColumnNames: _col1, _col2, _col4, _col5
- Statistics: Num rows: 25 Data size: 2966 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2308 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col4 (type: int), ((_col5 - _col2) / _col2) (type: decimal(38,19))
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 25 Data size: 2966 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2308 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 25 Data size: 2966 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 25 Data size: 2308 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -858,25 +858,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: thisyear:default__lineitem_lineitem_lshipdate_idx__
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (year(l_shipdate) = 1998) (type: boolean)
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string), _count_of_l_shipdate (type: bigint)
outputColumnNames: l_shipdate, _count_of_l_shipdate
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_l_shipdate)
keys: year(l_shipdate) (type: int), month(l_shipdate) (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: int)
sort order: ++
Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
value expressions: _col2 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -884,11 +884,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int), KEY._col1 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col2 (type: bigint)
outputColumnNames: _col1, _col2
- Statistics: Num rows: 23 Data size: 2697 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 23 Data size: 2099 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -927,23 +927,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: null-subquery1:default__lineitem_lineitem_lshipdate_idx__
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: l_shipdate (type: string), _count_of_l_shipdate (type: bigint)
outputColumnNames: l_shipdate, _count_of_l_shipdate
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_l_shipdate)
bucketGroup: true
keys: l_shipdate (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 95 Data size: 11145 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 95 Data size: 8675 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -951,11 +951,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 47 Data size: 5513 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 47 Data size: 4291 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -968,14 +968,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Union
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -988,14 +988,14 @@ STAGE PLANS:
outputColumnNames: _col0, _col1
Statistics: Num rows: 116 Data size: 12099 Basic stats: COMPLETE Column stats: NONE
Union
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 163 Data size: 17612 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 163 Data size: 16390 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -3204,23 +3204,23 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default__tbl_tbl_key_idx__
- Statistics: Num rows: 6 Data size: 586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 430 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), _count_of_key (type: bigint)
outputColumnNames: key, _count_of_key
- Statistics: Num rows: 6 Data size: 586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 430 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(_count_of_key)
bucketGroup: true
keys: key (type: int)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 6 Data size: 586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 430 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
- Statistics: Num rows: 6 Data size: 586 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 430 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: bigint)
Reduce Operator Tree:
Group By Operator
@@ -3228,11 +3228,11 @@ STAGE PLANS:
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 293 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 215 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3 Data size: 293 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 215 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
table:
@@ -3247,14 +3247,14 @@ STAGE PLANS:
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 3 Data size: 293 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 215 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: int), _col1 (type: bigint)
Reduce Operator Tree:
Extract
- Statistics: Num rows: 3 Data size: 293 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 215 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3 Data size: 293 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3 Data size: 215 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/tez/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out?rev=1568236&r1=1568235&r2=1568236&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out Fri Feb 14 10:53:31 2014
@@ -50,6 +50,7 @@ covar_pop
covar_samp
create_union
cume_dist
+current_database
date_add
date_sub
datediff
@@ -218,6 +219,7 @@ covar_pop
covar_samp
create_union
cume_dist
+current_database
PREHOOK: query: SHOW FUNCTIONS '.*e$'
PREHOOK: type: SHOWFUNCTIONS
POSTHOOK: query: SHOW FUNCTIONS '.*e$'
@@ -225,6 +227,7 @@ POSTHOOK: type: SHOWFUNCTIONS
assert_true
case
coalesce
+current_database
decode
e
encode