[ https://issues.apache.org/jira/browse/DRILL-1611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha updated DRILL-1611: ------------------------------ Component/s: (was: SQL Parser) Query Planning & Optimization > 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: Query Planning & Optimization > Affects Versions: 0.6.0 > Reporter: Amol > Assignee: Victoria Markman > Fix For: 0.9.0 > > > 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)