[07/24] hive git commit: HIVE-18839: Implement incremental rebuild for materialized views (only insert operations in source tables) (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/c695c70b/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
--
diff --git
a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
b/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
deleted file mode 100644
index bc42df0..000
--- a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
+++ /dev/null
@@ -1,1975 +0,0 @@
-PREHOOK: query: CREATE TABLE `customer_ext`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@customer_ext
-POSTHOOK: query: CREATE TABLE `customer_ext`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@customer_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/customer/' into
table `customer_ext`
-PREHOOK: type: LOAD
- A masked pattern was here
-PREHOOK: Output: default@customer_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/customer/' into
table `customer_ext`
-POSTHOOK: type: LOAD
- A masked pattern was here
-POSTHOOK: Output: default@customer_ext
-PREHOOK: query: CREATE TABLE `customer`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string,
- primary key (`c_custkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@customer
-POSTHOOK: query: CREATE TABLE `customer`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string,
- primary key (`c_custkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@customer
-PREHOOK: query: INSERT INTO `customer`
-SELECT * FROM `customer_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@customer_ext
-PREHOOK: Output: default@customer
-POSTHOOK: query: INSERT INTO `customer`
-SELECT * FROM `customer_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@customer_ext
-POSTHOOK: Output: default@customer
-POSTHOOK: Lineage: customer.c_address SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_address, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_city SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_city, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_custkey SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_custkey, type:bigint,
comment:null), ]
-POSTHOOK: Lineage: customer.c_mktsegment SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_mktsegment, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_name SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_name, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_nation SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_nation, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_phone SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_phone, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_region SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_region, type:string,
comment:null), ]
-PREHOOK: query: CREATE TABLE `dates_ext`(
- `d_datekey` bigint,
- `d_date` string,
- `d_dayofweek` string,
- `d_month` string,
- `d_year` int,
- `d_yearmonthnum` int,
- `d_yearmonth` string,
- `d_daynuminweek` int,
- `d_daynuminmonth` int,
- `d_daynuminyear` int,
- `d_monthnuminyear` int,
- `d_weeknuminyear` int,
- `d_sellingseason` string,
- `d_lastdayinweekfl` int,
- `d_lastdayinmonthfl` int,
- `d_holidayfl` int ,
- `d_weekdayfl`int)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dates_ext
-POSTHOOK: query: CREATE TABLE `dates_ext`(
- `d_datekey` bigint,
- `d_date` string,
- `d_dayofweek` string,
- `d_month` string,
- `d_year` int,
- `d_yearmonthnum` int,
- `d_yearmonth` string,
- `d_daynuminweek` int,
- `d_daynuminmonth` int,
- `d_daynuminyear` int,
- `d_monthnuminyear` int,
- `d_weeknuminyear` int,
- `d_sellingseason` string,
- `d_lastdayinweekfl` int,
-
[07/24] hive git commit: HIVE-18839: Implement incremental rebuild for materialized views (only insert operations in source tables) (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/be420098/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
--
diff --git
a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
b/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
deleted file mode 100644
index bc42df0..000
--- a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb.q.out
+++ /dev/null
@@ -1,1975 +0,0 @@
-PREHOOK: query: CREATE TABLE `customer_ext`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@customer_ext
-POSTHOOK: query: CREATE TABLE `customer_ext`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@customer_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/customer/' into
table `customer_ext`
-PREHOOK: type: LOAD
- A masked pattern was here
-PREHOOK: Output: default@customer_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/customer/' into
table `customer_ext`
-POSTHOOK: type: LOAD
- A masked pattern was here
-POSTHOOK: Output: default@customer_ext
-PREHOOK: query: CREATE TABLE `customer`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string,
- primary key (`c_custkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@customer
-POSTHOOK: query: CREATE TABLE `customer`(
- `c_custkey` bigint,
- `c_name` string,
- `c_address` string,
- `c_city` string,
- `c_nation` string,
- `c_region` string,
- `c_phone` string,
- `c_mktsegment` string,
- primary key (`c_custkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@customer
-PREHOOK: query: INSERT INTO `customer`
-SELECT * FROM `customer_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@customer_ext
-PREHOOK: Output: default@customer
-POSTHOOK: query: INSERT INTO `customer`
-SELECT * FROM `customer_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@customer_ext
-POSTHOOK: Output: default@customer
-POSTHOOK: Lineage: customer.c_address SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_address, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_city SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_city, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_custkey SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_custkey, type:bigint,
comment:null), ]
-POSTHOOK: Lineage: customer.c_mktsegment SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_mktsegment, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_name SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_name, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_nation SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_nation, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_phone SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_phone, type:string,
comment:null), ]
-POSTHOOK: Lineage: customer.c_region SIMPLE
[(customer_ext)customer_ext.FieldSchema(name:c_region, type:string,
comment:null), ]
-PREHOOK: query: CREATE TABLE `dates_ext`(
- `d_datekey` bigint,
- `d_date` string,
- `d_dayofweek` string,
- `d_month` string,
- `d_year` int,
- `d_yearmonthnum` int,
- `d_yearmonth` string,
- `d_daynuminweek` int,
- `d_daynuminmonth` int,
- `d_daynuminyear` int,
- `d_monthnuminyear` int,
- `d_weeknuminyear` int,
- `d_sellingseason` string,
- `d_lastdayinweekfl` int,
- `d_lastdayinmonthfl` int,
- `d_holidayfl` int ,
- `d_weekdayfl`int)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dates_ext
-POSTHOOK: query: CREATE TABLE `dates_ext`(
- `d_datekey` bigint,
- `d_date` string,
- `d_dayofweek` string,
- `d_month` string,
- `d_year` int,
- `d_yearmonthnum` int,
- `d_yearmonth` string,
- `d_daynuminweek` int,
- `d_daynuminmonth` int,
- `d_daynuminyear` int,
- `d_monthnuminyear` int,
- `d_weeknuminyear` int,
- `d_sellingseason` string,
- `d_lastdayinweekfl` int,
-
