Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6EF1218E25 for ; Tue, 29 Sep 2015 21:31:05 +0000 (UTC) Received: (qmail 89237 invoked by uid 500); 29 Sep 2015 21:31:05 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 89121 invoked by uid 500); 29 Sep 2015 21:31:05 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 89014 invoked by uid 99); 29 Sep 2015 21:31:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Sep 2015 21:31:05 +0000 Date: Tue, 29 Sep 2015 21:31:05 +0000 (UTC) From: "ASF GitHub Bot (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-3257) TPCDS query 74 results in a StackOverflowError on Scale Factor 1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935907#comment-14935907 ] ASF GitHub Bot commented on DRILL-3257: --------------------------------------- Github user hsuanyi commented on the pull request: https://github.com/apache/drill/pull/176#issuecomment-144197142 The comments were addressed. > 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)