Sidebar

HPL/SQL is included to Apache Hive since version 2.0

update

UPDATE Statement

UPDATE statement allows you to update columns of existing rows in the specified table.

Syntax:

UPDATE table_name
  SET col = expr [, coln = exprn] ...
  [WHERE condition]
 
UPDATE table_name
  SET (col [, coln] ...) = (expr [, exprn] ... | select_statement)
  [WHERE condition]