Description
Proposing syntax
INSERT INTO tbl REPLACE whereClause identifierList
to the spark SQL, as the equivalent of dataframe.overwrite() command.
For Example
INSERT INTO table1 REPLACE WHERE key = 3 SELECT * FROM table2
will, in an atomic operation, 1) delete rows with key = 3 and 2) insert rows from table2
Attachments
Issue Links
- is a parent of
-
SPARK-43220 INSERT INTO REPLACE statement can't support WHERE with bool_expression
-
- Closed
-
- links to