Repository: hive Updated Branches: refs/heads/master 91a0cb8fa -> dcd9b5941
HIVE-19146 : Delete dangling q.out Signed-off-by: Ashutosh Chauhan <hashut...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/dcd9b594 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/dcd9b594 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/dcd9b594 Branch: refs/heads/master Commit: dcd9b5941c53d5219eb35f9f682ba2da69288291 Parents: 91a0cb8 Author: Ashutosh Chauhan <hashut...@apache.org> Authored: Mon Apr 9 21:30:34 2018 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Mon Apr 9 21:30:34 2018 -0700 ---------------------------------------------------------------------- .../materialized_view_create.q.out | 288 ------------------- 1 file changed, 288 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/dcd9b594/ql/src/test/results/clientpositive/materialized_view_create.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/materialized_view_create.q.out b/ql/src/test/results/clientpositive/materialized_view_create.q.out deleted file mode 100644 index 8952304..0000000 --- a/ql/src/test/results/clientpositive/materialized_view_create.q.out +++ /dev/null @@ -1,288 +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 as select a, b, 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 as select a, b, 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: desc formatted cmv_mat_view -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view -POSTHOOK: query: desc formatted cmv_mat_view -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view -# 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\"} - 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 a, b, c 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 * from cmv_mat_view -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view -#### A masked pattern was here #### -POSTHOOK: query: select * from cmv_mat_view -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view -#### 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: create materialized view if not exists cmv_mat_view2 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_view2 -POSTHOOK: query: create materialized view if not exists cmv_mat_view2 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_view2 -PREHOOK: query: desc formatted cmv_mat_view2 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view2 -POSTHOOK: query: desc formatted cmv_mat_view2 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view2 -# 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\"} - 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: select * from cmv_mat_view2 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view2 -#### A masked pattern was here #### -POSTHOOK: query: select * from cmv_mat_view2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view2 -#### A masked pattern was here #### -1 10.30 -2 3.14 -2 172342.20 -3 978.76 -3 9.80 -PREHOOK: query: create materialized view if not exists cmv_mat_view3 as select * from cmv_basetable where a > 1 -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 if not exists cmv_mat_view3 as select * from cmv_basetable where a > 1 -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view3 -PREHOOK: query: select * from cmv_mat_view3 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -POSTHOOK: query: select * from cmv_mat_view3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view3 -#### A masked pattern was here #### -2 bob 3.14 -2 bonnie 172342.20 -3 calvin 978.76 -3 charlie 9.80 -PREHOOK: query: create materialized view cmv_mat_view4 comment 'this is a comment' as select a, sum(c) from cmv_basetable group by a -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view4 -POSTHOOK: query: create materialized view cmv_mat_view4 comment 'this is a comment' as select a, sum(c) from cmv_basetable group by a -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view4 -PREHOOK: query: select * from cmv_mat_view4 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view4 -#### A masked pattern was here #### -POSTHOOK: query: select * from cmv_mat_view4 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view4 -#### A masked pattern was here #### -1 10.30 -2 172345.34 -3 988.56 -PREHOOK: query: describe extended cmv_mat_view4 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@cmv_mat_view4 -POSTHOOK: query: describe extended cmv_mat_view4 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@cmv_mat_view4 -a int -_c1 decimal(20,2) - -#### A masked pattern was here #### -PREHOOK: query: create table cmv_basetable2 (d int, e varchar(256), f decimal(10,2)) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_basetable2 -POSTHOOK: query: create table cmv_basetable2 (d int, e varchar(256), f decimal(10,2)) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_basetable2 -PREHOOK: query: insert into cmv_basetable2 values (4, 'alfred', 100.30),(4, 'bob', 6133.14),(5, 'bonnie', 172.2),(6, 'calvin', 8.76),(17, 'charlie', 13144339.8) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@cmv_basetable2 -POSTHOOK: query: insert into cmv_basetable2 values (4, 'alfred', 100.30),(4, 'bob', 6133.14),(5, 'bonnie', 172.2),(6, 'calvin', 8.76),(17, 'charlie', 13144339.8) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@cmv_basetable2 -POSTHOOK: Lineage: cmv_basetable2.d SCRIPT [] -POSTHOOK: Lineage: cmv_basetable2.e SCRIPT [] -POSTHOOK: Lineage: cmv_basetable2.f SCRIPT [] -PREHOOK: query: create materialized view cmv_mat_view5 tblproperties ('key'='value') as select a, b, d, c, f from cmv_basetable t1 join cmv_basetable2 t2 on (t1.b = t2.e) -PREHOOK: type: CREATE_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_basetable -PREHOOK: Input: default@cmv_basetable2 -PREHOOK: Output: database:default -PREHOOK: Output: default@cmv_mat_view5 -POSTHOOK: query: create materialized view cmv_mat_view5 tblproperties ('key'='value') as select a, b, d, c, f from cmv_basetable t1 join cmv_basetable2 t2 on (t1.b = t2.e) -POSTHOOK: type: CREATE_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_basetable -POSTHOOK: Input: default@cmv_basetable2 -POSTHOOK: Output: database:default -POSTHOOK: Output: default@cmv_mat_view5 -PREHOOK: query: select * from cmv_mat_view5 -PREHOOK: type: QUERY -PREHOOK: Input: default@cmv_mat_view5 -#### A masked pattern was here #### -POSTHOOK: query: select * from cmv_mat_view5 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@cmv_mat_view5 -#### A masked pattern was here #### -1 alfred 4 10.30 100.30 -2 bob 4 3.14 6133.14 -2 bonnie 5 172342.20 172.20 -3 calvin 6 978.76 8.76 -3 charlie 17 9.80 13144339.80 -PREHOOK: query: show tblproperties cmv_mat_view5 -PREHOOK: type: SHOW_TBLPROPERTIES -POSTHOOK: query: show tblproperties cmv_mat_view5 -POSTHOOK: type: SHOW_TBLPROPERTIES -COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} -key value -numFiles 1 -numRows 5 -rawDataSize 1605 -totalSize 701 -#### A masked pattern was here #### -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: 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: 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: 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 -PREHOOK: query: drop materialized view cmv_mat_view5 -PREHOOK: type: DROP_MATERIALIZED_VIEW -PREHOOK: Input: default@cmv_mat_view5 -PREHOOK: Output: default@cmv_mat_view5 -POSTHOOK: query: drop materialized view cmv_mat_view5 -POSTHOOK: type: DROP_MATERIALIZED_VIEW -POSTHOOK: Input: default@cmv_mat_view5 -POSTHOOK: Output: default@cmv_mat_view5