[ 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)