Support Questions
Find answers, ask questions, and share your expertise

Can't change settings of Hive on HDP 2.6

New Contributor

Good day. I ran into the problem that I can not change the settings in Hive.

16632-111.jpg

The button is not pressed to include Acid.

Then I tried the following commands through Hive shell.

hive> set hive.support.concurrency = true;
hive> set hive.enforce.bucketing = true;
hive> set hive.exec.dynamic.partition.mode = nonstrict;
hive> set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
hive> set hive.compactor.initiator.on = true;
hive> set hive.compactor.worker.threads = 2;
But they does not changes some settings. What i must to do for enable ACID?
1 ACCEPTED SOLUTION

Accepted Solutions

Guru

Hi @Yliy Scherbak

The only time I've run into that is when I was logged into Ambari with a non-admin user. Make sure you are logged in as an Ambari user with admin rights.

View solution in original post

2 REPLIES 2

Guru

Hi @Yliy Scherbak

The only time I've run into that is when I was logged into Ambari with a non-admin user. Make sure you are logged in as an Ambari user with admin rights.

View solution in original post

New Contributor

Yes, i login as raj_ops and its works, on maria_dev its not working. But i have new issue, i cant restart hive its always aborted.(