How to get the URL for Hive Web Interface
07:23 09 Sep 2014

Sorry, it may be a basic question. I tried to google it but couldn't find exact solution

I am trying to find out URL for my Hive web interface. Through this I can check the tables present in it. With the help of the web interface URL I can also access the beeline command line interface

I am accessing my company's server for hadoop interface through putty. I access hdfs web interface using

http://ibmlnx01:50070/

However when I try the below URLs, it doesn't show any web userinterface

 http://ibmlnx01:9999/
 http://ibmlnx01:10000/ 
 http://0.0.0.0:9999/ 
 http://0.0.0.0:10000

Below is my hive-default.xml.template I couldn't copy the whole file. But copied the main code I hope its sufficient


  hive.hwi.war.file
  lib/hive-hwi-0.12.0.war
  This sets the path to the HWI war file, relative to ${HIVE_HOME}. 



  hive.hwi.listen.host
  0.0.0.0
  This is the host address the Hive Web Interface will listen on



  hive.hwi.listen.port
  9999
  This is the port the Hive Web Interface will listen on

Below is the code for hive-site.xml


     
         javax.jdo.option.ConnectionURL
         jdbc:mysql://volgalnx03.ad.infosys.com/metastore_db?createDatabaseIfNotExist=true
         metadata is stored in a MySQL server
     
     
         javax.jdo.option.ConnectionDriverName
             com.mysql.jdbc.Driver
             MySQL JDBC driver class
     
     
             javax.jdo.option.ConnectionUserName
             hiveuser
             user name for connecting to mysql server 
     
     
            javax.jdo.option.ConnectionPassword
            1234
            password for connecting to mysql server 
     

I connect the putty terminal through 10.66.82.52 IP address. If this is of any help

hadoop hive hiveql