It is now possible to create transactional tables that enable operations with ACID semantics in Hive 4.0 (HIVE-18453). These transactional tables are used for data streaming, slow changing dimensions, data restatement, and bulk modifications with the SQL MERGE statement. There is no need to provide table properties, but the file format is still limited to ORC.
Refer to the below example:
CREATE TRANSACTIONAL TABLE trxnTest(
PARTITIONED BY(MonthYear String)
STORED AS ORC;
Click here to learn how to enable the ACID properties in Hive if you aren’t using the specified version.
I hope you found this post to be both useful and instructive.
Please keep following us for more interesting updates.