Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Ambari TimeoutException

avatar

Apache Ambari Version2.6.0.0

While executing the hive query with limit 5 also.

Giving the error shown below:

{"trace":"java.util.concurrent.TimeoutException: deadline passed\n\njava.util.concurrent.TimeoutException: deadline passed\n\tat akka.actor.dsl.Inbox$InboxActor$$anonfun$receive$1.applyOrElse(Inbox.scala:117)\n\tat scala.PartialFunction$AndThen.applyOrElse(PartialFunction.scala:189)\n\tat akka.actor.Actor$class.aroundReceive(Actor.scala:467)\n\tat akka.actor.dsl.Inbox$InboxActor.aroundReceive(Inbox.scala:62)\n\tat akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)\n\tat akka.actor.ActorCell.invoke(ActorCell.scala:487)\n\tat akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)\n\tat akka.dispatch.Mailbox.run(Mailbox.scala:220)\n\tat akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397)\n\tat scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)\n\tat scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)\n\tat scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)\n\tat scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)\n","message":"Result fetch timed out","status":500}

For this I have increased the time in

following properties in "/etc/ambari-server/conf/ambari.properties"

views.request.read.timeout.millis=450000

Still facing the same error

1 ACCEPTED SOLUTION

avatar
Master Mentor

@Praveen Atmakuri

Can you try setting the following properties in "/etc/ambari-server/conf/ambari.properties" as described in the following link to see if it works: https://community.hortonworks.com/articles/90768/how-to-fix-ambari-hive-view-15-result-fetch-timed.h...

From Ambari 2.4 this new parameter is added that can be used to define the Hive Instance specific settings.

views.ambari.hive.<HIVE_VIEW_INSTANCE_NAME>.result.fetch.timeout=450000

Example:

views.ambari.hive.AUTO_HIVE_INSTANCE.result.fetch.timeout=450000

Here above is the most important ambari.properties for the Hive View 1.5/2.0. Here please replace the "<HIVE_VIEW_INSTANCE_NAME>" with your View Instance name.

Then restart the ambari server.

.

View solution in original post

3 REPLIES 3

avatar
Master Mentor

@Praveen Atmakuri

Can you try setting the following properties in "/etc/ambari-server/conf/ambari.properties" as described in the following link to see if it works: https://community.hortonworks.com/articles/90768/how-to-fix-ambari-hive-view-15-result-fetch-timed.h...

From Ambari 2.4 this new parameter is added that can be used to define the Hive Instance specific settings.

views.ambari.hive.<HIVE_VIEW_INSTANCE_NAME>.result.fetch.timeout=450000

Example:

views.ambari.hive.AUTO_HIVE_INSTANCE.result.fetch.timeout=450000

Here above is the most important ambari.properties for the Hive View 1.5/2.0. Here please replace the "<HIVE_VIEW_INSTANCE_NAME>" with your View Instance name.

Then restart the ambari server.

.

avatar
Master Mentor

@Praveen Atmakuri

If this resolved your query/issue then please mark this HCC thread as answered by clicking on "Accept" link on the correct answer, That way it will help other HCC users to quickly find the answers.

avatar

Awesome!!! Its working...thanks @Jay Kumar SenSharma