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..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
