question Re: Ambari HIVE view in Support Questions

Ambari HIVE view

avijeetd — Wed, 10 May 2017 18:34:05 GMT

Hi All,

While enabling ambari hive view (unsecured hadoop cluster) - as hive user - getting error

Service 'hiveserver' check failed: Cannot connect to hive

I have disabled 'Run as end user instead of Hive user' on HIVE Config and proxy user hive.users and hosts are set to *

pls suggest if there is some way to fix it.

    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)

Thanks,

Avijeet

Re: Ambari HIVE view

SQLShaw — Wed, 10 May 2017 20:22:11 GMT

Hi @Avijeet Dash

Confirm HiveServer is running. Can also try restarting the service via Ambari

Re: Ambari HIVE view

avijeetd — Wed, 10 May 2017 20:45:37 GMT

Hi @Scott Shaw, hive server 2 is running file, i can reach by beeline, hive etc. This is happening in 2 hdp2.5 clusters, same issue.

Re: Ambari HIVE view

SQLShaw — Wed, 10 May 2017 21:11:54 GMT

@Avijeet Dash Double-check the jdbc connection for HiveServer2 JDBC URL in the view definition. I've also had luck by creating a new Hive view instance.

Re: Ambari HIVE view

avijeetd — Wed, 10 May 2017 21:34:45 GMT

@ScottShaw no luck, is using hive user OK, or setting up some other user is better?

Re: Ambari HIVE view

SQLShaw — Wed, 10 May 2017 21:37:57 GMT

@Avijeet Dash most likely it is using the account you log into Ambari with. You can try using a different account but to me the errors don't indicate a permissions issue.

Re: Ambari HIVE view

avijeetd — Wed, 10 May 2017 21:43:10 GMT

@Scott Shaw yeah it simply says cannot connect - I tried localhost, 127.0.01, hostname...same error.

Re: Ambari HIVE view

vsundaram — Wed, 10 May 2017 22:45:45 GMT

@Avijeet Dash Could you please attach a screenshot of your hive view configuration page?

Re: Ambari HIVE view

avijeetd — Sun, 18 Aug 2019 01:22:53 GMT

@Vaisakh Sundaram pls find attached, I had to hide the host names, but hive2 url is correct, I checked with beeline.

Re: Ambari HIVE view

frank93 — Thu, 11 May 2017 20:30:11 GMT

@Avijeet Dash

As I remember I had problems with Hive View 1.5. Could you try using Hive View version 1.0?

Re: Ambari HIVE view

avijeetd — Fri, 12 May 2017 12:45:26 GMT

@Edgar Daeds Thanks, This worked.