You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/03/27 19:43:53 UTC
[jira] [Updated] (DRILL-2607) TPC-DS query 71 and simplified
variant on parquet views fails with IOBE
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish updated DRILL-2607:
-----------------------------------
Attachment: query71.sql
drillbit.log
> TPC-DS query 71 and simplified variant on parquet views fails with IOBE
> ------------------------------------------------------------------------
>
> Key: DRILL-2607
> URL: https://issues.apache.org/jira/browse/DRILL-2607
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 0.8.0
> Reporter: Abhishek Girish
> Assignee: Jinfeng Ni
> Attachments: drillbit.log, query71.sql
>
>
> TPC-DS query 71 (attached) and simplified variant (below) throws IOBE when run on views on top of Parquet.
> The same queries run fine on Parquet tables and views on top of Text.
> Query:
> {code:sql}
> SELECT item.i_brand_id brand_id
> FROM item,
> (SELECT web_sales.ws_item_sk AS sold_item_sk,
> web_sales.ws_sold_time_sk AS time_sk
> FROM web_sales,
> date_dim
> WHERE date_dim.d_date_sk = web_sales.ws_sold_date_sk
> ) AS tmp,
> time_dim
> WHERE tmp.sold_item_sk = item.i_item_sk
> AND tmp.time_sk = time_dim.t_time_sk
> AND ( time_dim.t_meal_time = 'breakfast'
> OR time_dim.t_meal_time = 'dinner' )
> GROUP BY
> item.i_brand_id;
> {code}
> Error:
> {code}
> Query failed: RemoteRpcException: Failure while running fragment., index: 21600, length: 1 (expected: range(0, 16384)) [ 3e1fe0da-a75a-40d0-8dc3-7b19936080c9 on abhi5.qa.lab:31010 ]
> [ 3e1fe0da-a75a-40d0-8dc3-7b19936080c9 on abhi5.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> Log snippet attached.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)