[SPARK-28909] ANSI SQL: delete and update does not support in Spark

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 29/Aug/19 09:21
• Updated: 29/Dec/19 00:30
• Resolved: 14/Sep/19 05:45

Description

delete and update supported in PostgresSQL

create table emp_test(id int);
insert into emp_test values(100);
insert into emp_test values(200);
select * from emp_test;
delete from emp_test where id=100;
select * from emp_test;
update emp_test set id=500 where id=200;
select * from emp_test;

Issue Links

• duplicates: SPARK-28303 Support DELETE/UPDATE/MERGE Operations in DataSource V2