Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)

The following parameters decide if ACID is enabled or disabled in your cluster.

ACID Enable:

hive.support.concurrency=true;
hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
hive.enforce.bucketing=true;
hive.exec.dynamic.partition.mode=nostrict;
*** The following parameters are required for standalone hive metastore ***
hive.compactor.initiator.on=true;
hive.compactor.worker.threads=1

NOTE:

Even though HiveServer2 runs with an embedded metastore, a standalone Hive metastore is required for ACID support to function properly. If you are not using ACID support with HiveServer2, you do not need a standalone metastore.

ACID Disable:

If not using ACID, then make sure the value of the parameters are set as below to avoid any hive locking issues

hive.support.concurrency=false;
hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager;
hive.enforce.bucketing=false;
hive.exec.dynamic.partition.mode=strict;
hive.compactor.initiator.on=false;
hive.compactor.worker.threads=0;
3,041 Views
Comments
New Contributor

Then, if I turn on ACID Transactions option, do I need to install Hive Standalone Metastore additionally?

New Contributor

Hi @knarendran,

is this guide also working for HDP 3.0?

Because i would like to disable ACID transactions and after i've changed all this parameters i'm getting this error (when trying to create an internal table test):

Error: Error while compiling statement: FAILED: SemanticException [Error 10265]: This command is not allowed on an ACID table default.test with a non-ACID transaction manager. Failed command: create table test (a string) (state=42000,code=10265)

Thanks in advance,

Davide

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎03-31-2017 11:35 PM
Updated by:
 
Contributors
Top Kudoed Authors