Connect Aginity Pro™ or Aginity Team™ to Hive with Kerberos Authentication

Kerberos must be installed and configured before you can use this authentication mechanism.

Below is an example connection screen connecting to a Kerberized Hive instance using the default Hive driver org.apache.hive.jdbc.HiveDriver v 1.2.1. Different drivers may have other requirements.

In this example, Kerberos is enabled for JDBC connections and the example values can be seen below.

  • The Kerberos Realm is AGINITY.LOCAL
  • The User is eweine@AGINTIY.LOCAL (@REALM is required)
  • The Host for the data source is evdp-lnx-hdp006.aginity.local
  • The server is listening on port 10000 for JDBC connections



Check the "Use Kerberos for authentication" box to reveal the Realm, Host FQDN, and Service Name text boxes.

In this example, Kerberos is enabled for JDBC connections and the example Kerberos values can be seen below.

  • The (Kerberos) Realm is AGINITY.LOCAL
  • The Host FQDN (the fully qualified domain name of the Kerberos Distribution Center or KDC) is ads04.aginity.local
  • The (Kerberos) Service name is Hive

If your driver needs more properties, they can be added in the Advanced Properties section.


Have more questions? Submit a request


Article is closed for comments.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.