Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 5 Oct 2015 22:26:27 +0000 (UTC)
From: "Aman Sinha (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12826169.1430353667000.30751.1444083987228@Atlassian.JIRA>
In-Reply-To: <JIRA.12826169.1430353667000@Atlassian.JIRA>
References: <JIRA.12826169.1430353667000@Atlassian.JIRA>
 <JIRA.12826169.1430353667527@arcas>
Subject: [jira] [Updated] (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
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DRILL-2915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aman Sinha updated DRILL-2915:
------------------------------
    Assignee: Sean Hsuan-Yi Chu  (was: Aman Sinha)

> 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.3.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)