http://git-wip-us.apache.org/repos/asf/hive/blob/99380fbd/ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out b/ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out deleted file mode 100644 index cc6a405..0000000 --- a/ql/src/test/results/clientpositive/show_indexes_edge_cases.q.out +++ /dev/null @@ -1,175 +0,0 @@ -PREHOOK: query: DROP TABLE show_idx_empty -PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE show_idx_empty -POSTHOOK: type: DROPTABLE -PREHOOK: query: DROP TABLE show_idx_full -PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE show_idx_full -POSTHOOK: type: DROPTABLE -PREHOOK: query: CREATE TABLE show_idx_empty(KEY STRING, VALUE STRING) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@show_idx_empty -POSTHOOK: query: CREATE TABLE show_idx_empty(KEY STRING, VALUE STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@show_idx_empty -PREHOOK: query: CREATE TABLE show_idx_full(KEY STRING, VALUE1 STRING, VALUE2 STRING) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@show_idx_full -POSTHOOK: query: CREATE TABLE show_idx_full(KEY STRING, VALUE1 STRING, VALUE2 STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@show_idx_full -PREHOOK: query: CREATE INDEX idx_1 ON TABLE show_idx_full(KEY) AS "COMPACT" WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: CREATE INDEX idx_1 ON TABLE show_idx_full(KEY) AS "COMPACT" WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_1__ -PREHOOK: query: CREATE INDEX idx_2 ON TABLE show_idx_full(VALUE1) AS "COMPACT" WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: CREATE INDEX idx_2 ON TABLE show_idx_full(VALUE1) AS "COMPACT" WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_2__ -PREHOOK: query: CREATE INDEX idx_comment ON TABLE show_idx_full(VALUE2) AS "COMPACT" WITH DEFERRED REBUILD COMMENT "index comment" -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: CREATE INDEX idx_comment ON TABLE show_idx_full(VALUE2) AS "COMPACT" WITH DEFERRED REBUILD COMMENT "index comment" -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_comment__ -PREHOOK: query: CREATE INDEX idx_compound ON TABLE show_idx_full(KEY, VALUE1) AS "COMPACT" WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: CREATE INDEX idx_compound ON TABLE show_idx_full(KEY, VALUE1) AS "COMPACT" WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_compound__ -PREHOOK: query: ALTER INDEX idx_1 ON show_idx_full REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@show_idx_full -PREHOOK: Output: default@default__show_idx_full_idx_1__ -POSTHOOK: query: ALTER INDEX idx_1 ON show_idx_full REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_1__ -POSTHOOK: Lineage: default__show_idx_full_idx_1__._bucketname SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_1__._offsets EXPRESSION [(show_idx_full)show_idx_full.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_1__.key SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:key, type:string, comment:null), ] -PREHOOK: query: ALTER INDEX idx_2 ON show_idx_full REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@show_idx_full -PREHOOK: Output: default@default__show_idx_full_idx_2__ -POSTHOOK: query: ALTER INDEX idx_2 ON show_idx_full REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_2__ -POSTHOOK: Lineage: default__show_idx_full_idx_2__._bucketname SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_2__._offsets EXPRESSION [(show_idx_full)show_idx_full.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_2__.value1 SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:value1, type:string, comment:null), ] -PREHOOK: query: ALTER INDEX idx_comment ON show_idx_full REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@show_idx_full -PREHOOK: Output: default@default__show_idx_full_idx_comment__ -POSTHOOK: query: ALTER INDEX idx_comment ON show_idx_full REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_comment__ -POSTHOOK: Lineage: default__show_idx_full_idx_comment__._bucketname SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_comment__._offsets EXPRESSION [(show_idx_full)show_idx_full.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_comment__.value2 SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:value2, type:string, comment:null), ] -PREHOOK: query: ALTER INDEX idx_compound ON show_idx_full REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@show_idx_full -PREHOOK: Output: default@default__show_idx_full_idx_compound__ -POSTHOOK: query: ALTER INDEX idx_compound ON show_idx_full REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@default__show_idx_full_idx_compound__ -POSTHOOK: Lineage: default__show_idx_full_idx_compound__._bucketname SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_compound__._offsets EXPRESSION [(show_idx_full)show_idx_full.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__show_idx_full_idx_compound__.key SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: default__show_idx_full_idx_compound__.value1 SIMPLE [(show_idx_full)show_idx_full.FieldSchema(name:value1, type:string, comment:null), ] -PREHOOK: query: EXPLAIN SHOW INDEXES ON show_idx_full -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: EXPLAIN SHOW INDEXES ON show_idx_full -POSTHOOK: type: SHOWINDEXES -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Show Index Operator: - Show Indexes - - Stage: Stage-1 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SHOW INDEXES ON show_idx_full -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW INDEXES ON show_idx_full -POSTHOOK: type: SHOWINDEXES -idx_1 show_idx_full key default__show_idx_full_idx_1__ compact -idx_2 show_idx_full value1 default__show_idx_full_idx_2__ compact -idx_comment show_idx_full value2 default__show_idx_full_idx_comment__ compact index comment -idx_compound show_idx_full key, value1 default__show_idx_full_idx_compound__ compact -PREHOOK: query: EXPLAIN SHOW INDEXES ON show_idx_empty -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: EXPLAIN SHOW INDEXES ON show_idx_empty -POSTHOOK: type: SHOWINDEXES -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Show Index Operator: - Show Indexes - - Stage: Stage-1 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SHOW INDEXES ON show_idx_empty -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW INDEXES ON show_idx_empty -POSTHOOK: type: SHOWINDEXES -PREHOOK: query: DROP INDEX idx_1 on show_idx_full -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: DROP INDEX idx_1 on show_idx_full -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@show_idx_full -PREHOOK: query: DROP INDEX idx_2 on show_idx_full -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@show_idx_full -POSTHOOK: query: DROP INDEX idx_2 on show_idx_full -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@show_idx_full -PREHOOK: query: DROP TABLE show_idx_empty -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@show_idx_empty -PREHOOK: Output: default@show_idx_empty -POSTHOOK: query: DROP TABLE show_idx_empty -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@show_idx_empty -POSTHOOK: Output: default@show_idx_empty -PREHOOK: query: DROP TABLE show_idx_full -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@show_idx_full -PREHOOK: Output: default@show_idx_full -POSTHOOK: query: DROP TABLE show_idx_full -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@show_idx_full -POSTHOOK: Output: default@show_idx_full
http://git-wip-us.apache.org/repos/asf/hive/blob/99380fbd/ql/src/test/results/clientpositive/show_indexes_syntax.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/show_indexes_syntax.q.out b/ql/src/test/results/clientpositive/show_indexes_syntax.q.out deleted file mode 100644 index bed97f0..0000000 --- a/ql/src/test/results/clientpositive/show_indexes_syntax.q.out +++ /dev/null @@ -1,117 +0,0 @@ -PREHOOK: query: DROP TABLE show_idx_t1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE show_idx_t1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: CREATE TABLE show_idx_t1(KEY STRING, VALUE STRING) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@show_idx_t1 -POSTHOOK: query: CREATE TABLE show_idx_t1(KEY STRING, VALUE STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@show_idx_t1 -PREHOOK: query: CREATE INDEX idx_t1 ON TABLE show_idx_t1(KEY) AS "COMPACT" WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@show_idx_t1 -POSTHOOK: query: CREATE INDEX idx_t1 ON TABLE show_idx_t1(KEY) AS "COMPACT" WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@show_idx_t1 -POSTHOOK: Output: default@default__show_idx_t1_idx_t1__ -PREHOOK: query: ALTER INDEX idx_t1 ON show_idx_t1 REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@show_idx_t1 -PREHOOK: Output: default@default__show_idx_t1_idx_t1__ -POSTHOOK: query: ALTER INDEX idx_t1 ON show_idx_t1 REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@show_idx_t1 -POSTHOOK: Output: default@default__show_idx_t1_idx_t1__ -POSTHOOK: Lineage: default__show_idx_t1_idx_t1__._bucketname SIMPLE [(show_idx_t1)show_idx_t1.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__show_idx_t1_idx_t1__._offsets EXPRESSION [(show_idx_t1)show_idx_t1.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__show_idx_t1_idx_t1__.key SIMPLE [(show_idx_t1)show_idx_t1.FieldSchema(name:key, type:string, comment:null), ] -PREHOOK: query: EXPLAIN -SHOW INDEX ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: EXPLAIN -SHOW INDEX ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Show Index Operator: - Show Indexes - - Stage: Stage-1 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SHOW INDEX ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW INDEX ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -idx_t1 show_idx_t1 key default__show_idx_t1_idx_t1__ compact -PREHOOK: query: EXPLAIN -SHOW INDEXES ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: EXPLAIN -SHOW INDEXES ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Show Index Operator: - Show Indexes - - Stage: Stage-1 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SHOW INDEXES ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW INDEXES ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -idx_t1 show_idx_t1 key default__show_idx_t1_idx_t1__ compact -PREHOOK: query: EXPLAIN -SHOW FORMATTED INDEXES ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: EXPLAIN -SHOW FORMATTED INDEXES ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Show Index Operator: - Show Indexes - - Stage: Stage-1 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SHOW FORMATTED INDEXES ON show_idx_t1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW FORMATTED INDEXES ON show_idx_t1 -POSTHOOK: type: SHOWINDEXES -idx_name tab_name col_names idx_tab_name idx_type comment -idx_t1 show_idx_t1 key default__show_idx_t1_idx_t1__ compact -PREHOOK: query: DROP TABLE show_idx_t1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@show_idx_t1 -PREHOOK: Output: default@show_idx_t1 -POSTHOOK: query: DROP TABLE show_idx_t1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@show_idx_t1 -POSTHOOK: Output: default@show_idx_t1 http://git-wip-us.apache.org/repos/asf/hive/blob/99380fbd/ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out b/ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out deleted file mode 100644 index e0a701b..0000000 --- a/ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out +++ /dev/null @@ -1,225 +0,0 @@ -PREHOOK: query: EXPLAIN SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Spark - Edges: - Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 2), Map 3 (PARTITION-LEVEL SORT, 2) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) > 80.0) and value is not null) (type: boolean) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: string) - sort order: + - Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string) - Map 3 - Map Operator Tree: - TableScan - alias: b - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0) and value is not null) (type: boolean) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: string) - sort order: + - Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string) - Reducer 2 - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col1 (type: string) - 1 _col1 (type: string) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col2 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -82 82 -83 83 -83 83 -83 83 -83 83 -84 84 -84 84 -84 84 -84 84 -85 85 -86 86 -87 87 -PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src_index__ -PREHOOK: query: ALTER INDEX src_index ON src REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@src -PREHOOK: Output: default@default__src_src_index__ -POSTHOOK: query: ALTER INDEX src_index ON src REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src_index__ -POSTHOOK: Lineage: default__src_src_index__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -PREHOOK: query: EXPLAIN SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Spark - Edges: - Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 2), Map 3 (PARTITION-LEVEL SORT, 2) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: a - filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0) and value is not null) (type: boolean) - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) > 80.0) and value is not null) (type: boolean) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: string) - sort order: + - Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string) - Map 3 - Map Operator Tree: - TableScan - alias: b - filterExpr: ((UDFToDouble(key) > 70.0) and (UDFToDouble(key) < 90.0) and value is not null) (type: boolean) - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 70.0) and value is not null) (type: boolean) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: string) - sort order: + - Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string) - Reducer 2 - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col1 (type: string) - 1 _col1 (type: string) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col2 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT a.key, b.key FROM src a JOIN src b ON (a.value = b.value) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -82 82 -83 83 -83 83 -83 83 -83 83 -84 84 -84 84 -84 84 -84 84 -85 85 -86 86 -87 87 -PREHOOK: query: DROP INDEX src_index on src -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@src -POSTHOOK: query: DROP INDEX src_index on src -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@src