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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Assignee: Victoria Markman
• Reporter: Amol
• Created: 30/Oct/14 10:13
• Updated: 06/Jul/15 19:14
• Resolved: 06/Jul/15 19:14

Description

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)