What are the options to connect an application to a Hive server?

We can use following options to connect an application a Hive server:

  • JDBC Driver: We can use JDBC Driver with embedded as well as remote access to connect to
    HiveServer. This is for Java based connectivity.
  • Python Client: For Python language application there is Python client that can connect to Hive server.
  • Ruby Client: With Ruby client driver also we can connect to Hive server.
  • Thrift Client: We can use Beeline command line shell to connect to Hive server over Thrift. For production mode, this is one of the very good options. It is a secure option for production use. Also we do not need to grant HDFS access to users for using Thrift client.

Leave a Reply

Your email address will not be published. Required fields are marked *