http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/bucketpruning1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/bucketpruning1.q.out
b/ql/src/test/results/clientpositive/bucketpruning1.q.out
deleted file mode 100644
index 22477d4..0000000
--- a/ql/src/test/results/clientpositive/bucketpruning1.q.out
+++ /dev/null
@@ -1,2282 +0,0 @@
-PREHOOK: query: CREATE TABLE srcbucket_pruned(key int, value string)
partitioned by (ds string) CLUSTERED BY (key) INTO 16 BUCKETS STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@srcbucket_pruned
-POSTHOOK: query: CREATE TABLE srcbucket_pruned(key int, value string)
partitioned by (ds string) CLUSTERED BY (key) INTO 16 BUCKETS STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@srcbucket_pruned
-PREHOOK: query: -- cannot prune 2-key scenarios without a smarter optimizer
-CREATE TABLE srcbucket_unpruned(key int, value string) partitioned by (ds
string) CLUSTERED BY (key,value) INTO 16 BUCKETS STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@srcbucket_unpruned
-POSTHOOK: query: -- cannot prune 2-key scenarios without a smarter optimizer
-CREATE TABLE srcbucket_unpruned(key int, value string) partitioned by (ds
string) CLUSTERED BY (key,value) INTO 16 BUCKETS STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@srcbucket_unpruned
-PREHOOK: query: -- good cases
-
-explain extended
-select * from srcbucket_pruned where key = 1
-PREHOOK: type: QUERY
-POSTHOOK: query: -- good cases
-
-explain extended
-select * from srcbucket_pruned where key = 1
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- 1
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key = 1) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 1) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 16
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 16
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- 16
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key = 16) (type: boolean)
- buckets included: [0,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 16) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 16 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 17
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 17
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- 17
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key = 17) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 17) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 17 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 16+1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 16+1
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- +
- 16
- 1
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key = 17) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 17) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 17 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = '11'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = '11'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- '11'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key = 11) (type: boolean)
- buckets included: [11,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 11) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 11 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key = 1) and (ds = '2008-04-08')) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key = 1) and (ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), value (type: string), '2008-04-08'
(type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and
value='One'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and
value='One'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
- =
- TOK_TABLE_OR_COL
- value
- 'One'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key = 1) and (ds = '2008-04-08')) and (value =
'One')) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key = 1) and (ds = '2008-04-08')) and (value =
'One')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), 'One' (type: string), '2008-04-08'
(type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key = 1 and
ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key = 1 and
ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- =
- TOK_TABLE_OR_COL
- value
- 'One'
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((value = 'One') and (key = 1)) and (ds =
'2008-04-08')) (type: boolean)
- buckets included: [1,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((value = 'One') and (key = 1)) and (ds =
'2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), 'One' (type: string), '2008-04-08'
(type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3)
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3)
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 2
- 3
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key) IN (2, 3) (type: boolean)
- buckets included: [2,3,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key) IN (2, 3) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 2
- 3
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key) IN (2, 3) and (ds = '2008-04-08')) (type:
boolean)
- buckets included: [2,3,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key) IN (2, 3) and (ds = '2008-04-08')) (type:
boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and
value='One'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key in (2,3) and ds='2008-04-08' and
value='One'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 2
- 3
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
- =
- TOK_TABLE_OR_COL
- value
- 'One'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key) IN (2, 3) and (ds = '2008-04-08')) and (value
= 'One')) (type: boolean)
- buckets included: [2,3,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key) IN (2, 3) and (ds = '2008-04-08')) and (value
= 'One')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), 'One' (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key in (2,3) and
ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key in (2,3) and
ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- =
- TOK_TABLE_OR_COL
- value
- 'One'
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 2
- 3
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((value = 'One') and (key) IN (2, 3)) and (ds =
'2008-04-08')) (type: boolean)
- buckets included: [2,3,] of 16
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((value = 'One') and (key) IN (2, 3)) and (ds =
'2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), 'One' (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where (key=1 or key=2) and ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- or
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- key
- 2
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key = 1) or (key = 2)) and (ds = '2008-04-08'))
(type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key = 1) or (key = 2)) and (ds = '2008-04-08'))
(type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and
ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where (key=1 or key=2) and value = 'One' and
ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- or
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- key
- 2
- =
- TOK_TABLE_OR_COL
- value
- 'One'
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((((key = 1) or (key = 2)) and (value = 'One')) and
(ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((((key = 1) or (key = 2)) and (value = 'One')) and
(ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), 'One' (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: -- valid but irrelevant case (all buckets selected)
-
-explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17)
-PREHOOK: type: QUERY
-POSTHOOK: query: -- valid but irrelevant case (all buckets selected)
-
-explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17)
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17) and (ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17) and (ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08' and value='One'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
- =
- TOK_TABLE_OR_COL
- value
- 'One'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17) and (ds = '2008-04-08')) and (value = 'One')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key) IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12,
13, 14, 15, 16, 17) and (ds = '2008-04-08')) and (value = 'One')) (type:
boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), 'One' (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where value='One' and key in
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) and ds='2008-04-08'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- =
- TOK_TABLE_OR_COL
- value
- 'One'
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((value = 'One') and (key) IN (1, 2, 3, 4, 5, 6, 7,
8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) and (ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((value = 'One') and (key) IN (1, 2, 3, 4, 5, 6, 7,
8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) and (ds = '2008-04-08')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), 'One' (type: string),
'2008-04-08' (type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: -- valid, but unimplemented cases
-
-explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2
-PREHOOK: type: QUERY
-POSTHOOK: query: -- valid, but unimplemented cases
-
-explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' or key = 2
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- or
- and
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
- =
- TOK_TABLE_OR_COL
- key
- 2
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key = 1) and (ds = '2008-04-08')) or (key = 2))
(type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key = 1) and (ds = '2008-04-08')) or (key = 2))
(type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and
(value='One' or value = 'Two')
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 and ds='2008-04-08' and
(value='One' or value = 'Two')
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- and
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- ds
- '2008-04-08'
- or
- =
- TOK_TABLE_OR_COL
- value
- 'One'
- =
- TOK_TABLE_OR_COL
- value
- 'Two'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: (((key = 1) and (ds = '2008-04-08')) and ((value =
'One') or (value = 'Two'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (((key = 1) and (ds = '2008-04-08')) and ((value =
'One') or (value = 'Two'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), value (type: string), '2008-04-08'
(type: string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and
value = "Two"
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One" or key = 2 and
value = "Two"
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- or
- or
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- value
- "One"
- and
- =
- TOK_TABLE_OR_COL
- key
- 2
- =
- TOK_TABLE_OR_COL
- value
- "Two"
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key = 1) or (value = 'One') or ((key = 2) and (value
= 'Two'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key = 1) or (value = 'One') or ((key = 2) and
(value = 'Two'))) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: -- Invalid cases
-
-explain extended
-select * from srcbucket_pruned where key = 'x11'
-PREHOOK: type: QUERY
-POSTHOOK: query: -- Invalid cases
-
-explain extended
-select * from srcbucket_pruned where key = 'x11'
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- 'x11'
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One"
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One"
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- or
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- value
- "One"
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key = 1) or (value = 'One')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key = 1) or (value = 'One')) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One" or key = 2
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_pruned where key = 1 or value = "One" or key = 2
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_pruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- or
- or
- =
- TOK_TABLE_OR_COL
- key
- 1
- =
- TOK_TABLE_OR_COL
- value
- "One"
- =
- TOK_TABLE_OR_COL
- key
- 2
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_pruned
- filterExpr: ((key = 1) or (value = 'One') or (key = 2)) (type:
boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: ((key = 1) or (value = 'One') or (key = 2)) (type:
boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_unpruned where key in (3, 5)
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_unpruned where key in (3, 5)
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_unpruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- TOK_FUNCTION
- in
- TOK_TABLE_OR_COL
- key
- 3
- 5
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_unpruned
- filterExpr: (key) IN (3, 5) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key) IN (3, 5) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: key (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: explain extended
-select * from srcbucket_unpruned where key = 1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain extended
-select * from srcbucket_unpruned where key = 1
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcbucket_unpruned
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- TOK_TABLE_OR_COL
- key
- 1
-
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: srcbucket_unpruned
- filterExpr: (key = 1) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- GatherStats: false
- Filter Operator
- isSamplingPred: false
- predicate: (key = 1) (type: boolean)
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column
stats: NONE
- Select Operator
- expressions: 1 (type: int), value (type: string), ds (type:
string)
- outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
Column stats: NONE
-#### A masked pattern was here ####
- table:
- input format:
org.apache.hadoop.mapred.SequenceFileInputFormat
- output format:
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- properties:
- columns _col0,_col1,_col2
- columns.types int:string:string
- escape.delim \
- hive.serialization.extend.additional.nesting.levels
true
- serialization.escape.crlf true
- serialization.format 1
- serialization.lib
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
