Ambari fecth timeout after one minute executing simple select

Question

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

jsensharma · Accepted Answer

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

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.