HIVE-19146 : Delete dangling q.out - addendum
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/bceee7af Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/bceee7af Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/bceee7af Branch: refs/heads/branch-3 Commit: bceee7af4f5ca124fc31316e8bfb4330a6b232cd Parents: c3e885b Author: Ashutosh Chauhan <hashut...@apache.org> Authored: Tue Apr 10 07:50:10 2018 -0700 Committer: Vineet Garg <vg...@apache.org> Committed: Tue Apr 10 12:36:44 2018 -0700 ---------------------------------------------------------------------- ...insert_overwrite_local_directory_1_bug.q.out | 71 ---- .../materialized_view_describe.q.out | 366 ------------------- .../clientpositive/materialized_view_drop.q.out | 39 -- 3 files changed, 476 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/bceee7af/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out b/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out deleted file mode 100644 index 502404d..0000000 --- a/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1_bug.q.out +++ /dev/null @@ -1,71 +0,0 @@ -PREHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>) -ROW FORMAT DELIMITED -FIELDS TERMINATED BY '\t' -COLLECTION ITEMS TERMINATED BY ',' -MAP KEYS TERMINATED BY ':' -STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@map_table -POSTHOOK: query: create table map_table (foo STRING , bar MAP<STRING, STRING>) -ROW FORMAT DELIMITED -FIELDS TERMINATED BY '\t' -COLLECTION ITEMS TERMINATED BY ',' -MAP KEYS TERMINATED BY ':' -STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@map_table -PREHOOK: query: load data local inpath "../../data/files/map_table.txt" overwrite into table map_table -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@map_table -POSTHOOK: query: load data local inpath "../../data/files/map_table.txt" overwrite into table map_table -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@map_table -PREHOOK: query: explain -select * from map_table -PREHOOK: type: QUERY -POSTHOOK: query: explain -select * from map_table -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: map_table - Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: foo (type: string), bar (type: map<string,string>) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 520 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 520 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 * from map_table -PREHOOK: type: QUERY -PREHOOK: Input: default@map_table -#### A masked pattern was here #### -POSTHOOK: query: select * from map_table -POSTHOOK: type: QUERY -POSTHOOK: Input: default@map_table -#### A masked pattern was here #### -foo1 {"k1":"v1","k2":"v2","k3":"v3"} -foo2 {"k21":"v21","k22":"v22","k31":"v31"} http://git-wip-us.apache.org/repos/asf/hive/blob/bceee7af/ql/src/test/results/clientpositive/materialized_view_describe.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/materialized_view_describe.q.out b/ql/src/test/results/clientpositive/materialized_view_describe.q.out deleted file mode 100644 index efd60d4..0000000 --- a/ql/src/test/results/clientpositive/materialized_view_describe.q.out +++ /dev/null @@ -1,366 +0,0 @@ -PREHOOK: query: create table cmv_basetable (a int, b varchar(256), c decimal(10,2)) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_basetable -POSTHOOK: query: create table cmv_basetable (a int, b varchar(256), c decimal(10,2)) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_basetable -PREHOOK: query: insert into cmv_basetable values (1, 'alfred', 10.30),(2, 'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@cmv_basetable -POSTHOOK: query: insert into cmv_basetable values (1, 'alfred', 10.30),(2, 'bob', 3.14),(2, 'bonnie', 172342.2),(3, 'calvin', 978.76),(3, 'charlie', 9.8) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@cmv_basetable -POSTHOOK: Lineage: cmv_basetable.a SCRIPT [] -POSTHOOK: Lineage: cmv_basetable.b SCRIPT [] -POSTHOOK: Lineage: cmv_basetable.c SCRIPT [] -PREHOOK: query: create materialized view cmv_mat_view -comment 'this is the first view' -tblproperties ('key'='foo') as select a, c from cmv_basetable -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view -POSTHOOK: query: create materialized view cmv_mat_view -comment 'this is the first view' -tblproperties ('key'='foo') as select a, c from cmv_basetable -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view -PREHOOK: query: describe cmv_mat_view -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view -POSTHOOK: query: describe cmv_mat_view -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view -a int -c decimal(10,2) -PREHOOK: query: describe extended cmv_mat_view -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view -POSTHOOK: query: describe extended cmv_mat_view -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view -a int -c decimal(10,2) - -#### A masked pattern was here #### -PREHOOK: query: describe formatted cmv_mat_view -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view -POSTHOOK: query: describe formatted cmv_mat_view -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view -# col_name data_type comment -a int -c decimal(10,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MATERIALIZED_VIEW -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - comment this is the first view - key foo - numFiles 1 - numRows 5 - rawDataSize 580 - totalSize 346 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] - -# View Information -View Original Text: select a, c from cmv_basetable -View Expanded Text: select `cmv_basetable`.`a`, `cmv_basetable`.`c` from `default`.`cmv_basetable` -View Rewrite Enabled: No -PREHOOK: query: show tblproperties cmv_mat_view -PREHOOK: type: SHOW_TBLPROPERTIES -POSTHOOK: query: show tblproperties cmv_mat_view -POSTHOOK: type: SHOW_TBLPROPERTIES -COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} -comment this is the first view -key foo -numFiles 1 -numRows 5 -rawDataSize 580 -totalSize 346 -#### A masked pattern was here #### -PREHOOK: query: select a, c from cmv_mat_view -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view -#### A masked pattern was here #### -POSTHOOK: query: select a, c from cmv_mat_view -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view -#### A masked pattern was here #### -1 10.30 -2 3.14 -2 172342.20 -3 978.76 -3 9.80 -PREHOOK: query: drop materialized view cmv_mat_view -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_mat_view -PREHOOK: Output: default@cmv_mat_view -POSTHOOK: query: drop materialized view cmv_mat_view -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_mat_view -POSTHOOK: Output: default@cmv_mat_view -PREHOOK: query: create materialized view cmv_mat_view2 -comment 'this is the second view' -stored as textfile -tblproperties ('key'='alice','key2'='bob') as select a from cmv_basetable -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view2 -POSTHOOK: query: create materialized view cmv_mat_view2 -comment 'this is the second view' -stored as textfile -tblproperties ('key'='alice','key2'='bob') as select a from cmv_basetable -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view2 -PREHOOK: query: describe formatted cmv_mat_view2 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view2 -POSTHOOK: query: describe formatted cmv_mat_view2 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view2 -# col_name data_type comment -a int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MATERIALIZED_VIEW -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - comment this is the second view - key alice - key2 bob - numFiles 1 - numRows 5 - rawDataSize 5 - totalSize 10 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] - -# View Information -View Original Text: select a from cmv_basetable -View Expanded Text: select `cmv_basetable`.`a` from `default`.`cmv_basetable` -View Rewrite Enabled: No -PREHOOK: query: select a from cmv_mat_view2 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view2 -#### A masked pattern was here #### -POSTHOOK: query: select a from cmv_mat_view2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view2 -#### A masked pattern was here #### -1 -2 -2 -3 -3 -PREHOOK: query: drop materialized view cmv_mat_view2 -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_mat_view2 -PREHOOK: Output: default@cmv_mat_view2 -POSTHOOK: query: drop materialized view cmv_mat_view2 -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_mat_view2 -POSTHOOK: Output: default@cmv_mat_view2 -PREHOOK: query: create materialized view cmv_mat_view3 -comment 'this is the third view' -row format - delimited fields terminated by '\t' -as select * from cmv_basetable -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view3 -POSTHOOK: query: create materialized view cmv_mat_view3 -comment 'this is the third view' -row format - delimited fields terminated by '\t' -as select * from cmv_basetable -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view3 -PREHOOK: query: describe formatted cmv_mat_view3 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view3 -POSTHOOK: query: describe formatted cmv_mat_view3 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view3 -# col_name data_type comment -a int -b varchar(256) -c decimal(10,2) - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MATERIALIZED_VIEW -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - comment this is the third view - numFiles 1 - numRows 5 - rawDataSize 1025 - totalSize 497 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] - -# View Information -View Original Text: select * from cmv_basetable -View Expanded Text: select `cmv_basetable`.`a`, `cmv_basetable`.`b`, `cmv_basetable`.`c` from `default`.`cmv_basetable` -View Rewrite Enabled: No -PREHOOK: query: select a, b, c from cmv_mat_view3 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -POSTHOOK: query: select a, b, c from cmv_mat_view3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -1 alfred 10.30 -2 bob 3.14 -2 bonnie 172342.20 -3 calvin 978.76 -3 charlie 9.80 -PREHOOK: query: select distinct a from cmv_mat_view3 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -POSTHOOK: query: select distinct a from cmv_mat_view3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -1 -2 -3 -PREHOOK: query: drop materialized view cmv_mat_view3 -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_mat_view3 -PREHOOK: Output: default@cmv_mat_view3 -POSTHOOK: query: drop materialized view cmv_mat_view3 -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_mat_view3 -POSTHOOK: Output: default@cmv_mat_view3 -PREHOOK: query: create materialized view cmv_mat_view4 -comment 'this is the last view' -stored as textfile -#### A masked pattern was here #### -as select a from cmv_basetable -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -#### A masked pattern was here #### -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view4 -POSTHOOK: query: create materialized view cmv_mat_view4 -comment 'this is the last view' -stored as textfile -#### A masked pattern was here #### -as select a from cmv_basetable -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -#### A masked pattern was here #### -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view4 -PREHOOK: query: describe formatted cmv_mat_view4 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view4 -POSTHOOK: query: describe formatted cmv_mat_view4 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view4 -# col_name data_type comment -a int - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MATERIALIZED_VIEW -Table Parameters: - COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} - comment this is the last view - numFiles 1 - numRows 5 - rawDataSize 5 - totalSize 10 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -InputFormat: org.apache.hadoop.mapred.TextInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] - -# View Information -View Original Text: select a from cmv_basetable -View Expanded Text: select `cmv_basetable`.`a` from `default`.`cmv_basetable` -View Rewrite Enabled: No -PREHOOK: query: select a from cmv_mat_view4 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view4 -#### A masked pattern was here #### -POSTHOOK: query: select a from cmv_mat_view4 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view4 -#### A masked pattern was here #### -1 -2 -2 -3 -3 -PREHOOK: query: drop materialized view cmv_mat_view4 -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_mat_view4 -PREHOOK: Output: default@cmv_mat_view4 -POSTHOOK: query: drop materialized view cmv_mat_view4 -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_mat_view4 -POSTHOOK: Output: default@cmv_mat_view4 http://git-wip-us.apache.org/repos/asf/hive/blob/bceee7af/ql/src/test/results/clientpositive/materialized_view_drop.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/materialized_view_drop.q.out b/ql/src/test/results/clientpositive/materialized_view_drop.q.out deleted file mode 100644 index ceb34f7..0000000 --- a/ql/src/test/results/clientpositive/materialized_view_drop.q.out +++ /dev/null @@ -1,39 +0,0 @@ -PREHOOK: query: create materialized view dmv_mat_view as select cint, cstring1 from alltypesorc where cint < 0 -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: database:default -PREHOOK: Output: default@dmv_mat_view -POSTHOOK: query: create materialized view dmv_mat_view as select cint, cstring1 from alltypesorc where cint < 0 -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: database:default -POSTHOOK: Output: default@dmv_mat_view -PREHOOK: query: show table extended like dmv_mat_view -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like dmv_mat_view -POSTHOOK: type: SHOW_TABLESTATUS -tableName:dmv_mat_view -#### A masked pattern was here #### -inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -columns:struct columns { i32 cint, string cstring1} -partitioned:false -partitionColumns: -totalNumberFiles:1 -totalFileSize:47120 -maxFileSize:47120 -minFileSize:47120 -#### A masked pattern was here #### - -PREHOOK: query: drop materialized view dmv_mat_view -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@dmv_mat_view -PREHOOK: Output: default@dmv_mat_view -POSTHOOK: query: drop materialized view dmv_mat_view -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@dmv_mat_view -POSTHOOK: Output: default@dmv_mat_view -PREHOOK: query: show table extended like dmv_mat_view -PREHOOK: type: SHOW_TABLESTATUS -POSTHOOK: query: show table extended like dmv_mat_view -POSTHOOK: type: SHOW_TABLESTATUS