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:42:53 UTC
[jira] [Created] (DRILL-2607) TPC-DS query 71 and simplified
variant on parquet views fails with IOBE
Abhishek Girish created DRILL-2607:
--------------------------------------
Summary: 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
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)