Gahen edited a comment on issue #10525: URL: https://github.com/apache/druid/issues/10525#issuecomment-719056162
We'd also notice this issue to when filtering doing an SQL query like `SELECT * FROM some_table WHERE some_string_field IS NOT NULL AND (NOT some_string_field = 'some value') GROUP BY some_string_field`. The `EXPLAIN PLAN FOR` seems to show that druid discards the "not null" clause when parsing the SQL as it's the exact same when removing the `some_string_field IS NOT NULL AND` part. One workaround for us was to use `LIKE` instead of `IS` ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
