[jira] [Closed] (DRILL-867) tpcds queries 6, 9 and 10 fail to plan

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

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

Krystal closed DRILL-867.
-------------------------

Bug was verified.

> tpcds queries 6, 9 and 10 fail to plan
> --------------------------------------
>
>                 Key: DRILL-867
>                 URL: https://issues.apache.org/jira/browse/DRILL-867
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>            Reporter: Krystal
>            Priority: Minor
>             Fix For: Future
>
>
> git.commit.id.abbrev=e1e5ea0
> git.commit.time=29.05.2014 @ 15\:32\:29 PDT
> query 6:
> {code}
> select * from (select  a.ca_state state, count(*) 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
>   and d.d_month_seq = 
>        (select distinct (d.d_month_seq)
>         from date_dim d
>                where d.d_year = 1998
>           and d.d_moy = 5 ) 
>   and i.i_current_price > 1.2 * 
>              (select avg(j.i_current_price)
>        from item j 
>        where j.i_category = i.i_category)
>  group by a.ca_state
>  having count(*) >= 10
>  order by cnt
>  ) limit 100;
> {code}
> query 7:



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)