[jira] [Commented] (SPARK-19335) Spark should support doing an efficient DataFrame Upsert via JDBC

["Hamza Khribi (Jira)" <ji...@apache.org>]

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

Hamza Khribi commented on SPARK-19335:
--------------------------------------

Hello [~kevinyu98] , is there any news about this functionality? I believe its really essential for spark to support such functionality, i've been working with multiple clients where at some point they mix olap and oltp and its inevitable to do upserts on the business table giving the client's needs.

Besides i think that deciding to resume working on this functionality based on this issue ticket( that is not easily identified by the community) is not enough.

 

Thank you in advance,

Best

> Spark should support doing an efficient DataFrame Upsert via JDBC
> -----------------------------------------------------------------
>
>                 Key: SPARK-19335
>                 URL: https://issues.apache.org/jira/browse/SPARK-19335
>             Project: Spark
>          Issue Type: Improvement
>            Reporter: Ilya Ganelin
>            Priority: Minor
>
> Doing a database update, as opposed to an insert is useful, particularly when working with streaming applications which may require revisions to previously stored data. 
> Spark DataFrames/DataSets do not currently support an Update feature via the JDBC Writer allowing only Overwrite or Append.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

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