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)