Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Invalid
-
1.9.0, 1.10.0
-
None
-
None
Description
The following query fails to execute
SELECT * FROM (SELECT `UserID` FROM `dfs`.`path_ot_parquet` tc) `t0` INNER JOIN (SELECT `UserID` FROM `dfs`.`path_ot_parquet` tc) `t1` ON (`t0`.`UserID` IS NOT DISTINCT FROM `t1`.`UserID`)
and produces the following error message
org.apache.drill.common.exceptions.UserRemoteException: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join [Error Id: 0bd41e06-ccd7-45d6-a038-3359bf5a4a7f on mgelbana-incorta:31010]
While the query's equivalent form runs fine
SELECT * FROM (SELECT `UserID` FROM `dfs`.`path_ot_parquet` tc) `t0` INNER JOIN (SELECT `UserID` FROM `dfs`.`path_ot_parquet` tc) `t1` ON (`t0`.`UserID` = `t1`.`UserID` OR (`t0`.`UserID` IS NULL AND `t1`.`UserID` IS NULL))