Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ambari hive view not populating databases

Ambari hive view not populating databases

New Contributor

Issue description – When starting Ambari the Database explorer is unusable for 2 minutes until an error message appears " "Query timed out to fetch table description for user: XXXX"", then the user has to refresh the database explorer in order to get a database and table listing.

This is an intermittent issue which gets resolved after refreshing or login in for the second time.

Action steps – In order to resolve the issue ,we changed the ambari timeout properties but it didn't resolve the issue.

agent.package.install.task.timeout=1800

agent.task.timeout=900

server.http.session.inactive_timeout=1800

server.task.timeout=1200

user.inactivity.timeout.default=900

user.inactivity.timeout.role.readonly.default=900

views.ambari.hive.Hive_view.result.fetch.timeout=6000000

views.ambari.hive.hive_instance_1_50.result.fetch.timeout=6000000

views.ambari.request.connect.timeout.millis=6000000

views.ambari.request.read.timeout.millis=6000000

PFA application logs and system configuration settings.

68383-ambari-database-empty.jpg

1 REPLY 1

Re: Ambari hive view not populating databases

Super Mentor

@Akash Mendiratta
The default "sync.query.timeout" is (60*1000) milliseconds .. means 1 minute. So please try increasing the value and see if it works for you.

https://github.com/apache/ambari/blob/release-2.6.1/contrib/views/hive20/src/main/java/org/apache/am...

https://github.com/apache/ambari/blob/release-2.6.1/contrib/views/hive-next/src/main/java/org/apache...



In "/etc/ambari-server/conf/ambari.properties" file please add the following property to increase the sync timeout as bit.

Syntax:
views.ambari.hive.<HIVE2_INSTANCE_NAME>.sync.query.timeout=120000

Example:
views.ambari.hive.hive_instance_1_50.sync.query.timeout=120000


Please replace the "<HIVE2_INSTANCE_NAME>" with your Hive View instance name.

After adding the above property please restart the ambari server.

.