4.1.1.9 Creating a Connection to Hive

To create a connection to Hive:

1. On the Catalog page, click Create New Item.
2. Hover the mouse over Connection and select Hive from the submenu.
3. Click Connection, and select from the drop-down list.
4. On the Type Properties screen, enter the following details:
   • Name: Enter a unique name for the connection. This is a mandatory field.
   • Display Name: Enter a display name for the connection. If left blank, the Name field value is copied.
   • Description
   • Tags
   • Connection Type: The selected connection is displayed.
5. Click Next.
6. On the Connection Details screen, enter the following details:

   • Core Site XML: Upload the core-site.xml file to connect to HDFS, where the files to create external hive table are loaded. This is a mandatory field..

   • Hdfs Site XML: Upload the hdfs-site.xml file to connect to HDFS, where the files to create external hive table are loaded. This is an optional field.

   • Use Kerberos: In case of a kerberized cluster, you can provide the Kerberos principal and keytab by enabling this option.
   • Kerberos KDC: Provide the host having the Key Distribution Center(KDC).
   • Kerberos Realm: Provide the kerberos realm.
   • Kerberos Principal: Set the Kerberos principal for the hive service.
   • Kerberos KeyTab: Upload the kerberos keytab file for the hive service.
   • Hive JDBC URL: You can connect to hive database using following jdbc url : jdbc:hive2://host:port/<DB_NAME>. The default port is 10000 and default database is "default".

   • Hive JDBC Username: Enter the username to connect to hive database. If you are using the default database, this field can be left blank.

   • Hive JDBC Password: Password used to connect to hive database. If you are using the default database, this field can be left blank.

7. Click Test Connection, to ensure that you have successfully created a connection, and to download the third-party libraries required to connect to hive database to create an external table.
8. Click Save.