[
https://issues.apache.org/jira/browse/DRILL-1158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aman Sinha resolved DRILL-1158.
-------------------------------
Resolution: Fixed
Assignee: Chun Chang
[~jnadeau] had added support for large IN lists for DRILL-2695. Please test
and verify.
> mondrian2056.q - cause CannotPlanException
> ------------------------------------------
>
> Key: DRILL-1158
> URL: https://issues.apache.org/jira/browse/DRILL-1158
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Chun Chang
> Assignee: Chun Chang
> Priority: Minor
> Fix For: 0.9.0
>
>
> #Mon Jul 14 10:10:52 PDT 2014
> git.commit.id.abbrev=699851b
> The following mondrian query (query2056.q) caused cannot plan exception:
> [root@qa-node120 testcases]# cat query2056.q
> select time_by_day.the_year as c0, customer.state_province as c1,
> customer.city as c2, sum(sales_fact_1997.unit_sales) as m0 from time_by_day
> as time_by_day, sales_fact_1997 as sales_fact_1997, customer as customer
> where sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year
> = 1997 and sales_fact_1997.customer_id = customer.customer_id and
> customer.state_province in ('CA', 'OR', 'WA') and customer.city in ('Albany',
> 'Anacortes', 'Ballard', 'Beaverton', 'Bellingham', 'Corvallis', 'Lake
> Oswego', 'Lebanon', 'Milwaukie', 'Oregon City', 'Portland', 'Salem', 'San
> Francisco', 'San Gabriel', 'San Jose', 'Santa Cruz', 'Santa Monica', 'Spring
> Valley', 'Torrance', 'W. Linn', 'West Covina', 'Woodburn', 'Woodland Hills')
> group by time_by_day.the_year, customer.state_province, customer.city;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
