You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2016/10/26 11:23:58 UTC

[jira] [Created] (DRILL-4966) null equality join results in UNSUPPORTED_OPERATION ERROR

Khurram Faraaz created DRILL-4966:
-------------------------------------

             Summary: null equality join results in UNSUPPORTED_OPERATION ERROR
                 Key: DRILL-4966
                 URL: https://issues.apache.org/jira/browse/DRILL-4966
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.9.0
            Reporter: Khurram Faraaz


Below join query (HashJoin) executes. (note that the join columns are not checked if they are null).

git commit id : a29f1e29
Drill 1.9.0

{noformat}
select t1.c1, t2.c2 from `t_alltype.parquet` t1, `t_alltype.parquet` t2 WHERE t1.c1 = t2.c1 AND t1.c2 = t2.c2;
+------+--------------+
|  c1  |      c2      |
+------+--------------+
| 1    | 592475043    |
| 2    | 1194343172   |
...
...
142 rows selected (0.462 seconds)
{noformat}

checking if the join columns are null results in UNSUPPORTED_OPERATION ERROR.

{noformat}
0: jdbc:drill:schema=dfs.tmp> select t1.c1, t2.c2 from `t_alltype.parquet` t1, `t_alltype.parquet` t2 WHERE t1.c1 = t2.c1 AND t1.c2 = t2.c2 OR (t1.c1 IS NULL AND t2.c1 IS NULL AND t2.c2 IS NULL AND t1.c2 IS NULL);
Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join


[Error Id: f9df328d-28d8-46f4-86f5-e67d60e20589 on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

{noformat}
0: jdbc:drill:schema=dfs.tmp> select t1.c1, t2.c2 from `t_alltype.parquet` t1, `t_alltype.parquet` t2 WHERE t1.c1 = t2.c1 AND t1.c2 = t2.c2 OR (t1.c1 IS NULL AND t2.c1 IS NULL);
Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join


[Error Id: df76fce9-88d4-49bf-b487-7d897667755a on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

{noformat}
0: jdbc:drill:schema=dfs.tmp> select t1.c1, t2.c2 from `t_alltype.parquet` t1, `t_alltype.parquet` t2 WHERE t1.c1 = t2.c1 AND t1.c2 = t2.c2 OR (t1.c2 IS NULL AND t2.c2 IS NULL);
Error: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join


[Error Id: 25064c21-4197-4cf6-a1b8-6edfc2788fc9 on centos-01.qa.lab:31010] (state=,code=0)
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)