[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Victoria Markman updated DRILL-3257:
Assignee: Abhishek Girish (was: Sean Hsuan-Yi Chu)
> 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_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu updated DRILL-3257:
-
Fix Version/s: (was: 1.3.0)
1.2.0
> 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_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu updated DRILL-3257:
-
Fix Version/s: (was: 1.2.0)
1.3.0
> 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.3.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudheesh Katkam updated DRILL-3257:
---
Assignee: Sean Hsuan-Yi Chu (was: Sudheesh Katkam)
> 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_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudheesh Katkam updated DRILL-3257:
---
Component/s: (was: Execution - Flow)
Query Planning & Optimization
This is a planning issue. We introduced pushing project past set operations in
this
[commit|https://github.com/apache/drill/commit/bca20655283d351d5f5c4090e9047419ff22c75e],
and somehow this causes Calcite to loop infinitely (?) during plan cost
estimation.
Other issues I noticed while debugging this issue, re Foreman node:
* Sometimes the Drillbit crashes.
* Sometimes the Drillbit hangs while shutting down, making it unresponsive.
* Other sqlline connections to the Drillbit cannot be made, with the Drillbit
using a lot of CPU but essentially doing nothing.
> 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: Sudheesh Katkam
> Fix For: 1.2.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris Westin updated DRILL-3257:
Assignee: Sudheesh Katkam (was: Chris Westin)
> 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: Execution - Flow
>Reporter: Rahul Challapalli
>Assignee: Sudheesh Katkam
> Fix For: 1.2.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris Westin updated DRILL-3257:
Fix Version/s: (was: 1.1.0)
1.2.0
> 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: Execution - Flow
>Reporter: Rahul Challapalli
>Assignee: Chris Westin
> Fix For: 1.2.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris Westin updated DRILL-3257:
Fix Version/s: 1.1.0
> 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: Execution - Flow
>Reporter: Rahul Challapalli
>Assignee: Chris Westin
> Fix For: 1.1.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
[jira] [Updated] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1
[
https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Challapalli updated DRILL-3257:
-
Attachment: error.log
> 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: Execution - Flow
>Reporter: Rahul Challapalli
>Assignee: Chris Westin
> Attachments: error.log
>
>
> git.commit.id.abbrev=5f26b8b
> Query :
> {code}
> WITH year_total
> AS (SELECT c_customer_idcustomer_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_idcustomer_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)
