Update data in a table
The syntax describes the UPDATE statement you use to modify data already stored in an Apache Hive table. An example shows how to apply the syntax.
UPDATE tablename SET column = value [, column = value ...] [WHERE
Depending on the condition specified in the optional WHERE clause, an UPDATE statement might affect every row in a table. The expression in the WHERE clause must be an expression supported by a Hive SELECT clause. Subqueries are not allowed on the right side of the SET statement. Partition and bucket columns cannot be updated.
UPDATE students SET name = null WHERE gpa <= 1.0;