asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1580) Subquery in having clause throws ArrayIndexOutOfBoundsException
Date Mon, 15 Aug 2016 23:51:21 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15421905#comment-15421905
] 

Yingyi Bu commented on ASTERIXDB-1580:
--------------------------------------

[~vignesh.raghunathan], the issue has already been fixed in the latest master by previous
changes. Can you generate even smaller scale dataset (which can still produce meaningful results
instead of empty result sets) so that I can put the query and results into the regression
tests?  The dataset you provided is great but still a bit too large to put into github.  Ideally,
we'd like the dataset scale similar to tpch0.001 at asterixdb/asterix-app/data/tpch0.001/.


> Subquery in having clause throws ArrayIndexOutOfBoundsException
> ---------------------------------------------------------------
>
>                 Key: ASTERIXDB-1580
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Vignesh Raghunathan
>            Assignee: Yingyi Bu
>         Attachments: logs.zip
>
>
> The following sqlpp query throws an ArrayIndexOutOfBoundsException
> {code}
> use tpcds;
> select  a.ca_state state, count(a) cnt
>  from customer_address a
>      ,customer c
>      ,store_sales s
>      ,date_dim d
>      ,item i
>  where  a.ca_address_sk = c.c_current_addr_sk
>  	and c.c_customer_sk = s.ss_customer_sk
>  	and s.ss_sold_date_sk = d.d_date_sk
>  	and s.ss_item_sk = i.i_item_sk
>  group by a.ca_state group as stategrp
>  having coll_count((select value a from stategrp)) >= 10
>  order by cnt
>  limit 100;
> {code}
> tpcdsq6.zip contains the schema and data for the datasets used in the query



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message