@mahfooz  The property value can be modified only in hive-site.xml cluster configuration file. This will oblige you to restart the stale hive configuration and becomes a cluster-wide change rather than a runtime change. HTH ... View more

Hello @mahfooz , thank you for raising your question about Hive's ACID support on CDH5.16. Based on [1] and, no Hive currently does not support ACID transactions.  Cloudera recommends using the Parquet file format, which works across many tools. Kind regards: Ferenc   [1] https://docs.cloudera.com/documentation/enterprise/5-16-x/topics/hive_ingesting_and_querying_data.html#hive_transaction_support   ... View more