[jira] [Created] (DRILL-4975) Null equality join over non existing columns returns nulls forever

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-4975:
-------------------------------------

             Summary: Null equality join over non existing columns returns nulls forever
                 Key: DRILL-4975
                 URL: https://issues.apache.org/jira/browse/DRILL-4975
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.9.0
            Reporter: Khurram Faraaz



Null equality join query that involves non-existing columns in the join predicate, runs for ever and returns nulls. 
Since the columns are not part of the parquet file, the join should fail gracefully, and not return infinite number of nulls.

{noformat}
SELECT t1.col_blah , t2.col_blah FROM typeall_l t1, typeall_r t2 WHERE t1.col_blah = t2.col_blah OR ( t1.col_blah IS NULL AND t2.col_blah IS NULL );
...
| null     | null      |
| null     | null      |
| null     | null      |
| null     | null      |
| null     | null      |
| null     | null      |
...
{noformat}

Upon removing, OR ( t1.col_blah IS NULL AND t2.col_blah IS NULL ) from the query, no results are returned, as expected.



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