Deleting data from a table
You use the DELETE statement to delete data already written to an ACID table from Hive. Impala does not support deletions of ACID data.
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;