[DRILL-867] tpcds queries 6, 9 and 10 fail to plan

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: Future
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Krystal
• Created: 30/May/14 16:22
• Updated: 16/Mar/17 20:45
• Resolved: 16/Nov/15 21:16

Description

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

query 6:

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;

query 7: