drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE
Date Thu, 02 Jul 2015 22:12:06 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612613#comment-14612613
] 

Jinfeng Ni commented on DRILL-2607:
-----------------------------------

The error log indicates the IOOB happens in execution side.  Change the component to execution
- relational operator. 


> 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: Execution - Relational Operators
>    Affects Versions: 0.8.0
>            Reporter: Abhishek Girish
>            Assignee: Chris Westin
>             Fix For: 1.2.0
>
>         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)

Mime
View raw message