Support Questions
Find answers, ask questions, and share your expertise

Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

Hi,

I installed plain apache hadoop-2.7.2, hive-2.1.0, hbase-1.2.3, sqoop-1.4.6 on RHEL 6.6.

i loaded ORACLE table to hive using sqoop, created external table in hive.

$ hive --service hwi succeeded. i downloaded & placed hive-hwi-0.12.0.war in $HIVE_HOME/lib.

but, http://hostname:9999/hwi is not working for hive, http://hostname:60010/ is not working for hbase.

And i am able to access http://hostname:50070/, http://hostname:8088/, http://hostname:8042/ kindly suggest me.

thanks,

Venkat

6 REPLIES 6

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

Super Collaborator

Log in to the host and use netstat command to list listening ports. For HBase it would be 16010 (second port is rpc) :

[root@n1 ~]# /usr/jdk64/jdk1.8.0_77/bin/jps |grep HMaster
3236 HMaster
[root@n1 ~]# netstat -anp|grep 3236|grep LISTEN
tcp        0      0 ::ffff:10.0.3.90:16000      :::*                        LISTEN      3236/java
tcp        0      0 :::16010                    :::*                        LISTEN      3236/java
[root@n1 ~]#

You may do the same for beeline server as well.

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

[hadoopuser@imisbdpoc1 ~]$ jps
2848 NameNode
3430 ResourceManager
4167 HQuorumPeer
3207 SecondaryNameNode
2988 DataNode
5453 HRegionServer
4973 HMaster
5679 HRegionServer
21619 Jps
3576 NodeManager
4863 HMaster
4415 HRegionServer
5087 HMaster
[hadoopuser@imisbdpoc1 ~]$
[hadoopuser@imisbdpoc1 ~]$ netstat -anp|grep 4973 |grep LISTEN
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 10.19.228.40:16003          0.0.0.0:*                   LISTEN      4973/java
tcp        0      0 0.0.0.0:16013               0.0.0.0:*                   LISTEN      4973/java
[hadoopuser@imisbdpoc1 ~]$
[hadoopuser@imisbdpoc1 ~]$ netstat -anp|grep 4863 |grep LISTEN
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 10.19.228.40:16002          0.0.0.0:*                   LISTEN      4863/java
tcp        0      0 0.0.0.0:16012               0.0.0.0:*                   LISTEN      4863/java
[hadoopuser@imisbdpoc1 ~]$
[hadoopuser@imisbdpoc1 ~]$ netstat -anp|grep 5087 |grep LISTEN
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 10.19.228.40:16005          0.0.0.0:*                   LISTEN      5087/java
tcp        0      0 0.0.0.0:16015               0.0.0.0:*                   LISTEN      5087/java
[hadoopuser@imisbdpoc1 ~]$

i tried below URLs & browser is simply blank for all these

http://imisbdpoc1:16002/ , http://imisbdpoc1:16003/ , http://imisbdpoc1:16005/

i tried below URLs & all three displayed java.lang.NullPointerException:

http://imisbdpoc1:16012/master-status , http://imisbdpoc1:16013/master-status , http://imisbdpoc1:16015/master-status

HTTP ERROR 500

Problem accessing /master-status. Reason: 
    INTERNAL_SERVER_ERROR
Caused by:
java.lang.NullPointerException
	at org.apache.hadoop.hbase.tmpl.master.BackupMasterStatusTmplImpl.renderNoFlush(BackupMasterStatusTmplImpl.java:59)
	at org.apache.hadoop.hbase.tmpl.master.BackupMasterStatusTmpl.renderNoFlush(BackupMasterStatusTmpl.java:119)
	at org.apache.hadoop.hbase.tmpl.master.MasterStatusTmplImpl.renderNoFlush(MasterStatusTmplImpl.java:339)
	at org.apache.hadoop.hbase.tmpl.master.MasterStatusTmpl.renderNoFlush(MasterStatusTmpl.java:387)
	at org.apache.hadoop.hbase.tmpl.master.MasterStatusTmpl.render(MasterStatusTmpl.java:378)
	at org.apache.hadoop.hbase.master.MasterStatusServlet.doGet(MasterStatusServlet.java:81)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
	at org.apache.hadoop.hbase.http.lib.StaticUserWebFilter$StaticUserFilter.doFilter(StaticUserWebFilter.java:113)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
	at org.apache.hadoop.hbase.http.ClickjackingPreventionFilter.doFilter(ClickjackingPreventionFilter.java:48)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
	at org.apache.hadoop.hbase.http.HttpServer$QuotingInputFilter.doFilter(HttpServer.java:1354)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
	at org.apache.hadoop.hbase.http.NoCacheFilter.doFilter(NoCacheFilter.java:49)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
	at org.apache.hadoop.hbase.http.NoCacheFilter.doFilter(NoCacheFilter.java:49)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
	at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
	at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

please suggest me

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

Super Collaborator

I would suggest to kill all HRegionServer and HMaster processes and be sure that you do not run a single instance of HBase. And after that check the logs that it's started correctly.

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

Also, my High Priorty task is to ensure Hive is accessible on web-browser, i have to provide hive jdbc driver to access hive data from IBM Cognos.

so, any suggestion on this will be very much appreciated

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

[hadoopuser@imisbdpoc1 ~]$
[hadoopuser@imisbdpoc1 ~]$ export ANT_LIB=/home/hadoopuser/apache-ant-1.9.7/lib
[hadoopuser@imisbdpoc1 ~]$ echo $ANT_LIB
/home/hadoopuser/apache-ant-1.9.7/lib
[hadoopuser@imisbdpoc1 ~]$ cd $HIVE_HOME
[hadoopuser@imisbdpoc1 apache-hive-2.1.0-bin]$ bin/hive --service hwi
[hadoopuser@imisbdpoc1 apache-hive-2.1.0-bin]$

i think it should throw me some message like " hwi.HWIServer: HWI is starting up" , but actually not.

Re: Unable to access Hive/Hbase web interfaces Although i am able to perform actions on their Command Line Interface

Super Collaborator

You may check how the execution of hive script was going. It will show on which step/check the execution stopped. It it fails with executing hadoop you may copy the execution line and try to run in the same way.

sh -x bin/hive --service hwi