shashanksinghal opened a new issue #10525: URL: https://github.com/apache/druid/issues/10525
### Affected Version 0.18.0 and 0.20.0 ### Description For druid 0.18.0 and config useDefaultValueForNull to false, querying a table with condition on string column (lets say col) with condition like col <> '' and col is not null returns rows with that column null. Both of these conditions behave correctly if passed separately but when together, nulls are not filtered at all. - Cluster size Local docker setup - Configurations in use useDefaultValueForNull is False - Steps to reproduce the problem 1. Setup local druid 0.18.0 using docker setup 2. Load example data viz. wikipedia 3. Query: select * from wikipedia where cityName is not null and cityName <> '' limit 100 - The error message or stack traces encountered. In the results you can see rows with cityName null as well - Any debugging that you have already done I tested it with version 0.18.0 and 0.20.0 and both have these issue ---------------------------------------------------------------- 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]
