| ==== |
| ---- QUERY |
| # Merge into partitioned target table with equality delete files from the source table |
| # using when not matched insert * clause |
| merge into iceberg_v2_delete_equality_partitioned target using (select cast(i+ 1000000 as int) i, s, d from iceberg_v2_delete_equality_partitioned) source |
| on target.i = source.i |
| when not matched then insert * |
| ---- TYPES |
| INT,STRING,DATE |
| ---- DML_RESULTS: iceberg_v2_delete_equality_partitioned |
| 1,'str1',2023-12-24 |
| 1,'str1',2023-12-25 |
| 2,'str2',2023-12-24 |
| 4,'str4',2023-12-24 |
| 222,'str2',2023-12-25 |
| 333333,'str3',2023-12-24 |
| 1000001,'str1',2023-12-24 |
| 1000001,'str1',2023-12-25 |
| 1000002,'str2',2023-12-24 |
| 1000004,'str4',2023-12-24 |
| 1000222,'str2',2023-12-25 |
| 1333333,'str3',2023-12-24 |
| ==== |
