[HUDI-2968] Support Delete/Update using non-pk fields

• Type: Task
• Status: Closed
• Priority: Blocker
• Resolution: Done
• Fix Version/s: 0.11.0
• Component/s: spark
• Labels: pull-request-available
• Story Points: 0
• Epic Link: Hudi Spark SQL
• Assignee: Yann Byron
• Reporter: pengzhiwei

Reviewers

Shiyan Xu

• Created: 09/Dec/21 03:15
• Updated: 01/Mar/22 12:13
• Resolved: 16/Jan/22 20:17

Description

Allow to delete/update using non-pk fields

create table h0 (
  id int,
  name string,
  price double
) using hudi 
options (primaryKey = 'id');

update h0 set price = 10 where name = 'foo'; 
delete from h0 where name = 'foo';

Issue Links

• is a clone of: HUDI-1885 Support Delete/Update Non-Pk Table
• relates to: HUDI-2234 MERGE INTO works only ON primary key
• Testing discovered: HUDI-3314 support merge into with no-pk condition
• links to: GitHub Pull Request #4568