Support Questions
Find answers, ask questions, and share your expertise

Ambari hive view not populating databases

Explorer

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

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.

.