[
https://issues.apache.org/jira/browse/DRILL-1611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14191540#comment-14191540
]
Amol commented on DRILL-1611:
-----------------------------
After executing the query and we got the error, below is the output.
Error log
2014-10-30 22:46:47,096 [Client-1] DEBUG o.a.d.e.rpc.user.QueryResultHandler -
Received QueryId part1: -3324348157840047134
part2: -6077184474173160428
succesfully. Adding listener
org.apache.drill.jdbc.DrillResultSet$Listener@29bf4c9d
2014-10-30 22:49:03,684 [Client-1] DEBUG o.a.d.e.rpc.user.QueryResultHandler -
Received QueryId part1: 6852714811837206241
part2: -9140961671477210389
succesfully. Adding listener
org.apache.drill.jdbc.DrillResultSet$Listener@7966e36d
Also we executed another query and no response after an hour at least
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;
Thanks
Amol
> 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)
