Chun Chang created DRILL-2915:
---------------------------------
Summary: 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: Execution - Relational Operators
Affects Versions: 0.9.0
Reporter: Chun Chang
Assignee: Chris Westin
Priority: Critical
#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)
