Alter a table from flat to transactional
You might have a flat table, which is a non-transactional table in the Hive warehouse, present from earlier releases. You can use an ALTER TABLE statement to change a table from flat to transactional.
Upon completion of the task, you can immediately run update and delete operations on the table.
Start the Hive shell:
From the command line:
Enter your user name and password.
The Hive 3 connection message appears, followed by the Hive prompt for entering HiveQL queries on the command line:
Connected to: Apache Hive (version 220.127.116.11.0.0.0-1361) Driver: Hive JDBC (version 18.104.22.168.0.0.0-1361) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 22.214.171.124.0.0.0-1361 by Apache Hive 0: jdbc:hive2://c7402.ambari.apache.org:2181,>
Alter the flat table to make it transactional.
ALTER TABLE T3 SET TBLPROPERTIES ('transactional'='true');