[jira] [Created] (DRILL-1611) The SQL fails Query failed: Failure while running fragment. Queue closed due to channel closure

["Amol (JIRA)" <ji...@apache.org>]

Amol created DRILL-1611:
---------------------------

             Summary: The SQL fails Query failed: Failure while running fragment. Queue closed due to channel closure
                 Key: DRILL-1611
                 URL: https://issues.apache.org/jira/browse/DRILL-1611
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 0.6.0
            Reporter: Amol


Some of the sqls are executing fine. When we execute below SQL we get an error. We doubled the memory and it does not respond. request guidance to correct it,
SQL USED:
SELECT c_customer_id,c_current_cdemo_sk,c_current_hdemo_sk,c_current_addr_sk,
c_salutation,c_first_name,c_last_name,c_preferred_cust_flag,
c_login,c_email_address,c_last_review_date,Sum(ss_quantity),
Sum(ss_wholesale_cost),Sum(ss_list_price),Sum(ss_sales_price),
Sum(ss_ext_discount_amt),Sum(ss_ext_sales_price),Sum(ss_ext_wholesale_cost),
Sum(ss_ext_list_price),Sum(ss_ext_tax),Sum(ss_coupon_amt),Sum(ss_net_paid),
Sum(ss_net_paid_inc_tax),Sum(ss_net_profit)
from customer A , store_sales B where A.c_customer_sk = B.ss_customer_sk
Group by c_customer_id,c_current_cdemo_sk,c_current_hdemo_sk,c_current_addr_sk,
c_salutation,c_first_name,c_last_name,c_preferred_cust_flag,
c_login,c_email_address,c_last_review_date
limit 100;
ERROR: 
Query failed: Failure while running fragment. Queue closed due to channel closure. [9a718ee0-2f6b-401f-b4d6-b861ef4769da]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)