Update data in a table
You use the UPDATE statement to modify data already stored in an Apache Hive table.
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;