Support Questions
Find answers, ask questions, and share your expertise
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

Show table not working after HIVE ACID Enabled


Hi Team

After i enable ACID property in HIVE for HDP 2.5.5. iam getting below error when i run " show tables " in beeline

0: jdbc:hive2://server.hortonworks.> show tables ;

Error: Error while processing statement: FAILED: Error in acquiring locks: Error communicating with the metastore (state=42000,code=10)

Below properties that i added to enable ACID

Go to Hive->Config-Settings tab Make "Acid Transactions" = true Run Compactor=true ( it will automatically turn true) Number of threads used by compactor=2

Advanced tab-> GeneralTransaction Manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager Allow all partitions to be Dynamic = nonstrict Enforce bucketing=true

Advanced hive-siteUse Locking = true