question Re: hive setting tab disabled in ambari in Support Questions

hive setting tab disabled in ambari

anuraj_iiith — Fri, 02 Sep 2016 05:11:02 GMT

We recently modified `hive.server2.tez.default.queues` to have comma-separated list of string. Since then we can't access the setting tab for Hive. See screenshot. We can't update hive settings now. Could someone suggest a hack to fix this? Is there an easy way to update a single property via Ambari API?

screen-shot-2016-09-01-at-30934-pm.png

Advanced tab is accessible along with other UI components. I am thinking comma-separated values must be the reason behind the broken setting tab. Using Ambari 2.2.1.1

I have tried loading the page in incognito mode to make sure there is no cache interference but it doesn't seem to help

Re: hive setting tab disabled in ambari

lraheja — Fri, 02 Sep 2016 05:41:17 GMT

@Anuraj Pandey Can you please upload the value of "hive.server2.tez.default.queues" .

Re: hive setting tab disabled in ambari

sshridhar — Fri, 02 Sep 2016 06:04:00 GMT

@Anuraj Pandey

1. Can you check for latest version of hive-site via API to get the value of "hive.server2.tez.default.queues"

<Host IP>:8080/api/v1/clusters/c1/configurations

Search hive-site and pick the latest/last version from there, and click on it.

The URL will be like :

<Host IP>:8080/api/v1/clusters/c1/configurations?type=hive-site&tag=<latest tag version>

Search for "hive.server2.tez.default.queues"

2. Also, check the API call which is failing/hanging. If you are using chrome browser, start from a service other than HIVE.

Right click and select "Inspect element", followed by clicking "Network" tab. Then come to "setting" tab for Hive, and note the API calls made. Determine which one is failing and post it here.

Other option is going back to the pervious config version for HIVE and retrying setting the config.

Re: hive setting tab disabled in ambari

anuraj_iiith — Mon, 19 Aug 2019 09:16:35 GMT

@lraheja etl,prod,reporting,dev,default

@swapnil API call is not failing. There is a bug in frontend javascript. See the following screenshots for details.

I was able to hack up the javascript to force "hive.server2.tez.default.queues=default" and load the page.

Re: hive setting tab disabled in ambari

lraheja — Fri, 02 Sep 2016 06:29:53 GMT

@Anuraj Pandey can you please modify the value and change it to below and restart the required services :

from

etl,prod,reporting,dev,default

default,etl,prod,reporting,dev

This should fix your issue. Please let me know how it goes. Also do not forget to restart Hive after you make the changes.

Re: hive setting tab disabled in ambari

anuraj_iiith — Sat, 03 Sep 2016 02:30:58 GMT

Thanks @lraheja. Your suggestion worked.