In this recipe, you will learn how to delete data from a table in Hive.
Deleting data from a Hive table is the traditional way of deleting data in a table in any RDBMS. Deleting data in a table can only be performed if the table supports ACID properties.
The general format of deleting data in a table is as follows:
DELETE FROM tablename [WHERE expression]
Where:
tablename
: This is the name of the tableWHERE
expression: This is an optional clause. Only rows that match theWHERE
clause will be deleted
This recipe requires having Hive installed as described in the Installing Hive recipe of Chapter 1, Developing Hive. You will also need the Hive CLI or Beeline client to run the commands.
This recipe requires transactions enabled, so refer to Enabling transactions in Hive for that.
Follow the next step to delete data in a table in Hive:
DELETE FROM sales WHERE id = 1;