Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-28303

Support DELETE/UPDATE/MERGE Operations in DataSource V2

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
      None

      Description

      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,

      SupportsDelete.java
      public interface SupportsDelete {
        WriteBuilder delete(Filter[] filters); 
      }
      

      which can delete data by simple predicates (complicated cases like correlated subquery is not considered currently).

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                xinxianyin Xianyin Xin
                Reporter:
                xinxianyin Xianyin Xin
              • Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: