You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/07/06 21:14:04 UTC
[jira] [Commented] (DRILL-1611) The SQL fails Query failed: Failure
while running fragment. Queue closed due to channel closure
[ https://issues.apache.org/jira/browse/DRILL-1611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14615504#comment-14615504 ]
Victoria Markman commented on DRILL-1611:
-----------------------------------------
This query now runs successfully: version 1.1 of drill:
{code}
0: jdbc:drill:schema=dfs> SELECT A.c_customer_id,
. . . . . . . . . . . . > A.c_current_cdemo_sk,
. . . . . . . . . . . . > A.c_current_hdemo_sk,
. . . . . . . . . . . . > A.c_current_addr_sk,
. . . . . . . . . . . . > A.c_salutation,
. . . . . . . . . . . . > A.c_first_name,
. . . . . . . . . . . . > A.c_last_name,
. . . . . . . . . . . . > A.c_preferred_cust_flag,
. . . . . . . . . . . . > A.c_login,
. . . . . . . . . . . . > A.c_email_address,
. . . . . . . . . . . . > A.c_last_review_date,
. . . . . . . . . . . . > Sum(B.ss_quantity),
. . . . . . . . . . . . > Sum(B.ss_wholesale_cost),
. . . . . . . . . . . . > Sum(B.ss_list_price),
. . . . . . . . . . . . > Sum(B.ss_sales_price),
. . . . . . . . . . . . > Sum(B.ss_ext_discount_amt),
. . . . . . . . . . . . > Sum(B.ss_ext_sales_price),
. . . . . . . . . . . . > Sum(B.ss_ext_wholesale_cost),
. . . . . . . . . . . . > Sum(B.ss_ext_list_price),
. . . . . . . . . . . . > Sum(B.ss_ext_tax),
. . . . . . . . . . . . > Sum(B.ss_coupon_amt),
. . . . . . . . . . . . > Sum(B.ss_net_paid),
. . . . . . . . . . . . > Sum(B.ss_net_paid_inc_tax),
. . . . . . . . . . . . > Sum(B.ss_net_profit)
. . . . . . . . . . . . > FROM customer A,
. . . . . . . . . . . . > store_sales B
. . . . . . . . . . . . > WHERE
. . . . . . . . . . . . > A.c_customer_sk = B.ss_customer_sk
. . . . . . . . . . . . > GROUP BY
. . . . . . . . . . . . > A.c_customer_id,
. . . . . . . . . . . . > A.c_current_cdemo_sk,
. . . . . . . . . . . . > A.c_current_hdemo_sk,
. . . . . . . . . . . . > A.c_current_addr_sk,
. . . . . . . . . . . . > A.c_salutation,
. . . . . . . . . . . . > A.c_first_name,
. . . . . . . . . . . . > A.c_last_name,
. . . . . . . . . . . . > A.c_preferred_cust_flag,
. . . . . . . . . . . . > A.c_login,
. . . . . . . . . . . . > A.c_email_address,
. . . . . . . . . . . . > A.c_last_review_date
. . . . . . . . . . . . > LIMIT 100;
+----------------+---------------------+---------------------+--------------------+---------------+---------------+--------------+------------------------+----------+------------------+---------------------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+----------------------+
| 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 | EXPR$11 | EXPR$12 | EXPR$13 | EXPR$14 | EXPR$15 | EXPR$16 | EXPR$17 | EXPR$18 | EXPR$19 | EXPR$20 | EXPR$21 | EXPR$22 | EXPR$23 |
+----------------+---------------------+---------------------+--------------------+---------------+---------------+--------------+------------------------+----------+------------------+---------------------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+----------------------+
| [B@1997053a | 1740699 | 6283 | 8667 | [B@9d82ff6 | [B@5034c486 | [B@3852628d | [B@28c433de | null | [B@692948ba | [B@1565e146 | 1451 | 1636.3499875068665 | 2735.4400119781494 | 1026.380006607622 | 13208.909889936447 | 58845.53004384041 | 94184.37959289551 | 148164.82012939453 | 1023.8200042340904 | 13208.909889936447 | 42804.30076660216 | 46858.699785619974 | -48243.00975036621 |
| [B@53a8c5a3 | 1802568 | 1029 | 15490 | [B@6d477b3d | [B@6fec19d7 | [B@7594aba8 | [B@7391dee6 | null | [B@6dc10950 | [B@1c4a9b7b | 1162 | 1148.9599850177765 | 1852.3299944400787 | 777.4500068426132 | 759.4600238800049 | 35477.37022399902 | 51913.20999908447 | 84324.75047302246 | 1640.790023803711 | 759.4600238800049 | 34717.91014003754 | 36358.69979476929 | -17195.299812316895 |
| [B@6625b6bf | 1744347 | 2368 | 42742 | [B@3600e9fd | [B@7601fcbd | [B@7c7818d1 | [B@30a5812e | null | [B@41c40bf5 | [B@2ded238e | 1165 | 1207.8599911928177 | 1815.690021276474 | 1027.6299982741475 | 7473.659950256348 | 57659.68090105057 | 57854.639640808105 | 85906.64002990723 | 1671.4599839225411 | 7473.659950256348 | 49733.41061782837 | 51407.600790023804 | -8066.240294456482 |
| [B@2bb95730 | 984311 | 7140 | 29522 | [B@150b26bd | [B@f1c4d16 | [B@b08e71a | [B@757c619e | null | [B@38ed0854 | [B@51bddffe | 1537 | 1357.2999914884567 | 1950.439974308014 | 1044.4599976539612
....
{code}
> 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: 1.2.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)