drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
Date Tue, 29 Sep 2015 19:13:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935669#comment-14935669
] 

ASF GitHub Bot commented on DRILL-3257:
---------------------------------------

Github user amansinha100 commented on a diff in the pull request:

    https://github.com/apache/drill/pull/176#discussion_r40715318
  
    --- Diff: exec/java-exec/src/test/java/org/apache/drill/TestUnionAll.java ---
    @@ -542,7 +542,9 @@ public void testFilterPushDownOverUnionAll() throws Exception {
                 ".*Filter.*\n" +
                     ".*Scan"};
         final String[] excludedPlan = {"Filter.*\n.*UnionAll"};
    -    PlanTestBase.testPlanMatchingPatterns(query, expectedPlan, excludedPlan);
    +    // Add the plan verification after FilterSetOpTransposeRule and DrillProjectSetOpTransposeRule
    +    // are enabled
    +    // PlanTestBase.testPlanMatchingPatterns(query, expectedPlan, excludedPlan);
    --- End diff --
    
    Since these are the only plan verification tests for Union, I suggest you keep the plan
verification tests (with the modified plan) and file a JIRA for re-enabling the rules.


> 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: Sean Hsuan-Yi Chu
>             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)

Mime
View raw message