platinumhamburg opened a new issue, #1656: URL: https://github.com/apache/fluss/issues/1656
### Search before asking - [x] I searched in the [issues](https://github.com/apache/fluss/issues) and found nothing similar. ### Motivation Currently, we enforce a strict limitation that prefix lookup columns must encompass all partition fields when querying partitioned tables. However, in numerous practical scenarios, users require the flexibility to perform prefix lookups across multiple partitions. A common use case is executing delta joins where join keys originate from different partitions. ### Solution - Concurrent Multi-Partition Prefix Lookup: Implement support for concurrent prefix lookups across multiple partitions, with automatic result merging. - Partition Pruning with Predicate Pushdown in PrefixLookup: Enable partition pruning based on pushed-down predicates, including both JOIN conditions and WHERE conditions, to minimize unnecessary data scanning and improve query performance. ### Anything else? _No response_ ### Willingness to contribute - [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]
