You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by kg...@apache.org on 2018/02/27 07:01:34 UTC
[4/9] hive git commit: HIVE-18759: Remove unconnected q.out-s (Zoltan
Haindrich reviewed by Ashutosh Chauhan)
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