Ambari fecth timeout after one minute executing simple select

[#1]

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.h...

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

[#2 · Accepted solution]

@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.

[#3]

@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