Drill query cannot be planned possibly due to either a cartesian join or an inequality join

mmlr_90 — Fri, 16 Sep 2022 11:37:58 GMT

Hello,

Im performing a tpch benchmark using drill, the queries are stored in sql file and are executed over a hive schema (with tables stored as orc). When i try to run query 22 (ill put the code next), Drill gives an error of "Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join". The same happens in query 22 of tpch, can some tell me how to fix the query?

Query code:

"SELECT S_NAME, COUNT(*) AS NUMWAIT FROM SUPPLIER, LINEITEM L1, ORDERS, NATION WHERE S_SUPPKEY = L1.L_SUPPKEY AND O_ORDERKEY = L1.L_ORDERKEY AND O_ORDERSTATUS = 'F' AND L1.L_RECEIPTDATE> L1.L_COMMITDATE AND EXISTS (SELECT * FROM LINEITEM L2 WHERE L2.L_ORDERKEY = L1.L_ORDERKEY AND L2.L_SUPPKEY <> L1.L_SUPPKEY) AND NOT EXISTS (SELECT * FROM LINEITEM L3 WHERE L3.L_ORDERKEY = L1.L_ORDERKEY AND L3.L_SUPPKEY <> L1.L_SUPPKEY AND L3.L_RECEIPTDATE > L3.L_COMMITDATE) AND S_NATIONKEY = N_NATIONKEY AND N_NAME = 'SAUDI ARABIA' GROUP BY S_NAME ORDER BY NUMWAIT DESC, S_NAME LIMIT 100;"

Re: Drill query cannot be planned possibly due to either a cartesian join or an inequality join

ssubhas — Wed, 31 May 2017 14:28:32 GMT

@mÁRIO Rodrigues

This seems to be known issue and Jira DRILL-5214 has been raised for the same.

question Re: Drill query cannot be planned possibly due to either a cartesian join or an inequality join in Archives of Support Questions (Read Only)

Drill query cannot be planned possibly due to either a cartesian join or an inequality join

Re: Drill query cannot be planned possibly due to either a cartesian join or an inequality join