Home » Electric Destinations Digest » Can We Update the Data in Hive

Can We Update the Data in Hive

Sarah Jenkins • • 7 min read
Can We Update the Data in Hive

Use the UPDATE statement to modify data already written to Apache Hive. Depending on the condition specified in the optional WHERE clause, an UPDATE statement may affect every row in a table. You must have both the SELECT and UPDATE privileges to use this statement.

Can you update data in Hive?

Hive does not support UPDATE option. But the following alternative could be used to achieve the result: Update records in a partitioned Hive table : The main table is assumed to be partitioned by some key.

How do I update Hive external table data?

  1. Use Temporary Hive Table to Update Table.
  2. Set TBLPROPERTIES to enable ACID transactions on Hive Tables.
  3. Use HBase to update records and create Hive External table to display HBase Table data.
Sarah Jenkins
Author

Sarah Jenkins

Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.