[
https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384351#comment-14384351
]
Abhishek Girish commented on DRILL-2607:
----------------------------------------
Git.Commit.ID: 462e50c (Mar 26 2015)
> 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)
