[
https://issues.apache.org/jira/browse/DRILL-7183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sorabh Hamirwasia updated DRILL-7183:
-------------------------------------
Labels: ready-to-commit (was: )
> TPCDS query 10, 35, 69 take longer with sf 1000 when Statistics are disabled
> ----------------------------------------------------------------------------
>
> Key: DRILL-7183
> URL: https://issues.apache.org/jira/browse/DRILL-7183
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.16.0
> Reporter: Robert Hou
> Assignee: Hanumath Rao Maduri
> Priority: Blocker
> Labels: ready-to-commit
> Fix For: 1.16.0
>
>
> Query 69 runs 150% slower when Statistics is disabled. Here is the query:
> {noformat}
> SELECT
> cd_gender,
> cd_marital_status,
> cd_education_status,
> count(*) cnt1,
> cd_purchase_estimate,
> count(*) cnt2,
> cd_credit_rating,
> count(*) cnt3
> FROM
> customer c, customer_address ca, customer_demographics
> WHERE
> c.c_current_addr_sk = ca.ca_address_sk AND
> ca_state IN ('KY', 'GA', 'NM') AND
> cd_demo_sk = c.c_current_cdemo_sk AND
> exists(SELECT *
> FROM store_sales, date_dim
> WHERE c.c_customer_sk = ss_customer_sk AND
> ss_sold_date_sk = d_date_sk AND
> d_year = 2001 AND
> d_moy BETWEEN 4 AND 4 + 2) AND
> (NOT exists(SELECT *
> FROM web_sales, date_dim
> WHERE c.c_customer_sk = ws_bill_customer_sk AND
> ws_sold_date_sk = d_date_sk AND
> d_year = 2001 AND
> d_moy BETWEEN 4 AND 4 + 2) AND
> NOT exists(SELECT *
> FROM catalog_sales, date_dim
> WHERE c.c_customer_sk = cs_ship_customer_sk AND
> cs_sold_date_sk = d_date_sk AND
> d_year = 2001 AND
> d_moy BETWEEN 4 AND 4 + 2))
> GROUP BY cd_gender, cd_marital_status, cd_education_status,
> cd_purchase_estimate, cd_credit_rating
> ORDER BY cd_gender, cd_marital_status, cd_education_status,
> cd_purchase_estimate, cd_credit_rating
> LIMIT 100;
> {noformat}
> This regression is caused by commit 982e98061e029a39f1c593f695c0d93ec7079f0d.
> This commit should be reverted for now.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
