UPDATE
Syntax
UPDATE tablename SET column = value [, column = value ...] [WHERE expression]
Description
This statement is used to update table data based on conditions.
Remarks
- Only the transaction table in ORC format is supported, and the table cannot be an external table.
- The Where clause does not support subqueries.
- The syntax set (column_name1,column_name2, ...) = (value1,value2, ...) is not supported.
Example
-- Create a transaction table. create table upd_tb(col1 int,col2 string) with (format='orc',transactional=true); --Insert data. insert into upd_tb values (3,'A'),(4,'B'); -- Change the value of col1 = 4. update upd_tb set col1=5 where col1=4; -- The col1=4 record is modified. select * from upd_tb; -- col1 | col2 ------|------ 5 | B 3 | A
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.