Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Can't change settings of Hive on HDP 2.6

avatar

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

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