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..0000000
--- 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_lastdayinmonthfl` int,
-  `d_holidayfl` int ,
-  `d_weekdayfl`int)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@dates_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/date/' into table 
`dates_ext`
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@dates_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/date/' into 
table `dates_ext`
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@dates_ext
-PREHOOK: query: CREATE TABLE `dates`(
-  `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,
-  primary key (`d_datekey`) disable rely
-)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dates
-POSTHOOK: query: CREATE TABLE `dates`(
-  `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,
-  primary key (`d_datekey`) disable rely
-)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@dates
-PREHOOK: query: INSERT INTO `dates`
-SELECT * FROM `dates_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dates_ext
-PREHOOK: Output: default@dates
-POSTHOOK: query: INSERT INTO `dates`
-SELECT * FROM `dates_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dates_ext
-POSTHOOK: Output: default@dates
-POSTHOOK: Lineage: dates.d_date SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_date, type:string, comment:null), ]
-POSTHOOK: Lineage: dates.d_datekey SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_datekey, type:bigint, comment:null), ]
-POSTHOOK: Lineage: dates.d_daynuminmonth SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_daynuminmonth, type:int, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_daynuminweek SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_daynuminweek, type:int, comment:null), 
]
-POSTHOOK: Lineage: dates.d_daynuminyear SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_daynuminyear, type:int, comment:null), 
]
-POSTHOOK: Lineage: dates.d_dayofweek SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_dayofweek, type:string, comment:null), 
]
-POSTHOOK: Lineage: dates.d_holidayfl SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_holidayfl, type:int, comment:null), ]
-POSTHOOK: Lineage: dates.d_lastdayinmonthfl SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_lastdayinmonthfl, type:int, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_lastdayinweekfl SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_lastdayinweekfl, type:int, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_month SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_month, type:string, comment:null), ]
-POSTHOOK: Lineage: dates.d_monthnuminyear SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_monthnuminyear, type:int, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_sellingseason SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_sellingseason, type:string, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_weekdayfl SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_weekdayfl, type:int, comment:null), ]
-POSTHOOK: Lineage: dates.d_weeknuminyear SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_weeknuminyear, type:int, 
comment:null), ]
-POSTHOOK: Lineage: dates.d_year SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_year, type:int, comment:null), ]
-POSTHOOK: Lineage: dates.d_yearmonth SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_yearmonth, type:string, comment:null), 
]
-POSTHOOK: Lineage: dates.d_yearmonthnum SIMPLE 
[(dates_ext)dates_ext.FieldSchema(name:d_yearmonthnum, type:int, comment:null), 
]
-PREHOOK: query: CREATE TABLE `ssb_part_ext`(
-  `p_partkey` bigint, 
-  `p_name` string, 
-  `p_mfgr` string, 
-  `p_category` string, 
-  `p_brand1` string, 
-  `p_color` string, 
-  `p_type` string, 
-  `p_size` int, 
-  `p_container` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ssb_part_ext
-POSTHOOK: query: CREATE TABLE `ssb_part_ext`(
-  `p_partkey` bigint, 
-  `p_name` string, 
-  `p_mfgr` string, 
-  `p_category` string, 
-  `p_brand1` string, 
-  `p_color` string, 
-  `p_type` string, 
-  `p_size` int, 
-  `p_container` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ssb_part_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/part/' into table 
`ssb_part_ext`
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@ssb_part_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/part/' into 
table `ssb_part_ext`
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@ssb_part_ext
-PREHOOK: query: CREATE TABLE `ssb_part`(
-  `p_partkey` bigint, 
-  `p_name` string, 
-  `p_mfgr` string, 
-  `p_category` string, 
-  `p_brand1` string, 
-  `p_color` string, 
-  `p_type` string, 
-  `p_size` int, 
-  `p_container` string,
-  primary key (`p_partkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ssb_part
-POSTHOOK: query: CREATE TABLE `ssb_part`(
-  `p_partkey` bigint, 
-  `p_name` string, 
-  `p_mfgr` string, 
-  `p_category` string, 
-  `p_brand1` string, 
-  `p_color` string, 
-  `p_type` string, 
-  `p_size` int, 
-  `p_container` string,
-  primary key (`p_partkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ssb_part
-PREHOOK: query: INSERT INTO `ssb_part`
-SELECT * FROM `ssb_part_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@ssb_part_ext
-PREHOOK: Output: default@ssb_part
-POSTHOOK: query: INSERT INTO `ssb_part`
-SELECT * FROM `ssb_part_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@ssb_part_ext
-POSTHOOK: Output: default@ssb_part
-POSTHOOK: Lineage: ssb_part.p_brand1 SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_brand1, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_category SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_category, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_color SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_color, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_container SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_container, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_mfgr SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_mfgr, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_name SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_name, type:string, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_partkey SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_partkey, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_size SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_size, type:int, comment:null), ]
-POSTHOOK: Lineage: ssb_part.p_type SIMPLE 
[(ssb_part_ext)ssb_part_ext.FieldSchema(name:p_type, type:string, 
comment:null), ]
-PREHOOK: query: CREATE TABLE `supplier_ext`(
-  `s_suppkey` bigint, 
-  `s_name` string, 
-  `s_address` string, 
-  `s_city` string, 
-  `s_nation` string, 
-  `s_region` string, 
-  `s_phone` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@supplier_ext
-POSTHOOK: query: CREATE TABLE `supplier_ext`(
-  `s_suppkey` bigint, 
-  `s_name` string, 
-  `s_address` string, 
-  `s_city` string, 
-  `s_nation` string, 
-  `s_region` string, 
-  `s_phone` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@supplier_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/supplier/' into 
table `supplier_ext`
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@supplier_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/supplier/' into 
table `supplier_ext`
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@supplier_ext
-PREHOOK: query: CREATE TABLE `supplier`(
-  `s_suppkey` bigint, 
-  `s_name` string, 
-  `s_address` string, 
-  `s_city` string, 
-  `s_nation` string, 
-  `s_region` string, 
-  `s_phone` string,
-  primary key (`s_suppkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@supplier
-POSTHOOK: query: CREATE TABLE `supplier`(
-  `s_suppkey` bigint, 
-  `s_name` string, 
-  `s_address` string, 
-  `s_city` string, 
-  `s_nation` string, 
-  `s_region` string, 
-  `s_phone` string,
-  primary key (`s_suppkey`) disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@supplier
-PREHOOK: query: INSERT INTO `supplier`
-SELECT * FROM `supplier_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@supplier_ext
-PREHOOK: Output: default@supplier
-POSTHOOK: query: INSERT INTO `supplier`
-SELECT * FROM `supplier_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@supplier_ext
-POSTHOOK: Output: default@supplier
-POSTHOOK: Lineage: supplier.s_address SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_address, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_city SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_city, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_name SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_name, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_nation SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_nation, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_phone SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_phone, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_region SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_region, type:string, 
comment:null), ]
-POSTHOOK: Lineage: supplier.s_suppkey SIMPLE 
[(supplier_ext)supplier_ext.FieldSchema(name:s_suppkey, type:bigint, 
comment:null), ]
-PREHOOK: query: CREATE TABLE `lineorder_ext`(
-  `lo_orderkey` bigint, 
-  `lo_linenumber` int, 
-  `lo_custkey` bigint not null disable rely,
-  `lo_partkey` bigint not null disable rely,
-  `lo_suppkey` bigint not null disable rely,
-  `lo_orderdate` bigint not null disable rely,
-  `lo_ordpriority` string, 
-  `lo_shippriority` string, 
-  `lo_quantity` double, 
-  `lo_extendedprice` double, 
-  `lo_ordtotalprice` double, 
-  `lo_discount` double, 
-  `lo_revenue` double, 
-  `lo_supplycost` double, 
-  `lo_tax` double, 
-  `lo_commitdate` bigint, 
-  `lo_shipmode` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@lineorder_ext
-POSTHOOK: query: CREATE TABLE `lineorder_ext`(
-  `lo_orderkey` bigint, 
-  `lo_linenumber` int, 
-  `lo_custkey` bigint not null disable rely,
-  `lo_partkey` bigint not null disable rely,
-  `lo_suppkey` bigint not null disable rely,
-  `lo_orderdate` bigint not null disable rely,
-  `lo_ordpriority` string, 
-  `lo_shippriority` string, 
-  `lo_quantity` double, 
-  `lo_extendedprice` double, 
-  `lo_ordtotalprice` double, 
-  `lo_discount` double, 
-  `lo_revenue` double, 
-  `lo_supplycost` double, 
-  `lo_tax` double, 
-  `lo_commitdate` bigint, 
-  `lo_shipmode` string)
-ROW FORMAT DELIMITED
-FIELDS TERMINATED BY '|'
-STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@lineorder_ext
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/lineorder/' into 
table `lineorder_ext`
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@lineorder_ext
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/ssb/lineorder/' into 
table `lineorder_ext`
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@lineorder_ext
-PREHOOK: query: CREATE TABLE `lineorder`(
-  `lo_orderkey` bigint, 
-  `lo_linenumber` int, 
-  `lo_custkey` bigint not null disable rely,
-  `lo_partkey` bigint not null disable rely,
-  `lo_suppkey` bigint not null disable rely,
-  `lo_orderdate` bigint not null disable rely,
-  `lo_ordpriority` string, 
-  `lo_shippriority` string, 
-  `lo_quantity` double, 
-  `lo_extendedprice` double, 
-  `lo_ordtotalprice` double, 
-  `lo_discount` double, 
-  `lo_revenue` double, 
-  `lo_supplycost` double, 
-  `lo_tax` double, 
-  `lo_commitdate` bigint, 
-  `lo_shipmode` string,
-  primary key (`lo_orderkey`) disable rely,
-  constraint fk1 foreign key (`lo_custkey`) references `customer`(`c_custkey`) 
disable rely,
-  constraint fk2 foreign key (`lo_orderdate`) references `dates`(`d_datekey`) 
disable rely,
-  constraint fk3 foreign key (`lo_partkey`) references `ssb_part`(`p_partkey`) 
disable rely,
-  constraint fk4 foreign key (`lo_suppkey`) references `supplier`(`s_suppkey`) 
disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@lineorder
-POSTHOOK: query: CREATE TABLE `lineorder`(
-  `lo_orderkey` bigint, 
-  `lo_linenumber` int, 
-  `lo_custkey` bigint not null disable rely,
-  `lo_partkey` bigint not null disable rely,
-  `lo_suppkey` bigint not null disable rely,
-  `lo_orderdate` bigint not null disable rely,
-  `lo_ordpriority` string, 
-  `lo_shippriority` string, 
-  `lo_quantity` double, 
-  `lo_extendedprice` double, 
-  `lo_ordtotalprice` double, 
-  `lo_discount` double, 
-  `lo_revenue` double, 
-  `lo_supplycost` double, 
-  `lo_tax` double, 
-  `lo_commitdate` bigint, 
-  `lo_shipmode` string,
-  primary key (`lo_orderkey`) disable rely,
-  constraint fk1 foreign key (`lo_custkey`) references `customer`(`c_custkey`) 
disable rely,
-  constraint fk2 foreign key (`lo_orderdate`) references `dates`(`d_datekey`) 
disable rely,
-  constraint fk3 foreign key (`lo_partkey`) references `ssb_part`(`p_partkey`) 
disable rely,
-  constraint fk4 foreign key (`lo_suppkey`) references `supplier`(`s_suppkey`) 
disable rely)
-STORED AS ORC
-TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@lineorder
-PREHOOK: query: INSERT INTO `lineorder`
-SELECT * FROM `lineorder_ext`
-PREHOOK: type: QUERY
-PREHOOK: Input: default@lineorder_ext
-PREHOOK: Output: default@lineorder
-POSTHOOK: query: INSERT INTO `lineorder`
-SELECT * FROM `lineorder_ext`
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@lineorder_ext
-POSTHOOK: Output: default@lineorder
-POSTHOOK: Lineage: lineorder.lo_commitdate SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_commitdate, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_custkey SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_custkey, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_discount SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_discount, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_extendedprice SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_extendedprice, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_linenumber SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_linenumber, type:int, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_orderdate SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_orderdate, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_orderkey SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_orderkey, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_ordpriority SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_ordpriority, type:string, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_ordtotalprice SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_ordtotalprice, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_partkey SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_partkey, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_quantity SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_quantity, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_revenue SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_revenue, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_shipmode SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_shipmode, type:string, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_shippriority SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_shippriority, type:string, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_suppkey SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_suppkey, type:bigint, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_supplycost SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_supplycost, type:double, 
comment:null), ]
-POSTHOOK: Lineage: lineorder.lo_tax SIMPLE 
[(lineorder_ext)lineorder_ext.FieldSchema(name:lo_tax, type:double, 
comment:null), ]
-PREHOOK: query: analyze table customer compute statistics for columns
-PREHOOK: type: QUERY
-PREHOOK: Input: default@customer
-PREHOOK: Output: default@customer
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table customer compute statistics for columns
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@customer
-POSTHOOK: Output: default@customer
-#### A masked pattern was here ####
-PREHOOK: query: analyze table dates compute statistics for columns
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dates
-PREHOOK: Output: default@dates
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table dates compute statistics for columns
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dates
-POSTHOOK: Output: default@dates
-#### A masked pattern was here ####
-PREHOOK: query: analyze table ssb_part compute statistics for columns
-PREHOOK: type: QUERY
-PREHOOK: Input: default@ssb_part
-PREHOOK: Output: default@ssb_part
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table ssb_part compute statistics for columns
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@ssb_part
-POSTHOOK: Output: default@ssb_part
-#### A masked pattern was here ####
-PREHOOK: query: analyze table supplier compute statistics for columns
-PREHOOK: type: QUERY
-PREHOOK: Input: default@supplier
-PREHOOK: Output: default@supplier
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table supplier compute statistics for columns
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@supplier
-POSTHOOK: Output: default@supplier
-#### A masked pattern was here ####
-PREHOOK: query: analyze table lineorder compute statistics for columns
-PREHOOK: type: QUERY
-PREHOOK: Input: default@lineorder
-PREHOOK: Output: default@lineorder
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table lineorder compute statistics for columns
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@lineorder
-POSTHOOK: Output: default@lineorder
-#### A masked pattern was here ####
-PREHOOK: query: CREATE MATERIALIZED VIEW `ssb_mv` ENABLE REWRITE
-AS
-SELECT
-  cast(d_year || '-' || d_monthnuminyear || '-' || d_daynuminmonth as 
timestamp) as `__time`,
-  c_city,
-  c_nation,
-  c_region,
-  cast(d_weeknuminyear as string) d_weeknuminyear,
-  cast(d_year as string) d_year,
-  d_yearmonth,
-  cast(d_yearmonthnum as string) d_yearmonthnum,
-  cast(lo_discount as string) lo_discount,
-  cast(lo_quantity as string) lo_quantity,
-  p_brand1,
-  p_category,
-  p_mfgr,
-  s_city,
-  s_nation,
-  s_region,
-  lo_revenue,
-  lo_extendedprice * lo_discount discounted_price,
-  lo_revenue - lo_supplycost net_revenue
-FROM
-  customer, dates, lineorder, ssb_part, supplier
-where
-  lo_orderdate = d_datekey
-  and lo_partkey = p_partkey
-  and lo_suppkey = s_suppkey
-  and lo_custkey = c_custkey
-PREHOOK: type: CREATE_MATERIALIZED_VIEW
-PREHOOK: Input: default@customer
-PREHOOK: Input: default@dates
-PREHOOK: Input: default@lineorder
-PREHOOK: Input: default@ssb_part
-PREHOOK: Input: default@supplier
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ssb_mv
-POSTHOOK: query: CREATE MATERIALIZED VIEW `ssb_mv` ENABLE REWRITE
-AS
-SELECT
-  cast(d_year || '-' || d_monthnuminyear || '-' || d_daynuminmonth as 
timestamp) as `__time`,
-  c_city,
-  c_nation,
-  c_region,
-  cast(d_weeknuminyear as string) d_weeknuminyear,
-  cast(d_year as string) d_year,
-  d_yearmonth,
-  cast(d_yearmonthnum as string) d_yearmonthnum,
-  cast(lo_discount as string) lo_discount,
-  cast(lo_quantity as string) lo_quantity,
-  p_brand1,
-  p_category,
-  p_mfgr,
-  s_city,
-  s_nation,
-  s_region,
-  lo_revenue,
-  lo_extendedprice * lo_discount discounted_price,
-  lo_revenue - lo_supplycost net_revenue
-FROM
-  customer, dates, lineorder, ssb_part, supplier
-where
-  lo_orderdate = d_datekey
-  and lo_partkey = p_partkey
-  and lo_suppkey = s_suppkey
-  and lo_custkey = c_custkey
-POSTHOOK: type: CREATE_MATERIALIZED_VIEW
-POSTHOOK: Input: default@customer
-POSTHOOK: Input: default@dates
-POSTHOOK: Input: default@lineorder
-POSTHOOK: Input: default@ssb_part
-POSTHOOK: Input: default@supplier
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ssb_mv
-PREHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_year = 1993
-    and lo_discount between 1 and 3
-    and lo_quantity < 25
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_year = 1993
-    and lo_discount between 1 and 3
-    and lo_quantity < 25
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((UDFToDouble(lo_quantity) < 25.0D) and 
(UDFToInteger(d_year) = 1993) and UDFToDouble(lo_discount) BETWEEN 1.0D AND 
3.0D) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: discounted_price (type: double)
-                outputColumnNames: discounted_price
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(discounted_price)
-                  mode: hash
-                  outputColumnNames: _col0
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          mode: mergepartial
-          outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_yearmonthnum = 199401
-    and lo_discount between 4 and 6
-    and lo_quantity between 26 and 35
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_yearmonthnum = 199401
-    and lo_discount between 4 and 6
-    and lo_quantity between 26 and 35
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((UDFToInteger(d_yearmonthnum) = 199401) and 
UDFToDouble(lo_discount) BETWEEN 4.0D AND 6.0D and UDFToDouble(lo_quantity) 
BETWEEN 26.0D AND 35.0D) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: discounted_price (type: double)
-                outputColumnNames: discounted_price
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(discounted_price)
-                  mode: hash
-                  outputColumnNames: _col0
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          mode: mergepartial
-          outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_weeknuminyear = 6
-    and d_year = 1994
-    and lo_discount between 5 and 7
-    and lo_quantity between 26 and 35
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_extendedprice*lo_discount) as revenue
-from 
-    lineorder, dates
-where 
-    lo_orderdate = d_datekey
-    and d_weeknuminyear = 6
-    and d_year = 1994
-    and lo_discount between 5 and 7
-    and lo_quantity between 26 and 35
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((UDFToInteger(d_weeknuminyear) = 6) and 
(UDFToInteger(d_year) = 1994) and UDFToDouble(lo_discount) BETWEEN 5.0D AND 
7.0D and UDFToDouble(lo_quantity) BETWEEN 26.0D AND 35.0D) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: discounted_price (type: double)
-                outputColumnNames: discounted_price
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(discounted_price)
-                  mode: hash
-                  outputColumnNames: _col0
-                  Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    sort order: 
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          mode: mergepartial
-          outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_category = 'MFGR#12'
-    and s_region = 'AMERICA'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_category = 'MFGR#12'
-    and s_region = 'AMERICA'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((p_category = 'MFGR#12') and (s_region = 'AMERICA')) 
(type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), p_brand1 (type: 
string), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col2)
-                  keys: _col0 (type: int), _col1 (type: string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string)
-                    sort order: ++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col2 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col2 (type: double), _col0 (type: int), _col1 (type: 
string)
-            outputColumnNames: _col0, _col1, _col2
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col1 (type: int), _col2 (type: string)
-              sort order: ++
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: double), KEY.reducesinkkey0 (type: 
int), KEY.reducesinkkey1 (type: string)
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_brand1 between 'MFGR#2221' and 'MFGR#2228'
-    and s_region = 'ASIA'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_brand1 between 'MFGR#2221' and 'MFGR#2228'
-    and s_region = 'ASIA'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((s_region = 'ASIA') and p_brand1 BETWEEN 'MFGR#2221' 
AND 'MFGR#2228') (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), p_brand1 (type: 
string), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col2)
-                  keys: _col0 (type: int), _col1 (type: string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string)
-                    sort order: ++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col2 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col2 (type: double), _col0 (type: int), _col1 (type: 
string)
-            outputColumnNames: _col0, _col1, _col2
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col1 (type: int), _col2 (type: string)
-              sort order: ++
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: double), KEY.reducesinkkey0 (type: 
int), KEY.reducesinkkey1 (type: string)
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_brand1 = 'MFGR#2239'
-    and s_region = 'EUROPE'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    sum(lo_revenue) as lo_revenue, d_year, p_brand1
-from 
-    lineorder, dates, ssb_part, supplier
-where 
-    lo_orderdate = d_datekey
-    and lo_partkey = p_partkey
-    and lo_suppkey = s_suppkey
-    and p_brand1 = 'MFGR#2239'
-    and s_region = 'EUROPE'
-group by 
-    d_year, p_brand1
-order by 
-    d_year, p_brand1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((p_brand1 = 'MFGR#2239') and (s_region = 'EUROPE')) 
(type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), lo_revenue 
(type: double)
-                outputColumnNames: _col0, _col1
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col1)
-                  keys: _col0 (type: int)
-                  mode: hash
-                  outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int)
-                    sort order: +
-                    Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col1 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col1 (type: double), _col0 (type: int)
-            outputColumnNames: _col0, _col1
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col1 (type: int)
-              sort order: +
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: double), KEY.reducesinkkey0 (type: 
int), 'MFGR#2239' (type: string)
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    c_nation, s_nation, d_year,
-    sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and c_region = 'ASIA'
-    and s_region = 'ASIA'
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_nation, s_nation, d_year
-order by 
-    d_year asc, lo_revenue desc
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    c_nation, s_nation, d_year,
-    sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and c_region = 'ASIA'
-    and s_region = 'ASIA'
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_nation, s_nation, d_year
-order by 
-    d_year asc, lo_revenue desc
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((UDFToInteger(d_year) <= 1997) and 
(UDFToInteger(d_year) >= 1992) and (c_region = 'ASIA') and (s_region = 'ASIA')) 
(type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: c_nation (type: string), s_nation (type: string), 
UDFToInteger(d_year) (type: int), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col2 (type: int), _col0 (type: string), _col1 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col1 (type: string), _col2 (type: string), _col0 
(type: int), _col3 (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col2 (type: int), _col3 (type: double)
-              sort order: +-
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), 
KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and c_nation = 'UNITED STATES'
-    and s_nation = 'UNITED STATES'
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and c_nation = 'UNITED STATES'
-    and s_nation = 'UNITED STATES'
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: ((UDFToInteger(d_year) <= 1997) and 
(UDFToInteger(d_year) >= 1992) and (c_nation = 'UNITED STATES') and (s_nation = 
'UNITED STATES')) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: c_city (type: string), s_city (type: string), 
UDFToInteger(d_year) (type: int), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col2 (type: int), _col0 (type: string), _col1 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col1 (type: string), _col2 (type: string), _col0 
(type: int), _col3 (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col2 (type: int), _col3 (type: double)
-              sort order: +-
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), 
KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and (c_city='UNITED KI1' or c_city='UNITED KI5')
-    and (s_city='UNITED KI1' or s_city='UNITED KI5')
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and (c_city='UNITED KI1' or c_city='UNITED KI5')
-    and (s_city='UNITED KI1' or s_city='UNITED KI5')
-    and d_year >= 1992 and d_year <= 1997
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) 
and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and 
(UDFToInteger(d_year) <= 1997) and (UDFToInteger(d_year) >= 1992)) (type: 
boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: c_city (type: string), s_city (type: string), 
UDFToInteger(d_year) (type: int), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col2 (type: int), _col0 (type: string), _col1 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col1 (type: string), _col2 (type: string), _col0 
(type: int), _col3 (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col2 (type: int), _col3 (type: double)
-              sort order: +-
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), 
KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and (c_city='UNITED KI1' or c_city='UNITED KI5')
-    and (s_city='UNITED KI1' or s_city='UNITED KI5')
-    and d_yearmonth = 'Dec1997'
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    c_city, s_city, d_year, sum(lo_revenue) as lo_revenue
-from 
-    customer, lineorder, supplier, dates
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_orderdate = d_datekey
-    and (c_city='UNITED KI1' or c_city='UNITED KI5')
-    and (s_city='UNITED KI1' or s_city='UNITED KI5')
-    and d_yearmonth = 'Dec1997'
-group by 
-    c_city, s_city, d_year
-order by 
-    d_year asc, lo_revenue desc
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: (((c_city = 'UNITED KI1') or (c_city = 'UNITED KI5')) 
and ((s_city = 'UNITED KI1') or (s_city = 'UNITED KI5')) and (d_yearmonth = 
'Dec1997')) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: c_city (type: string), s_city (type: string), 
UDFToInteger(d_year) (type: int), lo_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col2 (type: int), _col0 (type: string), _col1 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          Select Operator
-            expressions: _col1 (type: string), _col2 (type: string), _col0 
(type: int), _col3 (type: double)
-            outputColumnNames: _col0, _col1, _col2, _col3
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            File Output Operator
-              compressed: false
-              table:
-                  input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col2 (type: int), _col3 (type: double)
-              sort order: +-
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: VALUE._col0 (type: string), VALUE._col1 (type: string), 
KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    d_year, c_nation,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_region = 'AMERICA'
-    and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
-group by 
-    d_year, c_nation
-order by 
-    d_year, c_nation
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    d_year, c_nation,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_region = 'AMERICA'
-    and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
-group by 
-    d_year, c_nation
-order by 
-    d_year, c_nation
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: (((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) and 
(c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), c_nation (type: 
string), net_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col2)
-                  keys: _col0 (type: int), _col1 (type: string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string)
-                    sort order: ++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col2 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col0 (type: int), _col1 (type: string)
-              sort order: ++
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col2 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string), VALUE._col0 (type: double)
-          outputColumnNames: _col0, _col1, _col2
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    d_year, s_nation, p_category,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_region = 'AMERICA'
-    and (d_year = 1997 or d_year = 1998)
-    and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
-group by 
-    d_year, s_nation, p_category
-order by 
-    d_year, s_nation, p_category
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    d_year, s_nation, p_category,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_region = 'AMERICA'
-    and (d_year = 1997 or d_year = 1998)
-    and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
-group by 
-    d_year, s_nation, p_category
-order by 
-    d_year, s_nation, p_category
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: (((UDFToInteger(d_year) = 1997) or 
(UDFToInteger(d_year) = 1998)) and ((p_mfgr = 'MFGR#1') or (p_mfgr = 'MFGR#2')) 
and (c_region = 'AMERICA') and (s_region = 'AMERICA')) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), s_nation (type: 
string), p_category (type: string), net_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col0 (type: int), _col1 (type: string), _col2 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col0 (type: int), _col1 (type: string), _col2 
(type: string)
-              sort order: +++
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string), KEY.reducesinkkey2 (type: string), VALUE._col0 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: explain
-select 
-    d_year, s_city, p_brand1,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_nation = 'UNITED STATES'
-    and (d_year = 1997 or d_year = 1998)
-    and p_category = 'MFGR#14'
-group by 
-    d_year, s_city, p_brand1
-order by 
-    d_year, s_city, p_brand1
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select 
-    d_year, s_city, p_brand1,
-    sum(lo_revenue - lo_supplycost) as profit
-from 
-    dates, customer, supplier, ssb_part, lineorder
-where 
-    lo_custkey = c_custkey
-    and lo_suppkey = s_suppkey
-    and lo_partkey = p_partkey
-    and lo_orderdate = d_datekey
-    and c_region = 'AMERICA'
-    and s_nation = 'UNITED STATES'
-    and (d_year = 1997 or d_year = 1998)
-    and p_category = 'MFGR#14'
-group by 
-    d_year, s_city, p_brand1
-order by 
-    d_year, s_city, p_brand1
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-2 depends on stages: Stage-1
-  Stage-0 depends on stages: Stage-2
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: default.ssb_mv
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            Filter Operator
-              predicate: (((UDFToInteger(d_year) = 1997) or 
(UDFToInteger(d_year) = 1998)) and (c_region = 'AMERICA') and (p_category = 
'MFGR#14') and (s_nation = 'UNITED STATES')) (type: boolean)
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              Select Operator
-                expressions: UDFToInteger(d_year) (type: int), s_city (type: 
string), p_brand1 (type: string), net_revenue (type: double)
-                outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                Group By Operator
-                  aggregations: sum(_col3)
-                  keys: _col0 (type: int), _col1 (type: string), _col2 (type: 
string)
-                  mode: hash
-                  outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                  Reduce Output Operator
-                    key expressions: _col0 (type: int), _col1 (type: string), 
_col2 (type: string)
-                    sort order: +++
-                    Map-reduce partition columns: _col0 (type: int), _col1 
(type: string), _col2 (type: string)
-                    Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 
Column stats: NONE
-                    value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Group By Operator
-          aggregations: sum(VALUE._col0)
-          keys: KEY._col0 (type: int), KEY._col1 (type: string), KEY._col2 
(type: string)
-          mode: mergepartial
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-2
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Reduce Output Operator
-              key expressions: _col0 (type: int), _col1 (type: string), _col2 
(type: string)
-              sort order: +++
-              Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-              value expressions: _col3 (type: double)
-      Reduce Operator Tree:
-        Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string), KEY.reducesinkkey2 (type: string), VALUE._col0 (type: double)
-          outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column 
stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: DROP MATERIALIZED VIEW `ssb_mv`
-PREHOOK: type: DROP_MATERIALIZED_VIEW
-PREHOOK: Input: default@ssb_mv
-PREHOOK: Output: default@ssb_mv
-POSTHOOK: query: DROP MATERIALIZED VIEW `ssb_mv`
-POSTHOOK: type: DROP_MATERIALIZED_VIEW
-POSTHOOK: Input: default@ssb_mv
-POSTHOOK: Output: default@ssb_mv

Reply via email to