Access Hive Server with JDBC clients

Question

Hi. Can someone tell me how to access hive server using JDBC clients such as beeline? I have installed and setup Hive Server.

Answer 1

To access Hive Server using JDBC client, you have to install JDBC driver. If you are using Centos then you can install it using the below command:

$ sudo yum install hive-jdbc

And if you are using Ubuntu, then use this:

$ sudo apt-get install hive-jdbc

And after that add /usr/lib/hive/lib/*.jar and /usr/lib/hadoop/*.jar to your classpath. This should work.