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)