[jira] [Updated] (DRILL-868) tpcds query 7 fails with IndexOutOfBoundsException

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-868:
---------------------------------

    Assignee: Steven Phillips

> tpcds query 7 fails with IndexOutOfBoundsException
> --------------------------------------------------
>
>                 Key: DRILL-868
>                 URL: https://issues.apache.org/jira/browse/DRILL-868
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Krystal
>            Assignee: Steven Phillips
>
> git.commit.id.abbrev=e1e5ea0
> git.commit.time=29.05.2014 @ 15\:32\:29 PDT
> query:
> {code}
> 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;
> {code}
> message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 19700, length: 4 (expected: range(0, 19700)) ]"



--
This message was sent by Atlassian JIRA
(v6.2#6252)