[06/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_2.q.out -- diff --git a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out b/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out deleted file mode 100644 index d561208..000 --- a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out +++ /dev/null @@ -1,1981 +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, - `d_la
[06/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_2.q.out -- diff --git a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out b/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out deleted file mode 100644 index d561208..000 --- a/ql/src/test/results/clientpositive/materialized_view_rewrite_ssb_2.q.out +++ /dev/null @@ -1,1981 +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, - `d_la