Ambari TimeoutException

[#1]

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

[#2 · Accepted solution]

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

.

[#3]

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

[#4]

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