Support Questions

Find answers, ask questions, and share your expertise

Cannot connect to hive

avatar
Explorer

I'm running HDP 2.5 Sandbox on Docker on a Mac. I do get the following error when trying to use the Hive View in Ambari. I tried rebooting but it did not help. Any ideas?

        Service 'hiveserver' check failed:
java.lang.Exception: Cannot connect to hive

java.lang.Exception: Cannot connect to hive
	at org.apache.ambari.view.hive2.actor.message.job.ExecutionFailed.<init>(ExecutionFailed.java:28)
	at org.apache.ambari.view.hive2.actor.JdbcConnector.notifyConnectFailure(JdbcConnector.java:385)
	at org.apache.ambari.view.hive2.actor.JdbcConnector.connect(JdbcConnector.java:422)
	at org.apache.ambari.view.hive2.actor.JdbcConnector.handleNonLifecycleMessage(JdbcConnector.java:179)
	at org.apache.ambari.view.hive2.actor.JdbcConnector.handleMessage(JdbcConnector.java:171)
	at org.apache.ambari.view.hive2.actor.HiveActor.onReceive(HiveActor.java:38)
	at akka.actor.UntypedActor$anonfun$receive$1.applyOrElse(UntypedActor.scala:167)
	at akka.actor.Actor$class.aroundReceive(Actor.scala:467)
	at akka.actor.UntypedActor.aroundReceive(UntypedActor.scala:97)
	at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)
	at akka.actor.ActorCell.invoke(ActorCell.scala:487)
	at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)
	at akka.dispatch.Mailbox.run(Mailbox.scala:220)
	at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397)
	at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
	at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
	at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
	at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
1 ACCEPTED SOLUTION

avatar
New Contributor

@Joav Bally the Hive server stops because of high Hiveserver 2 Heap Size.

  1. Go to Hive Services
  2. Click Config and scroll to the bottom
  3. In Storage section. Change the HiveServer2 heap Size.(Click the refresh icon that displays on hovering to set the recommended)
  4. Save the Current HDP and restart the hive service

This will solve the issue.

View solution in original post

10 REPLIES 10

avatar
Explorer

Thanks a ton man! This did the trick!