Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3257

TPCDS query 74 results in a StackOverflowError on Scale Factor 1

    Details

      Description

      git.commit.id.abbrev=5f26b8b

      Query :

      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;
      

      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.

        Attachments

        1. error.log
          49 kB
          Rahul Challapalli

          Issue Links

            Activity

              People

              • Assignee:
                agirish Abhishek Girish
                Reporter:
                rkins Rahul Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: