gortiz commented on issue #16821: URL: https://github.com/apache/pinot/issues/16821#issuecomment-3293706217
This change was added in https://github.com/apache/pinot/pull/16658. The PR explains the issue, but the TL;DR: is it was a bug fix when, like in they query you include here, only basic null handling is used. When that happens, IS NULL cannot be removed because our null implementation is not actually compatible with SQL semantics. If null handling is enabled, the plan should be what you expect -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
