Anton Okolnychyi created SPARK-35801:
----------------------------------------
Summary: SPIP: Support MERGE in Data Source V2
Key: SPARK-35801
URL: https://issues.apache.org/jira/browse/SPARK-35801
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.2.0
Reporter: Anton Okolnychyi
[MERGE INTO|https://en.wikipedia.org/wiki/Merge_(SQL)] is well suited to
large-scale workloads because it can express operations to insert, update, or
delete multiple rows in a single SQL command. Many updates can be expressed as
MERGE INTO queries that would otherwise require much more SQL. Common patterns
for updating partitions are to read, union, and overwrite or read, diff, and
append. Using MERGE INTO, these operations are easier to express and can be
more efficient to run.
Hive supports [MERGE
INTO|https://blog.cloudera.com/update-hive-tables-easy-way/] and Spark should
implement similar support.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
