Connecting Hive with BEELINE

This post will explain how to connect to Beeline as well as how to connect Hive from Beeline.

Simply type “beeline” into the terminal window to launch the “Beeline” shell. When you connect to the beeline, it will inform you of the beeline and Cloudera versions (if you are using Cloudera VM).

Once connected to Beeline Grunt, use the following command to connect to Hive.

!connect jdbc:hive2://quickstart.cloudera:10000/default

quickstart.cloudera is the host-name, if you are using localhost then use the below command.

!connect jdbc:hive2://localhost:10000/default
Or replace it with your host-name.

The default port for connecting is 10000, and the database to use is “default“. Change the settings to suit your needs.

Once it is connected, you can start querying the database as shown below.


Hope you find this article helpful.

Let me know if you are facing any issues.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s