drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-868) tpcds query 7 fails with IndexOutOfBoundsException
Date Fri, 30 May 2014 17:05:04 GMT
Krystal created DRILL-868:
-----------------------------

             Summary: 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


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)

Mime
View raw message