v.25.11Improvement
Subqueries which take part inside
Subqueries which take part inside IN expressions when querying Iceberg table will be precomputed in the right way before partition pruning analysis. #89177 (Daniil Ivanik).
Why it matters
This feature ensures that subqueries withinIN expressions are fully evaluated prior to partition pruning, improving query correctness and potentially enhancing performance when querying Iceberg tables by enabling more effective partition pruning.How to use it
To benefit from this feature, simply write queries on Iceberg tables that use subqueries withinIN expressions as usual. The subqueries will be automatically precomputed before partition pruning during query execution.