Support Questions

Find answers, ask questions, and share your expertise

How client can interact with Hive?

Client can interact with Hive?How

3 REPLIES 3

Expert Contributor

Assuming you want to connect to HS2, apart from beeline, you can connect using JDBC/ODBC as explained in wiki.

Super Collaborator

The Client can interact with the Hive in the below three ways:-


ü Hive Thrift Client: The Hive server is exposed as thrift service. Hence it is possible to interact with HIVE with any programming language that supports thrift.

ü JDBC Driver: Hive uses pure Type 4 JDBC driver to connect to the server which is defined in org.apache.hadoop.HIVE.JDBC.HiveDriver class. . Pure Java applications may use this driver in order to connect to application using separate host and port.

The BeeLine CLI uses JDBC Driver to connect to the HIVE Server.

ü ODBC Driver: An ODBC Driver allows application that support ODBC to connect to the HIVE server. By default Apache does not ships the ODBC Driver but it is freely available by many vendors.