[jira] [Commented] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE

["Abhishek Girish (JIRA)" <ji...@apache.org>]

    [ 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)