Using MERGE in TRINO over Target Partition

Question

While using MERGE statement in Trino-Icerberg ; one of the big table takes lots of time. reason it reads whole TARGET table to evaluate the search condition (ON source.col = target.col)

-- is there a way this scanning can be limited to recent partitions (days)

TRIED finding in standard docs but could not find anything as partition specific MERGE https://www.starburst.io/blog/apache-iceberg-dml-update-delete-merge-maintenance-in-trino/

Answer 1

Put your partitions too on your ON conditions:

Ex:

ON source.col = target.col AND source.create_date = target.create_date