Runtime Filter

参考链接：

• https://docs.google.com/document/d/16IEuyLeQlubQkH8YuVuXWKo2-grVIoDJqQpHZrE7q04/edit?tab=t.0
• https://www.modb.pro/db/557718
• https://issues.apache.org/jira/browse/SPARK-32268
• https://github.com/apache/spark/pull/35789
• https://docs.google.com/document/d/16IEuyLeQlubQkH8YuVuXWKo2-grVIoDJqQpHZrE7q04/edit

SELECT * FROM order JOIN items ON order.item_id = items.id WHERE items.price > 7999

https://mp.weixin.qq.com/s/jpKGaBgi9TXlBo5yvwlWrw

presto

push down of dynamic filters from partitioned joins into the table scans on the left side of that join.

https://trino.io/docs/current/admin/dynamic-filtering.html