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.