Updated on 2025-03-17 GMT+08:00

UPDATE

This command is used to update the Hudi table based on the column expression and optional filtering conditions.

UPDATE tableIdentifier SET column = EXPRESSION(,column = EXPRESSION) [ WHERE boolExpression]

**Table 1** Parameters
Parameter	Description
tableIdentifier	Name of the Hudi table to be updated.
column	Target column to be updated.
EXPRESSION	Expression of the source table column to be updated in the target table.
boolExpression	Filtering condition expression.

update h0 set price = price + 20 where id = 1;
update h0 set price = price *2, name = 'a2' where id = 2;

You can view the result in driver logs or on the client.

Parent topic: Hudi DML Syntax