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. 

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,
        WHERE  date_dim.d_date_sk = web_sales.ws_sold_date_sk
       ) AS tmp,
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' )

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)

Log snippet attached. 

This message was sent by Atlassian JIRA

View raw message