[prev in list] [next in list] [prev in thread] [next in thread] 

List:       drill-dev
Subject:    [jira] [Created] (DRILL-1611) The SQL fails Query failed: Failure while running fragment. Queue clos
From:       "Amol (JIRA)" <jira () apache ! org>
Date:       2014-10-30 10:13:34
Message-ID: JIRA.12751649.1414664008000.371522.1414664014097 () Atlassian ! JIRA
[Download RAW message or body]

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)


[prev in list] [next in list] [prev in thread] [next in thread]