http://git-wip-us.apache.org/repos/asf/hive/blob/5179558c/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 index c51357d..c2c6a15 100644 --- a/ql/src/test/results/clientpositive/materialized_view_create.q.out +++ b/ql/src/test/results/clientpositive/materialized_view_create.q.out @@ -18,12 +18,12 @@ POSTHOOK: Lineage: cmv_basetable.a EXPRESSION [(values__tmp__table__1)values__tm POSTHOOK: Lineage: cmv_basetable.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: cmv_basetable.c EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] PREHOOK: query: create materialized view cmv_mat_view as select a, b, c from cmv_basetable -PREHOOK: type: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@cmv_basetable POSTHOOK: Output: database:default POSTHOOK: Output: default@cmv_mat_view @@ -35,18 +35,18 @@ POSTHOOK: query: select * from cmv_mat_view POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_mat_view #### A masked pattern was here #### -1 alfred 10.3 +1 alfred 10.30 2 bob 3.14 -2 bonnie 172342.2 +2 bonnie 172342.20 3 calvin 978.76 -3 charlie 9.8 +3 charlie 9.80 PREHOOK: query: create materialized view if not exists cmv_mat_view2 as select a, c from cmv_basetable -PREHOOK: type: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@cmv_basetable POSTHOOK: Output: database:default POSTHOOK: Output: default@cmv_mat_view2 @@ -58,18 +58,18 @@ POSTHOOK: query: select * from cmv_mat_view2 POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_mat_view2 #### A masked pattern was here #### -1 10.3 +1 10.30 2 3.14 -2 172342.2 +2 172342.20 3 978.76 -3 9.8 +3 9.80 PREHOOK: query: create materialized view if not exists cmv_mat_view3 as select * from cmv_basetable where a > 1 -PREHOOK: type: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@cmv_basetable POSTHOOK: Output: database:default POSTHOOK: Output: default@cmv_mat_view3 @@ -82,16 +82,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_mat_view3 #### A masked pattern was here #### 2 bob 3.14 -2 bonnie 172342.2 +2 bonnie 172342.20 3 calvin 978.76 -3 charlie 9.8 +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: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@cmv_basetable POSTHOOK: Output: database:default POSTHOOK: Output: default@cmv_mat_view4 @@ -103,7 +103,7 @@ POSTHOOK: query: select * from cmv_mat_view4 POSTHOOK: type: QUERY POSTHOOK: Input: default@cmv_mat_view4 #### A masked pattern was here #### -1 10.3 +1 10.30 2 172345.34 3 988.56 PREHOOK: query: describe extended cmv_mat_view4 @@ -113,7 +113,7 @@ POSTHOOK: query: describe extended cmv_mat_view4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@cmv_mat_view4 a int -_c1 decimal(20,2) +c1 decimal(20,2) #### A masked pattern was here #### PREHOOK: query: create table cmv_basetable2 (d int, e varchar(256), f decimal(10,2)) @@ -136,13 +136,13 @@ POSTHOOK: Lineage: cmv_basetable2.d EXPRESSION [(values__tmp__table__2)values__t POSTHOOK: Lineage: cmv_basetable2.e EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] POSTHOOK: Lineage: cmv_basetable2.f EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ] 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: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@cmv_basetable POSTHOOK: Input: default@cmv_basetable2 POSTHOOK: Output: database:default @@ -155,19 +155,16 @@ 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.3 100.3 -2 bob 4 3.14 6133 -2 bonnie 5 172342.2 172.2 +1 alfred 4 10.30 100.30 +2 bob 4 3.14 6133.00 +2 bonnie 5 172342.20 172.20 3 calvin 6 978.76 8.76 -3 charlie 17 9.8 13144339.8 +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 false key value numFiles 1 -numRows -1 -rawDataSize -1 -totalSize 730 +totalSize 710 #### A masked pattern was here ####
http://git-wip-us.apache.org/repos/asf/hive/blob/5179558c/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 new file mode 100644 index 0000000..5714198 --- /dev/null +++ b/ql/src/test/results/clientpositive/materialized_view_describe.q.out @@ -0,0 +1,335 @@ +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: default@values__tmp__table__1 +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: default@values__tmp__table__1 +POSTHOOK: Output: default@cmv_basetable +POSTHOOK: Lineage: cmv_basetable.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Lineage: cmv_basetable.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: cmv_basetable.c EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +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: + comment this is the first view + key foo + numFiles 1 + 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: [] +PREHOOK: query: show tblproperties cmv_mat_view +PREHOOK: type: SHOW_TBLPROPERTIES +POSTHOOK: query: show tblproperties cmv_mat_view +POSTHOOK: type: SHOW_TBLPROPERTIES +comment this is the first view +key foo +numFiles 1 +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: + comment this is the second view + key alice + key2 bob + numFiles 1 + 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.IgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +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: + comment this is the third view + numFiles 1 + 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: [] +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: + comment this is the last view + numFiles 1 + 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.IgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +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/5179558c/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 index ed99a09..3cf13d0 100644 --- a/ql/src/test/results/clientpositive/materialized_view_drop.q.out +++ b/ql/src/test/results/clientpositive/materialized_view_drop.q.out @@ -1,10 +1,10 @@ PREHOOK: query: create materialized view dmv_mat_view as select cint, cstring1 from alltypesorc where cint < 0 -PREHOOK: type: CREATEVIEW +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: CREATEVIEW +POSTHOOK: type: CREATE_MATERIALIZED_VIEW POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: database:default POSTHOOK: Output: default@dmv_mat_view @@ -20,17 +20,17 @@ columns:struct columns { i32 cint, string cstring1} partitioned:false partitionColumns: totalNumberFiles:1 -totalFileSize:47146 -maxFileSize:47146 -minFileSize:47146 +totalFileSize:47140 +maxFileSize:47140 +minFileSize:47140 #### A masked pattern was here #### PREHOOK: query: drop materialized view dmv_mat_view -PREHOOK: type: DROPTABLE +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: DROPTABLE +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 http://git-wip-us.apache.org/repos/asf/hive/blob/5179558c/ql/src/test/results/clientpositive/materialized_view_rebuild.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/materialized_view_rebuild.q.out b/ql/src/test/results/clientpositive/materialized_view_rebuild.q.out deleted file mode 100644 index 9bede0d..0000000 --- a/ql/src/test/results/clientpositive/materialized_view_rebuild.q.out +++ /dev/null @@ -1,67 +0,0 @@ -PREHOOK: query: create table rmv_table (cint int, cstring1 string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@rmv_table -POSTHOOK: query: create table rmv_table (cint int, cstring1 string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@rmv_table -PREHOOK: query: insert into rmv_table values(1, 'fred'), (10, 'wilma') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@rmv_table -POSTHOOK: query: insert into rmv_table values(1, 'fred'), (10, 'wilma') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@rmv_table -POSTHOOK: Lineage: rmv_table.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: rmv_table.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: create materialized view rmv_mat_view as select cint, cstring1 from rmv_table where cint < 10 -PREHOOK: type: CREATEVIEW -PREHOOK: Input: default@rmv_table -PREHOOK: Output: database:default -PREHOOK: Output: default@rmv_mat_view -POSTHOOK: query: create materialized view rmv_mat_view as select cint, cstring1 from rmv_table where cint < 10 -POSTHOOK: type: CREATEVIEW -POSTHOOK: Input: default@rmv_table -POSTHOOK: Output: database:default -POSTHOOK: Output: default@rmv_mat_view -PREHOOK: query: select * from rmv_mat_view -PREHOOK: type: QUERY -PREHOOK: Input: default@rmv_mat_view -#### A masked pattern was here #### -POSTHOOK: query: select * from rmv_mat_view -POSTHOOK: type: QUERY -POSTHOOK: Input: default@rmv_mat_view -#### A masked pattern was here #### -1 fred -PREHOOK: query: insert into rmv_table values(2, 'barney'), (11, 'betty') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@rmv_table -POSTHOOK: query: insert into rmv_table values(2, 'barney'), (11, 'betty') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@rmv_table -POSTHOOK: Lineage: rmv_table.cint EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: rmv_table.cstring1 SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: alter materialized view rmv_mat_view rebuild -PREHOOK: type: CREATEVIEW -PREHOOK: Input: default@rmv_table -PREHOOK: Output: database:default -PREHOOK: Output: default@rmv_mat_view -POSTHOOK: query: alter materialized view rmv_mat_view rebuild -POSTHOOK: type: CREATEVIEW -POSTHOOK: Input: default@rmv_table -POSTHOOK: Output: database:default -POSTHOOK: Output: default@rmv_mat_view -PREHOOK: query: select * from rmv_mat_view -PREHOOK: type: QUERY -PREHOOK: Input: default@rmv_mat_view -#### A masked pattern was here #### -POSTHOOK: query: select * from rmv_mat_view -POSTHOOK: type: QUERY -POSTHOOK: Input: default@rmv_mat_view -#### A masked pattern was here #### -1 fred -2 barney
