Hive update and delete limitations

Question

I have heard that there are few limitations for Hive table, that we can not enter any data. What are these limitations?

Answer 1

In Hive, Update and Delete work based on these limitations:

• Update/Delete can only be performed on tables that support ACID
• If you want to use a Hive table in ACID writes (insert, update, delete) then the table property “transactional” must be set on that table.
• Only ORC file format is supported
• Tables must be bucketed to make use of these features

Answer 2

Vinyl-like crackle sounds. And what is my serial number for Hive 2?