spark-issues mailing list archives

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

    [ https://issues.apache.org/jira/browse/SPARK-28303?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16942037#comment-16942037
] 

Timothy Zhang commented on SPARK-28303:
---------------------------------------

I just found this issue. Here is the issue reported by me: https://issues.apache.org/jira/browse/SPARK-29185.
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: https://issues.apache.org/jira/browse/SPARK-28303
>             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|title=SupportsDelete.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
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message