You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2018/04/10 04:41:06 UTC
hive git commit: HIVE-19146 : Delete dangling q.out
Repository: hive
Updated Branches:
refs/heads/master 91a0cb8fa -> dcd9b5941
HIVE-19146 : Delete dangling q.out
Signed-off-by: Ashutosh Chauhan <ha...@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 <ha...@apache.org>
Authored: Mon Apr 9 21:30:34 2018 -0700
Committer: Ashutosh Chauhan <ha...@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