[GitHub] [druid] suneet-s edited a comment on issue #9977: SQL SELECT with IN filter containing null value throws ISE

[GitBox <gi...@apache.org>]

suneet-s edited a comment on issue #9977:
URL: https://github.com/apache/druid/issues/9977#issuecomment-639828756


   Druid does not support joins against constant conditions - see #9942
   
   Calcite translates any in clause with a null to a join expression. If the in filter does not have null, Calcite will translate the query to an IN filter. So Druid can not support this type of query til #9942 is fixed.
   
   If you want this query to work, re-write it to
   
   ```
   select * from druid.foo where dim2 in ('a')
   ```
   
   This will produce the same results as the query filed in this issue.
   
   If you want the query to match nulls, then the above query should be re-written to
   
   ```
   select * from druid.foo where dim2 in ('a') or dim2 is NULL
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org