[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu updated DRILL-2915: ------------------------------------- Attachment: DRILL-2915.1.patch > Regression: Mondrian query5614.q - Query failed: SYSTEM ERROR: This query > cannot be planned possibly due to either a cartesian join or an inequality > join > --------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-2915 > URL: https://issues.apache.org/jira/browse/DRILL-2915 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.9.0 > Reporter: Chun Chang > Assignee: Aman Sinha > Priority: Critical > Fix For: 1.1.0 > > Attachments: DRILL-2915.1.patch, mondrian_query5614.explain > > > #Wed Apr 29 14:39:22 EDT 2015 > git.commit.id.abbrev=f5b0f49 > The following mondrian query fails now. > {code} > SELECT store.store_state AS c0, > Count(DISTINCT sales_fact_1997.customer_id) AS m0 > FROM store AS store, > sales_fact_1997 AS sales_fact_1997, > time_by_day AS time_by_day, > product_class AS product_class, > product AS product > WHERE sales_fact_1997.store_id = store.store_id > AND store.store_state = 'CA' > AND sales_fact_1997.time_id = time_by_day.time_id > AND sales_fact_1997.product_id = product.product_id > AND product.product_class_id = product_class.product_class_id > AND ( ( product_class.product_family = 'Food' > AND time_by_day.quarter = 'Q1' > AND time_by_day.the_year = 1997 ) > OR ( product_class.product_family = 'Drink' > AND time_by_day.month_of_year = 4 > AND time_by_day.quarter = 'Q2' > AND time_by_day.the_year = 1997 ) ) > GROUP BY store.store_state; > {code} > postgres: > {code} > foodmart=# select store.store_state as c0, count(distinct > sales_fact_1997.customer_id) as m0 from store as store, sales_fact_1997 as > sales_fact_1997, time_by_day as time_by_day, product_class as product_class, > product as product where sales_fact_1997.store_id = store.store_id and > store.store_state = 'CA' and sales_fact_1997.time_id = time_by_day.time_id > and sales_fact_1997.product_id = product.product_id and > product.product_class_id = product_class.product_class_id and > ((product_class.product_family = 'Food' and time_by_day.quarter = 'Q1' and > time_by_day.the_year = 1997) or (product_class.product_family = 'Drink' and > time_by_day.month_of_year = 4 and time_by_day.quarter = 'Q2' and > time_by_day.the_year = 1997)) group by store.store_state; > c0 | m0 > ----+------ > CA | 1175 > (1 row) > {code} > drill failed > {code} > 0: jdbc:drill:schema=dfs.drillTestDirAdvanced> select store.store_state as > c0, count(distinct sales_fact_1997.customer_id) as m0 from store as store, > sales_fact_1997 as sales_fact_1997, time_by_day as time_by_day, product_class > as product_class, product as product where sales_fact_1997.store_id = > store.store_id and store.store_state = 'CA' and sales_fact_1997.time_id = > time_by_day.time_id and sales_fact_1997.product_id = product.product_id and > product.product_class_id = product_class.product_class_id and > ((product_class.product_family = 'Food' and time_by_day.quarter = 'Q1' and > time_by_day.the_year = 1997) or (product_class.product_family = 'Drink' and > time_by_day.month_of_year = 4 and time_by_day.quarter = 'Q2' and > time_by_day.the_year = 1997)) group by store.store_state; > Query failed: SYSTEM ERROR: This query cannot be planned possibly due to > either a cartesian join or an inequality join > [3eb99963-92aa-4129-844f-fe43839537b9 on qa-node119.qa.lab:31010] > Error: exception while executing query: Failure while executing query. > (state=,code=0) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)