Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Ambari HIVE view

Solved Go to solution

Ambari HIVE view

Expert Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Ambari HIVE view

New Contributor

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

10 REPLIES 10

Re: Ambari HIVE view

Hi @Avijeet Dash

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

Re: Ambari HIVE view

Expert Contributor

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

@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

Expert Contributor

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

Re: Ambari HIVE view

@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

Expert Contributor

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

Highlighted

Re: Ambari HIVE view

New Contributor

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

Re: Ambari HIVE view

Expert Contributor

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

15307-hive-view1.png

15308-hive-view2.png

15309-hive-view3.png

15310-hive-view4.png

Re: Ambari HIVE view

Expert Contributor

@Avijeet Dash

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