anuragmantri opened a new pull request, #57227:
URL: https://github.com/apache/spark/pull/57227
## What changes were proposed in this pull request?
This PR adds the dynamic table options syntax to MERGE statements. MERGE
requires options on both the target table and the source table.
## Why are the changes needed?
This is a continuation to adding options syntax in DMLs SPARK-49098
## Does this PR introduce any user-facing change?
Yes, it adds new SQL syntax. For example:
```sql
MERGE INTO catalog.db.target t WITH (`write.split-size` = 10)
USING catalog.db.source WITH (`split-size` = 5) s
ON t.id = s.id
WHEN MATCHED THEN UPDATE SET t.status = 'archived'
WHEN NOT MATCHED THEN INSERT *
```
## How was this patch tested?
Added tests to the following suites.
- Parser (DDLParserSuite)
- End-to-end (MergeIntoTableSuiteBase)
## Was this patch authored or co-authored using generative AI tooling?
I used Claude Code (Claude Opus 4.8) to generate the code and tests and
verified manually.
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
