Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Can't change settings of Hive on HDP 2.6

avatar
New Member

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

avatar
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

avatar
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.

avatar
New Member

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.(