question Re: Why is Hive View not loading in Archives of Support Questions (Read Only)

Why is Hive View not loading

vnv — Fri, 23 Sep 2016 22:29:27 GMT

Tried to load Hive View and I get the following error:

        Service 'hiveserver' check failed:
java.sql.SQLException: Error while processing statement: FAILED: Hive Internal Error: java.lang.ClassNotFoundException(org.apache.atlas.hive.hook.HiveHook)

java.sql.SQLException: Error while processing statement: FAILED: Hive Internal Error: java.lang.ClassNotFoundException(org.apache.atlas.hive.hook.HiveHook)
	at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(HiveStatement.java:348)
	at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:251)
	at org.apache.ambari.view.hive2.HiveJdbcConnectionDelegate.execute(HiveJdbcConnectionDelegate.java:49)
	at org.apache.ambari.view.hive2.actor.StatementExecutor.runStatement(StatementExecutor.java:87)
	at org.apache.ambari.view.hive2.actor.StatementExecutor.handleMessage(StatementExecutor.java:70)
	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)

I'm using hdp 2.5 sandbox.

Any ideas?

Re: Why is Hive View not loading

cstanca — Fri, 23 Sep 2016 23:57:41 GMT

@Vasilis Vagias

I just checked the same on my sandbox and it works fine. Dumb question maybe, are all the needed running, e.g. HiveServer2? Can you beeline and access your database successfully? An Ambari restart can occassionally help.

Re: Why is Hive View not loading

apathan — Sat, 24 Sep 2016 17:35:17 GMT

@Vasilis Vagias

HiveView is trying to read HiveHook class from the designated path because this class reference is there in hive-site.xml . Please check if the HiveHook class is available and it has proper permissions configured. I suspect this is related to the corrupt VM that you encountered earlier. With latest sandbox you should not see this issue. Do let me know if you face this with latest sandbox as well.

Re: Why is Hive View not loading

vnv — Sat, 24 Sep 2016 21:34:55 GMT

It seems that my VM caused several headaches. I launched a fresh VM and Hive View / Atlas are working great.

Re: Why is Hive View not loading

a_bolbol — Thu, 13 Oct 2016 14:41:22 GMT

I know this has been resolved for you Vasilis, but for the record, I just wanted to mention that I had the same problem, and it only turned to be a browser problem (I was using Safari). Used chrome and it worked just fine.

Re: Why is Hive View not loading

shadi — Tue, 07 Mar 2017 14:58:40 GMT

Did anyone solve this error?

I have the same error on my cluster, 10 hosts with centos 7, HDP 2.5.0.0.

When I open Hive view, I get exactly the same error. I restarted ambari server, and changed the browser, but I still get it.