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]
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.