Steve Carlin created IMPALA-15691:
-------------------------------------

             Summary: Calcite planner: INVALID_TYPE on "null not in" query
                 Key: IMPALA-15691
                 URL: https://issues.apache.org/jira/browse/IMPALA-15691
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: Steve Carlin


The following query fails with the Calcite planner:

SELECT a.id, a.int_col, a.string_col FROM functional_parquet.alltypessmall a 
WHERE NULL NOT IN (SELECT null); Query: SELECT a.id, a.int_col, a.string_col 
FROM functional_parquet.alltypessmall a WHERE NULL NOT IN (SELECT null) 

RuntimeException: Unknown type INVALID_TYPE 

To run this, make sure "planner=calcite" and "fallback_planner=none"



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to