[
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)
