Delete 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;