Connect to your Apache Hive Data
Simply connect to your Apache Hive data warehouse to create meaningful data insights.
Apache Hive Connector Requirements
Your Apache Hive administrator typically creates your account and provides you with the following credentials required to connect to Apache Hive:
- Username
- Password
Apache Hive connector properties
Here are the properties for the Apache Hive connector:
| Property | Description |
|---|---|
| Data Source Name | Enter the name of the data source |
| Kerberos Secured | Enable Kerberos authentication for the data source connection |
| Keytab Path | Enable Kerberos Secured to configure this property. Enter the path to the Kerberos keytab on the database server. |
| Username | Enter the Apache Hive account username |
| Password | Enter the Apache Hive account user password |
| Connection Pool | Enter the connection pool. The default is 30. |
| Connection String | Enter the connection string for the Apache Hive JDBC driver. The format is: jdbc:hive2://<HOST>:<PORT>/<DB>The default port is 10000. |
| Connection Properties | Optionally enter connector properties for a custom connection to Apache Hive in the format: propertyName=propertyValue, where each connector property is on a new line.The available connector properties are specified by org.apache.hive.jdbc.HiveDriver. Refer to Apache HiveServer2 JDBC for further information. |
| Use Data Agent | Optionally, enable using a data agent to securely ingest data from an external data source that is behind a firewall. |
| Data Agent | Enable Use Data Agent to configure this property. Select from the data agents created in the tenant, if any. |
There are known issues with the Apache Hive connector when you enable Kerberos authentication. Please contact support if you need to use this feature.
Additional Considerations
Data Agent Prerequisites
A data agent is a service that enables an authorized connection without using a VPN or SSH tunnel. With a data agent, you can securely extract data from one or more databases behind a firewall to an Incorta cluster.
You need to enable the Data Agent option at the cluster level so that the Use Data Agent property will be available. You also need to have data agents defined in your tenant to select from.
Contact Incorta Support to configure your Incorta cluster to support the use of data agents. To learn more, review
Tools → Data Agent and Tools → Data Manager.Learn more about how to configure the Apache Hive connector.