drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1611) The SQL fails Query failed: Failure while running fragment. Queue closed due to channel closure
Date Sat, 28 Mar 2015 00:02:53 GMT

     [ 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)

Mime
View raw message