[DRILL-868] tpcds query 7 fails with IndexOutOfBoundsException

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Execution - Flow
• Assignee: Steven Phillips
• Reporter: Krystal
• Created: 30/May/14 17:04
• Updated: 24/Nov/14 18:18
• Resolved: 24/Nov/14 18:18

Description

git.commit.id.abbrev=e1e5ea0
git.commit.time=29.05.2014 @ 15\:32\:29 PDT
query:

select  item.i_item_id,
        avg(ss.ss_quantity) agg1,
        avg(ss.ss_list_price) agg2,
        avg(ss.ss_coupon_amt) agg3,
        avg(ss.ss_sales_price) agg4
 from store_sales ss, customer_demographics cd, date_dim dd, item, promotion
 where ss.ss_sold_date_sk = dd.d_date_sk and
       ss.ss_item_sk = item.i_item_sk and
       ss.ss_cdemo_sk = cd.cd_demo_sk and
       ss.ss_promo_sk = promotion.p_promo_sk and
       cd.cd_gender = 'M' and
       cd.cd_marital_status = 'M' and
       cd.cd_education_status = '4 yr Degree' and
       (promotion.p_channel_email = 'N' or promotion.p_channel_event = 'N') and
       dd.d_year = 2001
 group by item.i_item_id
 order by item.i_item_id
 limit 100;

message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 19700, length: 4 (expected: range(0, 19700)) ]"

Issue Links

• Is contained by: DRILL-958 Parquet nullable fixed length reader not giving correct value count