zhoulii opened a new issue, #8944: URL: https://github.com/apache/paimon/issues/8944
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Motivation Negative predicates such as IS NOT NULL, !=, and NOT IN currently require reading all non-null BTree index files. This causes unnecessary index file reads when only a small number of files contain null values or the specified literals. ### Solution For BTree global indexes, evaluate negative predicates as a complement of the current row-id range. Exclude rows returned by IS NULL and the corresponding positive predicate (= or IN), while preserving SQL null semantics. Fall back to the existing behavior when the required positive predicates are unsupported. ### Anything else? _No response_ ### Are you willing to submit a PR? - [x] I'm willing to submit a PR! -- 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]
