The table must be bucketed and stored using an ACID compliant format (such as ORC)

[#1]

alter table gives the following error

The table must be bucketed and stored using an ACID compliant format (such as ORC)

[#2]

See these for configuring ACID transactions in Hive:

• https://hortonworks.com/tutorial/using-hive-acid-transactions-to-insert-update-and-delete-data/#enab...
• https://community.hortonworks.com/articles/97113/hive-acid-merge-by-example.html

See this for implementing ORC format on your Hive files:

• https://orc.apache.org/docs/hive-ddl.html