Deleting data from a table

You use the DELETE statement to delete data already written to an ACID table.

Use the following syntax to delete data from a Hive table. DELETE FROM tablename [WHERE expression];
Delete any rows of data from the students table if the gpa column has a value of 1 or 0.
DELETE FROM students WHERE gpa <= 1,0;