Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ambari fecth timeout after one minute executing simple select

Solved Go to solution
Highlighted

Ambari fecth timeout after one minute executing simple select

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Ambari fecth timeout after one minute executing simple select

Super Mentor

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


2 REPLIES 2

Re: Ambari fecth timeout after one minute executing simple select

Super Mentor

@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

New Contributor

@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