http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/beeline/escape_comments.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/escape_comments.q.out b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out index 1b81d7c..43b9399 100644 --- a/ql/src/test/results/clientpositive/beeline/escape_comments.q.out +++ b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out @@ -36,13 +36,6 @@ POSTHOOK: Output: database:escape_comments_db POSTHOOK: Output: escape_comments_db@escape_comments_view1 POSTHOOK: Lineage: escape_comments_view1.col1 SIMPLE [(escape_comments_tbl1)escape_comments_tbl1.FieldSchema(name:col1, type:string, comment:a b';), ] -PREHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb' -PREHOOK: type: CREATEINDEX -PREHOOK: Input: escape_comments_db@escape_comments_tbl1 -POSTHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb' -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: escape_comments_db@escape_comments_tbl1 -POSTHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ PREHOOK: query: describe database extended escape_comments_db PREHOOK: type: DESCDATABASE PREHOOK: Input: database:escape_comments_db @@ -169,23 +162,15 @@ Sort Columns: [] NULL View Original Text: select col1 from escape_comments_tbl1 NULL View Expanded Text: SELECT `col1` AS `col1` FROM (select `escape_comments_tbl1`.`col1` from `escape_comments_db`.`escape_comments_tbl1`) `escape_comments_db.escape_comments_view1` NULL View Rewrite Enabled: No NULL -PREHOOK: query: show formatted index on escape_comments_tbl1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: show formatted index on escape_comments_tbl1 -POSTHOOK: type: SHOWINDEXES -idx_name tab_name col_names idx_tab_name idx_type comment -index2 escape_comments_tbl1 col1 escape_comments_db__escape_comments_tbl1_index2__ compact a\nb PREHOOK: query: drop database escape_comments_db cascade PREHOOK: type: DROPDATABASE PREHOOK: Input: database:escape_comments_db PREHOOK: Output: database:escape_comments_db -PREHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ PREHOOK: Output: escape_comments_db@escape_comments_tbl1 PREHOOK: Output: escape_comments_db@escape_comments_view1 POSTHOOK: query: drop database escape_comments_db cascade POSTHOOK: type: DROPDATABASE POSTHOOK: Input: database:escape_comments_db POSTHOOK: Output: database:escape_comments_db -POSTHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ POSTHOOK: Output: escape_comments_db@escape_comments_tbl1 POSTHOOK: Output: escape_comments_db@escape_comments_view1
http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/database_drop.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/database_drop.q.out b/ql/src/test/results/clientpositive/database_drop.q.out index 9059c38..dac2e97 100644 --- a/ql/src/test/results/clientpositive/database_drop.q.out +++ b/ql/src/test/results/clientpositive/database_drop.q.out @@ -45,24 +45,6 @@ POSTHOOK: Output: database:db5 POSTHOOK: Output: db5@temp_tbl_view POSTHOOK: Lineage: temp_tbl_view.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ] POSTHOOK: Lineage: temp_tbl_view.name SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:name, type:string, comment:null), ] -PREHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@temp_tbl -POSTHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@temp_tbl -POSTHOOK: Output: db5@db5__temp_tbl_idx1__ -PREHOOK: query: ALTER INDEX idx1 ON temp_tbl REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@temp_tbl -PREHOOK: Output: db5@db5__temp_tbl_idx1__ -POSTHOOK: query: ALTER INDEX idx1 ON temp_tbl REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@temp_tbl -POSTHOOK: Output: db5@db5__temp_tbl_idx1__ -POSTHOOK: Lineage: db5__temp_tbl_idx1__._bucketname SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__temp_tbl_idx1__._offsets EXPRESSION [(temp_tbl)temp_tbl.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__temp_tbl_idx1__.id SIMPLE [(temp_tbl)temp_tbl.FieldSchema(name:id, type:int, comment:null), ] #### A masked pattern was here #### PREHOOK: type: CREATETABLE #### A masked pattern was here #### @@ -93,25 +75,6 @@ POSTHOOK: Output: database:db5 POSTHOOK: Output: db5@temp_tbl2_view POSTHOOK: Lineage: temp_tbl2_view.id SIMPLE [(temp_tbl2)temp_tbl2.FieldSchema(name:id, type:int, comment:null), ] POSTHOOK: Lineage: temp_tbl2_view.name SIMPLE [(temp_tbl2)temp_tbl2.FieldSchema(name:name, type:string, comment:null), ] -#### A masked pattern was here #### -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@temp_tbl2 -#### A masked pattern was here #### -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@temp_tbl2 -POSTHOOK: Output: db5@db5__temp_tbl2_idx2__ -#### A masked pattern was here #### -PREHOOK: query: ALTER INDEX idx2 ON temp_tbl2 REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@temp_tbl2 -PREHOOK: Output: db5@db5__temp_tbl2_idx2__ -POSTHOOK: query: ALTER INDEX idx2 ON temp_tbl2 REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@temp_tbl2 -POSTHOOK: Output: db5@db5__temp_tbl2_idx2__ -POSTHOOK: Lineage: db5__temp_tbl2_idx2__._bucketname SIMPLE [(temp_tbl2)temp_tbl2.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__temp_tbl2_idx2__._offsets EXPRESSION [(temp_tbl2)temp_tbl2.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__temp_tbl2_idx2__.id SIMPLE [(temp_tbl2)temp_tbl2.FieldSchema(name:id, type:int, comment:null), ] PREHOOK: query: CREATE TABLE part_tab (id INT, name STRING) PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db5 @@ -138,39 +101,6 @@ POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: db5@part_tab POSTHOOK: Output: db5@part_tab@ds=2009-04-09 -PREHOOK: query: CREATE INDEX idx3 ON TABLE part_tab(id) AS 'COMPACT' with DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@part_tab -POSTHOOK: query: CREATE INDEX idx3 ON TABLE part_tab(id) AS 'COMPACT' with DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@part_tab -POSTHOOK: Output: db5@db5__part_tab_idx3__ -PREHOOK: query: ALTER INDEX idx3 ON part_tab PARTITION (ds='2008-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab -PREHOOK: Input: db5@part_tab@ds=2008-04-09 -PREHOOK: Output: db5@db5__part_tab_idx3__@ds=2008-04-09 -POSTHOOK: query: ALTER INDEX idx3 ON part_tab PARTITION (ds='2008-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab -POSTHOOK: Input: db5@part_tab@ds=2008-04-09 -POSTHOOK: Output: db5@db5__part_tab_idx3__@ds=2008-04-09 -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2008-04-09)._bucketname SIMPLE [(part_tab)part_tab.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2008-04-09)._offsets EXPRESSION [(part_tab)part_tab.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2008-04-09).id SIMPLE [(part_tab)part_tab.FieldSchema(name:id, type:int, comment:null), ] -PREHOOK: query: ALTER INDEX idx3 ON part_tab PARTITION (ds='2009-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab -PREHOOK: Input: db5@part_tab@ds=2009-04-09 -PREHOOK: Output: db5@db5__part_tab_idx3__@ds=2009-04-09 -POSTHOOK: query: ALTER INDEX idx3 ON part_tab PARTITION (ds='2009-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab -POSTHOOK: Input: db5@part_tab@ds=2009-04-09 -POSTHOOK: Output: db5@db5__part_tab_idx3__@ds=2009-04-09 -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2009-04-09)._bucketname SIMPLE [(part_tab)part_tab.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2009-04-09)._offsets EXPRESSION [(part_tab)part_tab.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab_idx3__ PARTITION(ds=2009-04-09).id SIMPLE [(part_tab)part_tab.FieldSchema(name:id, type:int, comment:null), ] PREHOOK: query: CREATE TABLE part_tab2 (id INT, name STRING) PARTITIONED BY (ds string) #### A masked pattern was here #### PREHOOK: type: CREATETABLE @@ -201,43 +131,6 @@ POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: db5@part_tab2 POSTHOOK: Output: db5@part_tab2@ds=2009-04-09 -PREHOOK: query: CREATE INDEX idx4 ON TABLE part_tab2(id) AS 'COMPACT' with DEFERRED REBUILD -#### A masked pattern was here #### -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@part_tab2 -#### A masked pattern was here #### -POSTHOOK: query: CREATE INDEX idx4 ON TABLE part_tab2(id) AS 'COMPACT' with DEFERRED REBUILD -#### A masked pattern was here #### -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@part_tab2 -POSTHOOK: Output: db5@db5__part_tab2_idx4__ -#### A masked pattern was here #### -PREHOOK: query: ALTER INDEX idx4 ON part_tab2 PARTITION (ds='2008-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab2 -PREHOOK: Input: db5@part_tab2@ds=2008-04-09 -PREHOOK: Output: db5@db5__part_tab2_idx4__@ds=2008-04-09 -POSTHOOK: query: ALTER INDEX idx4 ON part_tab2 PARTITION (ds='2008-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab2 -POSTHOOK: Input: db5@part_tab2@ds=2008-04-09 -POSTHOOK: Output: db5@db5__part_tab2_idx4__@ds=2008-04-09 -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2008-04-09)._bucketname SIMPLE [(part_tab2)part_tab2.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2008-04-09)._offsets EXPRESSION [(part_tab2)part_tab2.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2008-04-09).id SIMPLE [(part_tab2)part_tab2.FieldSchema(name:id, type:int, comment:null), ] -PREHOOK: query: ALTER INDEX idx4 ON part_tab2 PARTITION (ds='2009-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab2 -PREHOOK: Input: db5@part_tab2@ds=2009-04-09 -PREHOOK: Output: db5@db5__part_tab2_idx4__@ds=2009-04-09 -POSTHOOK: query: ALTER INDEX idx4 ON part_tab2 PARTITION (ds='2009-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab2 -POSTHOOK: Input: db5@part_tab2@ds=2009-04-09 -POSTHOOK: Output: db5@db5__part_tab2_idx4__@ds=2009-04-09 -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2009-04-09)._bucketname SIMPLE [(part_tab2)part_tab2.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2009-04-09)._offsets EXPRESSION [(part_tab2)part_tab2.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab2_idx4__ PARTITION(ds=2009-04-09).id SIMPLE [(part_tab2)part_tab2.FieldSchema(name:id, type:int, comment:null), ] PREHOOK: query: CREATE TABLE part_tab3 (id INT, name STRING) PARTITIONED BY (ds string) #### A masked pattern was here #### PREHOOK: type: CREATETABLE @@ -277,43 +170,6 @@ POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: db5@part_tab3 POSTHOOK: Output: db5@part_tab3@ds=2009-04-09 -PREHOOK: query: CREATE INDEX idx5 ON TABLE part_tab3(id) AS 'COMPACT' with DEFERRED REBUILD -#### A masked pattern was here #### -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@part_tab3 -#### A masked pattern was here #### -POSTHOOK: query: CREATE INDEX idx5 ON TABLE part_tab3(id) AS 'COMPACT' with DEFERRED REBUILD -#### A masked pattern was here #### -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@part_tab3 -POSTHOOK: Output: db5@db5__part_tab3_idx5__ -#### A masked pattern was here #### -PREHOOK: query: ALTER INDEX idx5 ON part_tab3 PARTITION (ds='2008-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab3 -PREHOOK: Input: db5@part_tab3@ds=2008-04-09 -PREHOOK: Output: db5@db5__part_tab3_idx5__@ds=2008-04-09 -POSTHOOK: query: ALTER INDEX idx5 ON part_tab3 PARTITION (ds='2008-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab3 -POSTHOOK: Input: db5@part_tab3@ds=2008-04-09 -POSTHOOK: Output: db5@db5__part_tab3_idx5__@ds=2008-04-09 -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2008-04-09)._bucketname SIMPLE [(part_tab3)part_tab3.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2008-04-09)._offsets EXPRESSION [(part_tab3)part_tab3.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2008-04-09).id SIMPLE [(part_tab3)part_tab3.FieldSchema(name:id, type:int, comment:null), ] -PREHOOK: query: ALTER INDEX idx5 ON part_tab3 PARTITION (ds='2009-04-09') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@part_tab3 -PREHOOK: Input: db5@part_tab3@ds=2009-04-09 -PREHOOK: Output: db5@db5__part_tab3_idx5__@ds=2009-04-09 -POSTHOOK: query: ALTER INDEX idx5 ON part_tab3 PARTITION (ds='2009-04-09') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@part_tab3 -POSTHOOK: Input: db5@part_tab3@ds=2009-04-09 -POSTHOOK: Output: db5@db5__part_tab3_idx5__@ds=2009-04-09 -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2009-04-09)._bucketname SIMPLE [(part_tab3)part_tab3.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2009-04-09)._offsets EXPRESSION [(part_tab3)part_tab3.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: db5__part_tab3_idx5__ PARTITION(ds=2009-04-09).id SIMPLE [(part_tab3)part_tab3.FieldSchema(name:id, type:int, comment:null), ] PREHOOK: query: CREATE EXTERNAL TABLE extab1(id INT, name STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '' LINES TERMINATED BY '\n' @@ -348,33 +204,10 @@ POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' into table te POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: db5@temp_tbl3 -PREHOOK: query: CREATE INDEX temp_tbl3_idx ON TABLE temp_tbl3(id) AS 'COMPACT' with DEFERRED REBUILD IN TABLE temp_tbl3_idx_tbl -PREHOOK: type: CREATEINDEX -PREHOOK: Input: db5@temp_tbl3 -POSTHOOK: query: CREATE INDEX temp_tbl3_idx ON TABLE temp_tbl3(id) AS 'COMPACT' with DEFERRED REBUILD IN TABLE temp_tbl3_idx_tbl -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: db5@temp_tbl3 -POSTHOOK: Output: db5@temp_tbl3_idx_tbl -PREHOOK: query: ALTER INDEX temp_tbl3_idx ON temp_tbl3 REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: db5@temp_tbl3 -PREHOOK: Output: db5@temp_tbl3_idx_tbl -POSTHOOK: query: ALTER INDEX temp_tbl3_idx ON temp_tbl3 REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: db5@temp_tbl3 -POSTHOOK: Output: db5@temp_tbl3_idx_tbl -POSTHOOK: Lineage: temp_tbl3_idx_tbl._bucketname SIMPLE [(temp_tbl3)temp_tbl3.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: temp_tbl3_idx_tbl._offsets EXPRESSION [(temp_tbl3)temp_tbl3.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: temp_tbl3_idx_tbl.id SIMPLE [(temp_tbl3)temp_tbl3.FieldSchema(name:id, type:int, comment:null), ] PREHOOK: query: DROP DATABASE db5 CASCADE PREHOOK: type: DROPDATABASE PREHOOK: Input: database:db5 PREHOOK: Output: database:db5 -PREHOOK: Output: db5@db5__part_tab2_idx4__ -PREHOOK: Output: db5@db5__part_tab3_idx5__ -PREHOOK: Output: db5@db5__part_tab_idx3__ -PREHOOK: Output: db5@db5__temp_tbl2_idx2__ -PREHOOK: Output: db5@db5__temp_tbl_idx1__ PREHOOK: Output: db5@extab1 PREHOOK: Output: db5@part_tab PREHOOK: Output: db5@part_tab2 @@ -383,17 +216,11 @@ PREHOOK: Output: db5@temp_tbl PREHOOK: Output: db5@temp_tbl2 PREHOOK: Output: db5@temp_tbl2_view PREHOOK: Output: db5@temp_tbl3 -PREHOOK: Output: db5@temp_tbl3_idx_tbl PREHOOK: Output: db5@temp_tbl_view POSTHOOK: query: DROP DATABASE db5 CASCADE POSTHOOK: type: DROPDATABASE POSTHOOK: Input: database:db5 POSTHOOK: Output: database:db5 -POSTHOOK: Output: db5@db5__part_tab2_idx4__ -POSTHOOK: Output: db5@db5__part_tab3_idx5__ -POSTHOOK: Output: db5@db5__part_tab_idx3__ -POSTHOOK: Output: db5@db5__temp_tbl2_idx2__ -POSTHOOK: Output: db5@db5__temp_tbl_idx1__ POSTHOOK: Output: db5@extab1 POSTHOOK: Output: db5@part_tab POSTHOOK: Output: db5@part_tab2 @@ -402,6 +229,5 @@ POSTHOOK: Output: db5@temp_tbl POSTHOOK: Output: db5@temp_tbl2 POSTHOOK: Output: db5@temp_tbl2_view POSTHOOK: Output: db5@temp_tbl3 -POSTHOOK: Output: db5@temp_tbl3_idx_tbl POSTHOOK: Output: db5@temp_tbl_view #### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/escape_comments.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/escape_comments.q.out b/ql/src/test/results/clientpositive/escape_comments.q.out index 6c86e81..15e0bc3 100644 --- a/ql/src/test/results/clientpositive/escape_comments.q.out +++ b/ql/src/test/results/clientpositive/escape_comments.q.out @@ -36,13 +36,6 @@ POSTHOOK: Output: database:escape_comments_db POSTHOOK: Output: escape_comments_db@escape_comments_view1 POSTHOOK: Lineage: escape_comments_view1.col1 SIMPLE [(escape_comments_tbl1)escape_comments_tbl1.FieldSchema(name:col1, type:string, comment:a b';), ] -PREHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb' -PREHOOK: type: CREATEINDEX -PREHOOK: Input: escape_comments_db@escape_comments_tbl1 -POSTHOOK: query: create index index2 on table escape_comments_tbl1(col1) as 'COMPACT' with deferred rebuild comment 'a\nb' -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: escape_comments_db@escape_comments_tbl1 -POSTHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ PREHOOK: query: describe database extended escape_comments_db PREHOOK: type: DESCDATABASE PREHOOK: Input: database:escape_comments_db @@ -175,24 +168,15 @@ Sort Columns: [] View Original Text: select col1 from escape_comments_tbl1 View Expanded Text: SELECT `col1` AS `col1` FROM (select `escape_comments_tbl1`.`col1` from `escape_comments_db`.`escape_comments_tbl1`) `escape_comments_db.escape_comments_view1` View Rewrite Enabled: No -PREHOOK: query: show formatted index on escape_comments_tbl1 -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: show formatted index on escape_comments_tbl1 -POSTHOOK: type: SHOWINDEXES -idx_name tab_name col_names idx_tab_name idx_type comment -index2 escape_comments_tbl1 col1 escape_comments_db__escape_comments_tbl1_index2__ compact a - b PREHOOK: query: drop database escape_comments_db cascade PREHOOK: type: DROPDATABASE PREHOOK: Input: database:escape_comments_db PREHOOK: Output: database:escape_comments_db -PREHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ PREHOOK: Output: escape_comments_db@escape_comments_tbl1 PREHOOK: Output: escape_comments_db@escape_comments_view1 POSTHOOK: query: drop database escape_comments_db cascade POSTHOOK: type: DROPDATABASE POSTHOOK: Input: database:escape_comments_db POSTHOOK: Output: database:escape_comments_db -POSTHOOK: Output: escape_comments_db@escape_comments_db__escape_comments_tbl1_index2__ POSTHOOK: Output: escape_comments_db@escape_comments_tbl1 POSTHOOK: Output: escape_comments_db@escape_comments_view1 http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_auth.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_auth.q.out b/ql/src/test/results/clientpositive/index_auth.q.out deleted file mode 100644 index 385b639..0000000 --- a/ql/src/test/results/clientpositive/index_auth.q.out +++ /dev/null @@ -1,79 +0,0 @@ -PREHOOK: query: create table foobar(key int, value string) PARTITIONED BY (ds string, hr string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@foobar -POSTHOOK: query: create table foobar(key int, value string) PARTITIONED BY (ds string, hr string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@foobar -PREHOOK: query: alter table foobar add partition (ds='2008-04-08',hr='12') -PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@foobar -POSTHOOK: query: alter table foobar add partition (ds='2008-04-08',hr='12') -POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@foobar -POSTHOOK: Output: default@foobar@ds=2008-04-08/hr=12 -PREHOOK: query: CREATE INDEX srcpart_AUTH_index ON TABLE foobar(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@foobar -POSTHOOK: query: CREATE INDEX srcpart_AUTH_index ON TABLE foobar(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@foobar -POSTHOOK: Output: default@default__foobar_srcpart_auth_index__ -PREHOOK: query: SHOW INDEXES ON foobar -PREHOOK: type: SHOWINDEXES -POSTHOOK: query: SHOW INDEXES ON foobar -POSTHOOK: type: SHOWINDEXES -srcpart_auth_index foobar key default__foobar_srcpart_auth_index__ bitmap -PREHOOK: query: grant select on table foobar to user hive_test_user -PREHOOK: type: GRANT_PRIVILEGE -PREHOOK: Output: default@foobar -POSTHOOK: query: grant select on table foobar to user hive_test_user -POSTHOOK: type: GRANT_PRIVILEGE -POSTHOOK: Output: default@foobar -PREHOOK: query: grant select on table default__foobar_srcpart_auth_indeX__ to user hive_test_user -PREHOOK: type: GRANT_PRIVILEGE -PREHOOK: Output: default@default__foobar_srcpart_auth_index__ -POSTHOOK: query: grant select on table default__foobar_srcpart_auth_indeX__ to user hive_test_user -POSTHOOK: type: GRANT_PRIVILEGE -POSTHOOK: Output: default@default__foobar_srcpart_auth_index__ -PREHOOK: query: grant update on table default__foobar_srcpart_auth_indEx__ to user hive_test_user -PREHOOK: type: GRANT_PRIVILEGE -PREHOOK: Output: default@default__foobar_srcpart_auth_index__ -POSTHOOK: query: grant update on table default__foobar_srcpart_auth_indEx__ to user hive_test_user -POSTHOOK: type: GRANT_PRIVILEGE -POSTHOOK: Output: default@default__foobar_srcpart_auth_index__ -PREHOOK: query: grant create on table default__foobar_srcpart_auth_inDex__ to user hive_test_user -PREHOOK: type: GRANT_PRIVILEGE -PREHOOK: Output: default@default__foobar_srcpart_auth_index__ -POSTHOOK: query: grant create on table default__foobar_srcpart_auth_inDex__ to user hive_test_user -POSTHOOK: type: GRANT_PRIVILEGE -POSTHOOK: Output: default@default__foobar_srcpart_auth_index__ -PREHOOK: query: ALTER INDEX srcpart_auth_INDEX ON foobar PARTITION (ds='2008-04-08',hr='12') REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@foobar -PREHOOK: Input: default@foobar@ds=2008-04-08/hr=12 -PREHOOK: Output: default@default__foobar_srcpart_auth_index__@ds=2008-04-08/hr=12 -POSTHOOK: query: ALTER INDEX srcpart_auth_INDEX ON foobar PARTITION (ds='2008-04-08',hr='12') REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@foobar -POSTHOOK: Input: default@foobar@ds=2008-04-08/hr=12 -POSTHOOK: Output: default@default__foobar_srcpart_auth_index__@ds=2008-04-08/hr=12 -POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION [(foobar)foobar.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._bucketname SIMPLE [(foobar)foobar.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12)._offset SIMPLE [(foobar)foobar.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__foobar_srcpart_auth_index__ PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(foobar)foobar.FieldSchema(name:key, type:int, comment:null), ] -PREHOOK: query: DROP INDEX srcpart_auth_index on foobar -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@foobar -POSTHOOK: query: DROP INDEX srcpart_auth_index on foobar -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@foobar -PREHOOK: query: DROP TABLE foobar -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@foobar -PREHOOK: Output: default@foobar -POSTHOOK: query: DROP TABLE foobar -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@foobar -POSTHOOK: Output: default@foobar http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_auto.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_auto.q.out b/ql/src/test/results/clientpositive/index_auto.q.out deleted file mode 100644 index 654e419..0000000 --- a/ql/src/test/results/clientpositive/index_auto.q.out +++ /dev/null @@ -1,255 +0,0 @@ -PREHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -82 val_82 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -95 val_95 -95 val_95 -96 val_96 -97 val_97 -97 val_97 -98 val_98 -98 val_98 -PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' 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__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(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), ] -#### A masked pattern was here #### -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index__ -#### A masked pattern was here #### -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src_index__ -#### A masked pattern was here #### -PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100 -POSTHOOK: type: QUERY -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: src - 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)) (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 - File Output Operator - compressed: false - Statistics: Num rows: 55 Data size: 584 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 key, value FROM src WHERE key > 80 AND key < 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -82 val_82 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -95 val_95 -95 val_95 -96 val_96 -97 val_97 -97 val_97 -98 val_98 -98 val_98 -PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-3 is a root stage - Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6 - Stage-5 - Stage-2 depends on stages: Stage-5, Stage-4, Stage-7 - Stage-1 depends on stages: Stage-2 - Stage-4 - Stage-6 - Stage-7 depends on stages: Stage-6 - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - alias: default__src_src_index__ - filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) - Filter Operator - predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) > 80.0)) (type: boolean) - Select Operator - expressions: _bucketname (type: string), _offsets (type: array<bigint>) - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-8 - Conditional Operator - - Stage: Stage-5 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-2 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: src - filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (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)) (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 - File Output Operator - compressed: false - Statistics: Num rows: 55 Data size: 584 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-4 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-6 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-7 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index__ -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key > 80 AND key < 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src_index__ -POSTHOOK: Input: default@src -#### A masked pattern was here #### -82 val_82 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -95 val_95 -95 val_95 -96 val_96 -97 val_97 -97 val_97 -98 val_98 -98 val_98 -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 http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_auto_empty.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_auto_empty.q.out b/ql/src/test/results/clientpositive/index_auto_empty.q.out deleted file mode 100644 index 0191339..0000000 --- a/ql/src/test/results/clientpositive/index_auto_empty.q.out +++ /dev/null @@ -1,101 +0,0 @@ -PREHOOK: query: CREATE DATABASE it -PREHOOK: type: CREATEDATABASE -PREHOOK: Output: database:it -POSTHOOK: query: CREATE DATABASE it -POSTHOOK: type: CREATEDATABASE -POSTHOOK: Output: database:it -PREHOOK: query: CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:it -PREHOOK: Output: it@temp -POSTHOOK: query: CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:it -POSTHOOK: Output: it@temp -PREHOOK: query: CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: it@temp -POSTHOOK: query: CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: it@temp -POSTHOOK: Output: it@it__temp_temp_index__ -PREHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: it@temp -PREHOOK: Output: it@it__temp_temp_index__ -POSTHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: it@temp -POSTHOOK: Output: it@it__temp_temp_index__ -POSTHOOK: Lineage: it__temp_temp_index__._bucketname SIMPLE [(temp)temp.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: it__temp_temp_index__._offsets EXPRESSION [(temp)temp.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: it__temp_temp_index__.key SIMPLE [(temp)temp.FieldSchema(name:key, type:string, comment:null), ] -PREHOOK: query: SELECT * FROM it.it__temp_temp_index__ WHERE key = 86 -PREHOOK: type: QUERY -PREHOOK: Input: it@it__temp_temp_index__ -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM it.it__temp_temp_index__ WHERE key = 86 -POSTHOOK: type: QUERY -POSTHOOK: Input: it@it__temp_temp_index__ -#### A masked pattern was here #### -PREHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86 -POSTHOOK: type: QUERY -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: temp - filterExpr: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: key (type: string), val (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 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 * FROM it.temp WHERE key = 86 -PREHOOK: type: QUERY -PREHOOK: Input: it@temp -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM it.temp WHERE key = 86 -POSTHOOK: type: QUERY -POSTHOOK: Input: it@temp -#### A masked pattern was here #### -PREHOOK: query: DROP table it.temp -PREHOOK: type: DROPTABLE -PREHOOK: Input: it@temp -PREHOOK: Output: it@temp -POSTHOOK: query: DROP table it.temp -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: it@temp -POSTHOOK: Output: it@temp -PREHOOK: query: DROP DATABASE it -PREHOOK: type: DROPDATABASE -PREHOOK: Input: database:it -PREHOOK: Output: database:it -POSTHOOK: query: DROP DATABASE it -POSTHOOK: type: DROPDATABASE -POSTHOOK: Input: database:it -POSTHOOK: Output: database:it http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_auto_file_format.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_auto_file_format.q.out b/ql/src/test/results/clientpositive/index_auto_file_format.q.out deleted file mode 100644 index 21c8085..0000000 --- a/ql/src/test/results/clientpositive/index_auto_file_format.q.out +++ /dev/null @@ -1,256 +0,0 @@ -PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' 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__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(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 key, value FROM src WHERE key=86 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-3 is a root stage - Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6 - Stage-5 - Stage-2 depends on stages: Stage-5, Stage-4, Stage-7 - Stage-1 depends on stages: Stage-2 - Stage-4 - Stage-6 - Stage-7 depends on stages: Stage-6 - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - alias: default__src_src_index__ - filterExpr: (UDFToDouble(key) = 86.0) (type: boolean) - Filter Operator - predicate: (UDFToDouble(key) = 86.0) (type: boolean) - Select Operator - expressions: _bucketname (type: string), _offsets (type: array<bigint>) - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-8 - Conditional Operator - - Stage: Stage-5 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-2 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: src - filterExpr: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 250 Data size: 2656 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-4 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-6 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-7 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, value FROM src WHERE key=86 -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index__ -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key=86 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src_index__ -POSTHOOK: Input: default@src -#### A masked pattern was here #### -86 val_86 -PREHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, value FROM src WHERE key=86 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-3 is a root stage - Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6 - Stage-5 - Stage-2 depends on stages: Stage-5, Stage-4, Stage-7 - Stage-1 depends on stages: Stage-2 - Stage-4 - Stage-6 - Stage-7 depends on stages: Stage-6 - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - alias: default__src_src_index__ - filterExpr: (UDFToDouble(key) = 86.0) (type: boolean) - Filter Operator - predicate: (UDFToDouble(key) = 86.0) (type: boolean) - Select Operator - expressions: _bucketname (type: string), _offsets (type: array<bigint>) - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-8 - Conditional Operator - - Stage: Stage-5 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-2 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: src - filterExpr: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (UDFToDouble(key) = 86.0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 250 Data size: 2656 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-4 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-6 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-7 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, value FROM src WHERE key=86 -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index__ -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, value FROM src WHERE key=86 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src_index__ -POSTHOOK: Input: default@src -#### A masked pattern was here #### -86 val_86 -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 http://git-wip-us.apache.org/repos/asf/hive/blob/b0d3cb45/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out b/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out deleted file mode 100644 index d970b25..0000000 --- a/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out +++ /dev/null @@ -1,438 +0,0 @@ -PREHOOK: query: EXPLAIN SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) 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, a.value FROM src a JOIN srcpart b ON (a.key = b.key) 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 - Map Reduce - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0)) (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: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - TableScan - alias: b - Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0)) (type: boolean) - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: string) - 1 _col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 244 Data size: 2593 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 244 Data size: 2593 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, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Input: default@srcpart -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Input: default@srcpart -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -82 val_82 -82 val_82 -82 val_82 -82 val_82 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -85 val_85 -85 val_85 -85 val_85 -85 val_85 -86 val_86 -86 val_86 -86 val_86 -86 val_86 -87 val_87 -87 val_87 -87 val_87 -87 val_87 -PREHOOK: query: CREATE INDEX src_index_bitmap ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@src -POSTHOOK: query: CREATE INDEX src_index_bitmap ON TABLE src(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src_index_bitmap__ -PREHOOK: query: ALTER INDEX src_index_bitmap ON src REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@src -PREHOOK: Output: default@default__src_src_index_bitmap__ -POSTHOOK: query: ALTER INDEX src_index_bitmap ON src REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@src -POSTHOOK: Output: default@default__src_src_index_bitmap__ -POSTHOOK: Lineage: default__src_src_index_bitmap__._bitmaps EXPRESSION [(src)src.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src_index_bitmap__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__src_src_index_bitmap__._offset SIMPLE [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__src_src_index_bitmap__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -PREHOOK: query: CREATE INDEX srcpart_index_bitmap ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD -PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@srcpart -POSTHOOK: query: CREATE INDEX srcpart_index_bitmap ON TABLE srcpart(key) as 'BITMAP' WITH DEFERRED REBUILD -POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@default__srcpart_srcpart_index_bitmap__ -PREHOOK: query: ALTER INDEX srcpart_index_bitmap ON srcpart REBUILD -PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@srcpart -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -PREHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=11 -PREHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=12 -PREHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=11 -PREHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=12 -POSTHOOK: query: ALTER INDEX srcpart_index_bitmap ON srcpart REBUILD -POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@srcpart -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -POSTHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=12 -POSTHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=11 -POSTHOOK: Output: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=12 -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=11)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=11)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=11)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=12)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=12)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=11)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=11)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=11)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=12)._bitmaps EXPRESSION [(srcpart)srcpart.FieldSchema(name:ROW__OFFSET__INSIDE__BLOCK, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=12)._bucketname SIMPLE [(srcpart)srcpart.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=12)._offset SIMPLE [(srcpart)srcpart.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__srcpart_srcpart_index_bitmap__ PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] -PREHOOK: query: EXPLAIN SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) 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, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-4 is a root stage - Stage-3 depends on stages: Stage-4 - Stage-1 depends on stages: Stage-3, Stage-5 - Stage-6 is a root stage - Stage-5 depends on stages: Stage-6 - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-4 - Map Reduce - Map Operator Tree: - TableScan - alias: default__src_src_index_bitmap__ - filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 90.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean) - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean) - Select Operator - expressions: _bucketname (type: string), _offset (type: bigint) - outputColumnNames: _bucketname, _offset - Group By Operator - aggregations: collect_set(_offset) - keys: _bucketname (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - value expressions: _col1 (type: array<bigint>) - Reduce Operator Tree: - Group By Operator - aggregations: collect_set(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-3 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: a - filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 90.0)) (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) > 80.0)) (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: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - TableScan - alias: b - filterExpr: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0)) (type: boolean) - Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0)) (type: boolean) - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 222 Data size: 2358 Basic stats: COMPLETE Column stats: NONE - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: string) - 1 _col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 244 Data size: 2593 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 244 Data size: 2593 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-6 - Map Reduce - Map Operator Tree: - TableScan - alias: default__srcpart_srcpart_index_bitmap__ - filterExpr: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean) - Filter Operator - predicate: ((UDFToDouble(key) < 90.0) and (UDFToDouble(key) > 80.0) and (not EWAH_BITMAP_EMPTY(_bitmaps))) (type: boolean) - Select Operator - expressions: _bucketname (type: string), _offset (type: bigint) - outputColumnNames: _bucketname, _offset - Group By Operator - aggregations: collect_set(_offset) - keys: _bucketname (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - value expressions: _col1 (type: array<bigint>) - Reduce Operator Tree: - Group By Operator - aggregations: collect_set(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-5 - Move Operator - files: - hdfs directory: true -#### A masked pattern was here #### - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -PREHOOK: type: QUERY -PREHOOK: Input: default@default__src_src_index_bitmap__ -PREHOOK: Input: default@default__srcpart_srcpart_index_bitmap__ -PREHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=11 -PREHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=12 -PREHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=11 -PREHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=12 -PREHOOK: Input: default@src -PREHOOK: Input: default@srcpart -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT a.key, a.value FROM src a JOIN srcpart b ON (a.key = b.key) WHERE a.key > 80 AND a.key < 100 AND b.key > 70 AND b.key < 90 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__src_src_index_bitmap__ -POSTHOOK: Input: default@default__srcpart_srcpart_index_bitmap__ -POSTHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@default__srcpart_srcpart_index_bitmap__@ds=2008-04-09/hr=12 -POSTHOOK: Input: default@src -POSTHOOK: Input: default@srcpart -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -#### A masked pattern was here #### -82 val_82 -82 val_82 -82 val_82 -82 val_82 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -83 val_83 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -84 val_84 -85 val_85 -85 val_85 -85 val_85 -85 val_85 -86 val_86 -86 val_86 -86 val_86 -86 val_86 -87 val_87 -87 val_87 -87 val_87 -87 val_87 -PREHOOK: query: DROP INDEX src_index_bitmap on src -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@src -POSTHOOK: query: DROP INDEX src_index_bitmap on src -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@src -PREHOOK: query: DROP INDEX srcpart_index_bitmap on srcpart -PREHOOK: type: DROPINDEX -PREHOOK: Input: default@srcpart -POSTHOOK: query: DROP INDEX srcpart_index_bitmap on srcpart -POSTHOOK: type: DROPINDEX -POSTHOOK: Input: default@srcpart