[jira] [Commented] (DRILL-5214) This query cannot be planned possibly due to either a cartesian join or an inequality join

["Dor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-5214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16296371#comment-16296371 ] 

Dor commented on DRILL-5214:
----------------------------

Hi,

This is the query i did to get the above exception 

select cust.customer_id, cust.subscriber_id, resource_value from customers cust, USERS_ORACLE users 
where cust.key >= '0002:10:2017:0052' and cust.key < '0002:10:2017:0104' and cust.customer_id = users.customer_id and cust.subscriber_id = users.subscriber_id 
limit 100;


Both users and customers tables are huge tables.

> This query cannot be planned possibly due to either a cartesian join or an inequality join
> ------------------------------------------------------------------------------------------
>
>                 Key: DRILL-5214
>                 URL: https://issues.apache.org/jira/browse/DRILL-5214
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Gautam Kumar Parai
>            Assignee: Gautam Kumar Parai
>
> We see the following error for certain queries: java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join
> This happens e.g. with TPCH Q11 with statistics [Drill-1328]



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)