question Re: Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev in Support Questions

Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev

hivijayas — Fri, 26 May 2017 17:43:27 GMT

Unable to work with Lab 2

Re: Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev

jsensharma — Fri, 26 May 2017 18:09:17 GMT

Can you pelase share the complete stackTrace of the error that you are getting in the ambari UI as well as from the ambari logs?

Are you running some long running query?

If yes then did you try setting the following property in the "/etc/ambari-server/conf/ambari.properties" to a larger value (more than the time that you expect the hive to return the result).

views.ambari.hive.<InstanceName>.result.fetch.timeout=xxxxxx

Please see: https://community.hortonworks.com/articles/90768/how-to-fix-ambari-hive-view-15-result-fetch-timed.html

Re: Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev

jsensharma — Fri, 26 May 2017 18:11:16 GMT

@Vijaya S

If you are getting this Querytimeout error as soon as you try to access the HiveView then please check if you have the ATS and the HiveServer instances running and you are able to do the "Run Service Check" successfully from the

Ambari UI --> Hive --> Service Actions --> 'Run Service Check'

Ambari UI --> Yarn --> Service Actions --> 'Run Service Check'

Also in your Labs do you have enough Memory (RAM) and also please check if the the hive and ATS logs are showing any warning/error?

Re: Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev

hivijayas — Fri, 26 May 2017 18:44:39 GMT

@Jay SenSharma

Thank you for the prompt response.

Actually after a couple of tries I restarted my Sandbox and connected to it again. And after that it started working for me.

I did not get a chance to try your suggestion.

Re: Service 'ats' check failed: Server Error Service 'hiveserver' check failed: Query timed out to fetch table description for user: maria_dev

smartman4157 — Thu, 15 Apr 2021 16:30:44 GMT

I followed up the directions, but It is still not working 😞