http://git-wip-us.apache.org/repos/asf/hive/blob/9244fdc7/ql/src/test/results/clientpositive/perf/query13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query13.q.out
b/ql/src/test/results/clientpositive/perf/query13.q.out
deleted file mode 100644
index 7cb5449..0000000
--- a/ql/src/test/results/clientpositive/perf/query13.q.out
+++ /dev/null
@@ -1,205 +0,0 @@
-PREHOOK: query: explain
-select avg(ss_quantity)
- ,avg(ss_ext_sales_price)
- ,avg(ss_ext_wholesale_cost)
- ,sum(ss_ext_wholesale_cost)
- from store_sales
- ,store
- ,customer_demographics
- ,household_demographics
- ,customer_address
- ,date_dim
- where s_store_sk = ss_store_sk
- and ss_sold_date_sk = d_date_sk and d_year = 2001
- and((ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'M'
- and cd_education_status = '4 yr Degree'
- and ss_sales_price between 100.00 and 150.00
- and hd_dep_count = 3
- )or
- (ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'D'
- and cd_education_status = 'Primary'
- and ss_sales_price between 50.00 and 100.00
- and hd_dep_count = 1
- ) or
- (ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'U'
- and cd_education_status = 'Advanced Degree'
- and ss_sales_price between 150.00 and 200.00
- and hd_dep_count = 1
- ))
- and((ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('KY', 'GA', 'NM')
- and ss_net_profit between 100 and 200
- ) or
- (ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('MT', 'OR', 'IN')
- and ss_net_profit between 150 and 300
- ) or
- (ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('WI', 'MO', 'WV')
- and ss_net_profit between 50 and 250
- ))
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select avg(ss_quantity)
- ,avg(ss_ext_sales_price)
- ,avg(ss_ext_wholesale_cost)
- ,sum(ss_ext_wholesale_cost)
- from store_sales
- ,store
- ,customer_demographics
- ,household_demographics
- ,customer_address
- ,date_dim
- where s_store_sk = ss_store_sk
- and ss_sold_date_sk = d_date_sk and d_year = 2001
- and((ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'M'
- and cd_education_status = '4 yr Degree'
- and ss_sales_price between 100.00 and 150.00
- and hd_dep_count = 3
- )or
- (ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'D'
- and cd_education_status = 'Primary'
- and ss_sales_price between 50.00 and 100.00
- and hd_dep_count = 1
- ) or
- (ss_hdemo_sk=hd_demo_sk
- and cd_demo_sk = ss_cdemo_sk
- and cd_marital_status = 'U'
- and cd_education_status = 'Advanced Degree'
- and ss_sales_price between 150.00 and 200.00
- and hd_dep_count = 1
- ))
- and((ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('KY', 'GA', 'NM')
- and ss_net_profit between 100 and 200
- ) or
- (ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('MT', 'OR', 'IN')
- and ss_net_profit between 150 and 300
- ) or
- (ss_addr_sk = ca_address_sk
- and ca_country = 'United States'
- and ca_state in ('WI', 'MO', 'WV')
- and ss_net_profit between 50 and 250
- ))
-POSTHOOK: type: QUERY
-Plan optimized by CBO.
-
-Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 8 (SIMPLE_EDGE)
-Reducer 3 <- Map 9 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
-Reducer 4 <- Map 10 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
-Reducer 5 <- Map 11 (SIMPLE_EDGE), Reducer 4 (SIMPLE_EDGE)
-Reducer 6 <- Map 12 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE)
-Reducer 7 <- Reducer 6 (CUSTOM_SIMPLE_EDGE)
-
-Stage-0
- Fetch Operator
- limit:-1
- Stage-1
- Reducer 7
- File Output Operator [FS_40]
- Group By Operator [GBY_38] (rows=1 width=764)
-
Output:["_col0","_col1","_col2","_col3"],aggregations:["avg(VALUE._col0)","avg(VALUE._col1)","avg(VALUE._col2)","sum(VALUE._col3)"]
- <-Reducer 6 [CUSTOM_SIMPLE_EDGE]
- PARTITION_ONLY_SHUFFLE [RS_37]
- Group By Operator [GBY_36] (rows=1 width=764)
-
Output:["_col0","_col1","_col2","_col3"],aggregations:["avg(_col6)","avg(_col8)","avg(_col9)","sum(_col9)"]
- Select Operator [SEL_35] (rows=715776 width=88)
- Output:["_col6","_col8","_col9"]
- Filter Operator [FIL_34] (rows=715776 width=88)
- predicate:(((_col19 = 'D') and (_col20 = 'Primary') and
_col7 BETWEEN 50 AND 100 and (_col14 = 1)) or ((_col19 = 'M') and (_col20 = '4
yr Degree') and _col7 BETWEEN 100 AND 150 and (_col14 = 3)) or ((_col19 = 'U')
and (_col20 = 'Advanced Degree') and _col7 BETWEEN 150 AND 200 and (_col14 =
1)))
- Merge Join Operator [MERGEJOIN_71] (rows=17178642 width=88)
-
Conds:RS_31._col2=RS_32._col0(Inner),Output:["_col6","_col7","_col8","_col9","_col14","_col19","_col20"]
- <-Map 12 [SIMPLE_EDGE]
- SHUFFLE [RS_32]
- PartitionCols:_col0
- Select Operator [SEL_17] (rows=1861800 width=385)
- Output:["_col0","_col1","_col2"]
- Filter Operator [FIL_66] (rows=1861800 width=385)
- predicate:(((cd_education_status = '4 yr Degree') or
(cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree'))
and ((cd_marital_status = 'M') or (cd_marital_status = 'D') or
(cd_marital_status = 'U')) and cd_demo_sk is not null)
- TableScan [TS_15] (rows=1861800 width=385)
-
default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"]
- <-Reducer 5 [SIMPLE_EDGE]
- SHUFFLE [RS_31]
- PartitionCols:_col2
- Filter Operator [FIL_30] (rows=15616947 width=88)
- predicate:(((_col16) IN ('KY', 'GA', 'NM') and _col10
BETWEEN 100 AND 200) or ((_col16) IN ('MT', 'OR', 'IN') and _col10 BETWEEN 150
AND 300) or ((_col16) IN ('WI', 'MO', 'WV') and _col10 BETWEEN 50 AND 250))
- Merge Join Operator [MERGEJOIN_70] (rows=93701693
width=88)
-
Conds:RS_27._col4=RS_28._col0(Inner),Output:["_col2","_col6","_col7","_col8","_col9","_col10","_col14","_col16"]
- <-Map 11 [SIMPLE_EDGE]
- SHUFFLE [RS_28]
- PartitionCols:_col0
- Select Operator [SEL_14] (rows=10000000 width=1014)
- Output:["_col0","_col1"]
- Filter Operator [FIL_65] (rows=10000000
width=1014)
- predicate:((ca_country = 'United States') and
(ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and
ca_address_sk is not null)
- TableScan [TS_12] (rows=40000000 width=1014)
-
default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state","ca_country"]
- <-Reducer 4 [SIMPLE_EDGE]
- SHUFFLE [RS_27]
- PartitionCols:_col4
- Merge Join Operator [MERGEJOIN_69] (rows=85183356
width=88)
-
Conds:RS_24._col3=RS_25._col0(Inner),Output:["_col2","_col4","_col6","_col7","_col8","_col9","_col10","_col14"]
- <-Map 10 [SIMPLE_EDGE]
- SHUFFLE [RS_25]
- PartitionCols:_col0
- Select Operator [SEL_11] (rows=7200 width=107)
- Output:["_col0","_col1"]
- Filter Operator [FIL_64] (rows=7200
width=107)
- predicate:(((hd_dep_count = 3) or
(hd_dep_count = 1)) and hd_demo_sk is not null)
- TableScan [TS_9] (rows=7200 width=107)
-
default@household_demographics,household_demographics,Tbl:COMPLETE,Col:NONE,Output:["hd_demo_sk","hd_dep_count"]
- <-Reducer 3 [SIMPLE_EDGE]
- SHUFFLE [RS_24]
- PartitionCols:_col3
- Merge Join Operator [MERGEJOIN_68]
(rows=77439413 width=88)
-
Conds:RS_21._col1=RS_22._col0(Inner),Output:["_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"]
- <-Map 9 [SIMPLE_EDGE]
- SHUFFLE [RS_22]
- PartitionCols:_col0
- Select Operator [SEL_8] (rows=36524
width=1119)
- Output:["_col0"]
- Filter Operator [FIL_63] (rows=36524
width=1119)
- predicate:((d_year = 2001) and
d_date_sk is not null)
- TableScan [TS_6] (rows=73049
width=1119)
-
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
- <-Reducer 2 [SIMPLE_EDGE]
- SHUFFLE [RS_21]
- PartitionCols:_col1
- Merge Join Operator [MERGEJOIN_67]
(rows=70399465 width=88)
-
Conds:RS_18._col0=RS_19._col4(Inner),Output:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col9","_col10"]
- <-Map 1 [SIMPLE_EDGE]
- SHUFFLE [RS_18]
- PartitionCols:_col0
- Select Operator [SEL_2] (rows=1704
width=1910)
- Output:["_col0"]
- Filter Operator [FIL_61] (rows=1704
width=1910)
- predicate:s_store_sk is not null
- TableScan [TS_0] (rows=1704
width=1910)
-
default@store,store,Tbl:COMPLETE,Col:NONE,Output:["s_store_sk"]
- <-Map 8 [SIMPLE_EDGE]
- SHUFFLE [RS_19]
- PartitionCols:_col4
- Select Operator [SEL_5] (rows=63999513
width=88)
-
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
- Filter Operator [FIL_62]
(rows=63999513 width=88)
- predicate:((ss_net_profit BETWEEN
100 AND 200 or ss_net_profit BETWEEN 150 AND 300 or ss_net_profit BETWEEN 50
AND 250) and (ss_sales_price BETWEEN 100 AND 150 or ss_sales_price BETWEEN 50
AND 100 or ss_sales_price BETWEEN 150 AND 200) and ss_addr_sk is not null and
ss_cdemo_sk is not null and ss_hdemo_sk is not null and ss_sold_date_sk is not
null and ss_store_sk is not null)
- TableScan [TS_3] (rows=575995635
width=88)
-
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_cdemo_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_quantity","ss_sales_price","ss_ext_sales_price","ss_ext_wholesale_cost","ss_net_profit"]
-
