UPDATE keyword
Updates data in a database table.
#
Syntaxnote
- the same
columnName
cannot be specified multiple times after the SET keyword as it would be ambiguous - the designated timestamp column cannot be updated as it would lead to altering history of the time-series data
- If the target partition is
attached by a symbolic link,
the partition is read-only.
UPDATE
operation on a read-only partition will fail and generate an error.
#
ExamplesUpdate with constant
Update with function
Update with join
Update with multiple joins
Update with a sub-query