[jira] [Closed] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1

["Abhishek Girish (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Abhishek Girish closed DRILL-3257.
----------------------------------

> TPCDS query 74 results in a StackOverflowError on Scale Factor 1
> ----------------------------------------------------------------
>
>                 Key: DRILL-3257
>                 URL: https://issues.apache.org/jira/browse/DRILL-3257
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Rahul Challapalli
>            Assignee: Abhishek Girish
>             Fix For: 1.2.0
>
>         Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total 
>      AS (SELECT c_customer_id    customer_id, 
>                 c_first_name     customer_first_name, 
>                 c_last_name      customer_last_name, 
>                 d_year           AS year1, 
>                 Sum(ss_net_paid) year_total, 
>                 's'              sale_type 
>          FROM   customer, 
>                 store_sales, 
>                 date_dim 
>          WHERE  c_customer_sk = ss_customer_sk 
>                 AND ss_sold_date_sk = d_date_sk 
>                 AND d_year IN ( 1999, 1999 + 1 ) 
>          GROUP  BY c_customer_id, 
>                    c_first_name, 
>                    c_last_name, 
>                    d_year 
>          UNION ALL 
>          SELECT c_customer_id    customer_id, 
>                 c_first_name     customer_first_name, 
>                 c_last_name      customer_last_name, 
>                 d_year           AS year1, 
>                 Sum(ws_net_paid) year_total, 
>                 'w'              sale_type 
>          FROM   customer, 
>                 web_sales, 
>                 date_dim 
>          WHERE  c_customer_sk = ws_bill_customer_sk 
>                 AND ws_sold_date_sk = d_date_sk 
>                 AND d_year IN ( 1999, 1999 + 1 ) 
>          GROUP  BY c_customer_id, 
>                    c_first_name, 
>                    c_last_name, 
>                    d_year) 
> SELECT t_s_secyear.customer_id, 
>                t_s_secyear.customer_first_name, 
>                t_s_secyear.customer_last_name 
> FROM   year_total t_s_firstyear, 
>        year_total t_s_secyear, 
>        year_total t_w_firstyear, 
>        year_total t_w_secyear 
> WHERE  t_s_secyear.customer_id = t_s_firstyear.customer_id 
>        AND t_s_firstyear.customer_id = t_w_secyear.customer_id 
>        AND t_s_firstyear.customer_id = t_w_firstyear.customer_id 
>        AND t_s_firstyear.sale_type = 's' 
>        AND t_w_firstyear.sale_type = 'w' 
>        AND t_s_secyear.sale_type = 's' 
>        AND t_w_secyear.sale_type = 'w' 
>        AND t_s_firstyear.year1 = 1999 
>        AND t_s_secyear.year1 = 1999 + 1 
>        AND t_w_firstyear.year1 = 1999 
>        AND t_w_secyear.year1 = 1999 + 1 
>        AND t_s_firstyear.year_total > 0 
>        AND t_w_firstyear.year_total > 0 
>        AND CASE 
>              WHEN t_w_firstyear.year_total > 0 THEN t_w_secyear.year_total / 
>                                                     t_w_firstyear.year_total 
>              ELSE NULL 
>            END > CASE 
>                    WHEN t_s_firstyear.year_total > 0 THEN 
>                    t_s_secyear.year_total / 
>                    t_s_firstyear.year_total 
>                    ELSE NULL 
>                  END 
> ORDER  BY 1, 
>           2, 
>           3
> LIMIT 100;
> {code}
> The above query never returns. I attached the log file.
> Since the data is 1GB I cannot attach it here. Kindly reach out to me if you want more information.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)