You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/11/20 22:11:10 UTC
[jira] [Commented] (DRILL-2915) Regression: Mondrian query5614.q -
Query failed: SYSTEM ERROR: This query cannot be planned possibly due to
either a cartesian join or an inequality join
[ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15018799#comment-15018799 ]
ASF GitHub Bot commented on DRILL-2915:
---------------------------------------
GitHub user hsuanyi opened a pull request:
https://github.com/apache/drill/pull/271
DRILL-2915: After cartesian join is selected, Drill will apply the ne…
…w rule to try to merge multiple joins more complete.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hsuanyi/incubator-drill DRILL-2915
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/271.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #271
----
commit 34a77a6c210f26cf70e555da880a66d1c3713919
Author: Hsuan-Yi Chu <hs...@usc.edu>
Date: 2015-11-20T06:42:14Z
DRILL-2915: After cartesian join is selected, Drill will apply the new rule to try to merge multiple joins more complete.
----
> 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: Sean Hsuan-Yi Chu
> Priority: Critical
> Fix For: 1.4.0
>
> Attachments: 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)