Section 8:88. Updating and Deleting the data in Hive Bucketed Tables
To update and delete data in Hive, you can use the UPDATE and DELETE statements. Here’s how you can use them:
- Updating Data:
To update data in Hive, you can use the UPDATE statement followed by the name of the table and the new values you want to update. Here’s an example:
- Deleting Data:
To delete data in Hive, you can use the DELETE statement followed by the name of the table and the condition that specifies which rows to delete. Here’s an example:
Deleting Data:
DELETE FROM orders WHERE order_id =2;
3. Truncate data:
To truncate data in Hive, you can use the TRUNCATE TABLE statement. The TRUNCATE TABLE statement deletes all data from a table and resets the table to its original state (empty table).
Here’s an example of how to truncate a table in Hive:
