drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE
Date Fri, 27 Mar 2015 18:42:53 GMT
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)

Mime
View raw message