question Can't change settings of Hive on HDP 2.6 in Archives of Support Questions (Read Only)

Can't change settings of Hive on HDP 2.6

ylikscherbak — Sun, 18 Aug 2019 00:57:23 GMT

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

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?

Re: Can't change settings of Hive on HDP 2.6

ssahi — Fri, 30 Jun 2017 22:09:52 GMT

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.

Re: Can't change settings of Hive on HDP 2.6

ylikscherbak — Sat, 01 Jul 2017 17:05:16 GMT

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