How to get the URL for Hive Web Interface

hive gui
how to find hive host and port number
hive web ui hortonworks
beeline hive
start hive
running hive
hive port
hive versions

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

<property>
  <name>hive.hwi.war.file</name>
  <value>lib/hive-hwi-0.12.0.war</value>
  <description>This sets the path to the HWI war file, relative to ${HIVE_HOME}. </description>
</property>

<property>
  <name>hive.hwi.listen.host</name>
  <value>0.0.0.0</value>
  <description>This is the host address the Hive Web Interface will listen on</description>
</property>

<property>
  <name>hive.hwi.listen.port</name>
  <value>9999</value>
  <description>This is the port the Hive Web Interface will listen on</description>
</property>

Below is the code for hive-site.xml

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

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

just appending hwi helped me ;) http://host:9999/hwi Make sure u executed below line first. $HIVE_HOME/bin/hive --service hwi

At first I tried to get ui using url http://host:9999/ and it returned 404.

hadoop - How to get the URL for Hive Web Interface, just appending hwi helped me ;) http://host:9999/hwi. Make sure u executed below line first. $HIVE_HOME/bin/hive --service hwi. At first I tried to get ui using url  Looking for how do i get a url? Search now! eTour.com is the newest place to search, delivering top results from across the web.

Double check the installation steps in www.tutorialspoint.com/hive/hive_quick_guide.htm. Then, make sure you have JDK on your server. Finally, you should run the execution command: hive --service hwi In addition, I inserted a link about Gareth's personal experience in the same situation.

https://dzone.com/articles/hadoop-hive-web-interface

Hive Web Interface (component removed as of Hive 2.2.0), What is the URL syntax for accessing the Web interface of Hadoop? 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

Hue (Hadoop User Experience) is the web interface for analyzing data with Hadoop (and not just with Hive).

Hue's standard port is 8888. However, that value may be different in your installation.

Look for the http_port entry in /etc/hue/conf/hue.ini if 8888 doesn't work for you.

HDFS Web UI, browser and to point to port number 50070 on localhost host name in pseudo-distributed mode. In Fully distributed mode, replace the 'localhost' with actual host name of machine on cluster. In order to access the Hive Web Interface, go to <Hive Server Address>:9999/hwi on your web browser. Tips and Tricks Result File. The result file is local to the web server. A query that produces massive output should set the result file to /dev/null. Debug Mode

What are the good GUI tools to run Hive queries and visualize the , Which tool can be used for web graphical user interface of hive? The Hive Web Interface manages the session on the web server, and not from inside the CLI window. This allows a user to start multiple queries and return to the web interface later to check the status. ⦁ No Local Installation. Any user with a web browser can work with Hive. This has the usual web interface benefits.

hiveserver details, Learn, Running Hive Queries with Hive Web Interface. Once you have your setup ready let us get started and see how to use the HWI. The Hive Web Interface is an alternative to using the Hive command line interface. Using the web interface is a great way to get started with Hive. The Hive Web Interface, abbreviated as HWI, is a simple graphical user interface (GUI). Configuration. Hive Web Interface made its first appearance in the 0.2 branch. If you have Hive release 0.2 or later, or the SVN trunk, then you already have it.

How to Run Hive Queries using Hive Web Interface |, 3.2 - URL. headnode:port. where: port is the conf hive.server2.webui.port (default to 10002). Advertising. Let's get started and see how to use HWI. The process is quite simple. First a couple of things on configuration. Following are the properties which you might have to modify as per your requirements : hive.hwi.listen.host : The host address the Hive Web Interface will listen on. hive.hwi.listen.port : The port the Hive Web Interface will listen on.

Comments
  • Please post more than a link. Explain why it's right.
  • Sorry. I am new to all this. Can you tell me where exactly to find /etc folder. Thanks
  • /etc is the Linux directory where configuration files are stored. See en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard