spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Timothy Zhang (Jira)" <>
Subject [jira] [Commented] (SPARK-28303) Support DELETE/UPDATE/MERGE Operations in DataSource V2
Date Tue, 01 Oct 2019 14:48:00 GMT


Timothy Zhang commented on SPARK-28303:

I just found this issue. Here is the issue reported by me:
Based on my analysis on current Spark JDBC codes I found it is easy to extend to support DELETE/UPDATE/MERGE
just enhance SaveMode and add some statements of DELETE/UPDATE/MERGE. Would you please look
at the issue 29185? 

> Support DELETE/UPDATE/MERGE Operations in DataSource V2
> -------------------------------------------------------
>                 Key: SPARK-28303
>                 URL:
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Xianyin Xin
>            Priority: Major
> Now many datasources (delta, jdbc, hive with transaction support, kudu, etc) supports
deleting/updating data. It's necessary to add related APIs in the datasource V2 API sets.
> For example, we suggest add the below interface in V2 API,
> {code:java||borderStyle=solid}
> public interface SupportsDelete {
>   WriteBuilder delete(Filter[] filters); 
> }
> {code}
> which can delete data by simple predicates (complicated cases like correlated subquery
is not considered currently).

This message was sent by Atlassian Jira

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message