HiveServer2 is the second generation of the Hive server, the first being HiveServer1 which has been deprecated and will be removed in future versions of Hive, so let’s start using HiveServer2.
In this Hive article, I will explain what is
HiveServer2, how to start, accessing Web UI, benefits using HiveServer2, and finally using the Beeline Command Interface.
Prerequisites: Have Hive installed and setup to run on Hadoop cluster.
HiveServer2 a.k.a HS2 is a second-generation Hive server that enables
- Remote clients to execute queries against the Hive server.
- Multi-client concurrency and authentication
- Better supports for API client like JDBC and ODBC
You May also Like Reading
- How to Connect to Hive Using Beeline
- How to Set Variables in Hive Scripts Examples
- How to connect to Hive from Java & Scala Examples
Before you proceed to start HiveServer2, make sure you have created the Hive Metastore and data warehouse location and able to run
Hive distribution comes with
hiveserver2 which is located at
$HIVE_HOME/bin/ directory, run this command without any arguments to start the HiveServer2.
[email protected]:~/hive$ $HIVE_HOME/bin/hiveserver2
In Order to run it as a service run the same command as
nohup $HIVE_HOME/bin/hiveserver2 &. This creates a
nohup.out file that contains the log.
You can also start Hive server HS2 (HiveServer2) using
hive --service command.
[email protected]:~/hive$ $HIVE_HOME/bin/hive --service hiveserver2 (or) # Start in nohup mode [email protected]:~/hive$ nohup $HIVE_HOME/bin/hive --service hiveserver2 &
By default HiveServer2 runs on port 10000, If you wanted to change the port, you can do it by changing the value for
hive.server2.thrift.port property on
Check if the HiveServer2 service is running and listening on port 10000 using
[email protected]:~/hive$ netstat -anp | grep 10000 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp6 0 0 :::10000 :::* LISTEN 17820/java
Since Hive is written in Java, you can also use
jps command to check HiveServer2 is running.
[email protected]:~/hive$ jps 18025 Jps 17820 RunJar
HiveServer2 Web UI
HiveServer2 also starts a Jetty Http server on port 1002 which provides you with Web UI. This Web User Interface (UI) for HiveServer2 provides configuration, logging, metrics, and active session information. The Web UI is available at port 10002 (127.0.0.1:10002) by default.
Using Beeline CLI
HiveServer2 supports a command shell Beeline CLI that works with HiveServer2. It’s a JDBC client that is based on the SQLLine CLI.
beeline is located at
$HIVE_HOME/bin directory. For more information on Beeline check out Starting Beeline in Standalone Embedded and Remote modes.
[email protected]:~/hive$ bin/beeline -u jdbc:hive2://127.0.0.1:10000 scott tiger Beeline version 2.3.7 by Apache Hive beeline>
Hive by default provides user scott and password tiger.
If you get a connection error User: is not allowed to impersonate, as shown below. set property
$HIVE_HOME/conf/hive-site.xml file. and, restart the HiveServer2 and try to run the beeline command again.
Now, you should see beeline CLI prompt.
Hope you like this article.
Happy Learning !