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 22.214.171.124.0.0.0-1361) Driver: Hive JDBC (version 126.96.36.199.0.0.0-1361) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 188.8.131.52.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');