question Ambari fecth timeout after one minute executing simple select in Support Questions

Ambari fecth timeout after one minute executing simple select

ourahma84 — Fri, 19 Jul 2019 12:09:40 GMT

Hello,

Whene executing a simple select on Ambari hive, i get "result fetch time out" error after one inute of execution.

I follow the solution described on : https://community.hortonworks.com/articles/90768/how-to-fix-ambari-hive-view-15-result-fetch-timed.html

but still facing the same error.

I modified properties in "/etc/ambari-server/conf/ambari.properties" but after restarting the server i open this file and i can't see my modifications, is it normal ?

Please can anyone help me.

Thanks,

Yassine

Re: Ambari fecth timeout after one minute executing simple select

jsensharma — Fri, 19 Jul 2019 12:36:10 GMT

@Yassine OURAHMA

After setting those properties have you tries restarting Ambari Server?

What is your ambari version?

Are you setting the properties for the correct Hive View instance name inside the "ambari.properties"

Example:

views.ambari.hive.AUTO_HIVE20_INSTANCE.connection.inactivity.timeout=1200000 
views.ambari.hive.AUTO_HIVE20_INSTANCE.result.fetch.timeout=1200000

Also can you please share the exact query and the exact error with complete stack trace from Hive View log and ambari-server.log?

/var/log/ambari-server/ambari-server.log 
/var/log/ambari-server/hive20-view/hive20-view.log

Also please share the output of the following commands:

# grep -e "timeout\|views" /etc/ambari-server/conf/ambari.properties

Can you please try this as well to see if it works for you? Please execute the same Hive Query from Hive View 2.0 By setting the additional hive param in Hive View 2.0

"Settings Tab" in "Hive View 2.0" --> Settings (Tab) --> Add a new property

Key as "hive.fetch.task.conversion" and value as "none"

Then run the same query again from hive view.

Re: Ambari fecth timeout after one minute executing simple select

ourahma84 — Fri, 19 Jul 2019 15:21:05 GMT

@Jay Kumar SenSharma

Adding the param hive.fetch.task.conversion to "Hive View 2.0" solved the problem.

Can you please explain me what this param doing and how to apply it for all users ?

Thank you very much