Generic Hive Database Account
In this article
Overview
You can use this account type to connect Hive Snaps with data sources that use Generic Hive Database account.
Prerequisites
A Hive account.
Limitations
The Hive Snap Pack does not validate with Apache Hive JDBC v1.2.1 jars or earlier because of a defect in Hive. HDP 2.6.3 and HDP 2.6.1 run on Apache Hive JDBC v1.2.1 jars.
To validate Snaps that must work with HDP 2.6.3 and HDP 2.6.1, use JDBC v2.0.0 jars.
Known Issues
"Method not supported" error while validating Apache Hive JDBC v1.2.1 or earlier
Account Settings
Asterisk ( * ): Indicates a mandatory field.
Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the fieldset.
Remove icon ( ): Indicates that you can remove fields from the fieldset.
Field Name | Field Type | Description | |
---|---|---|---|
Label*
Default Value: N/A | String | Specify a unique label for the account. | |
Account properties* | |||
Username
Default Value: N/A | String/Expressions | Specify the username that is allowed to connect to the database. Username will be used as the default username when retrieving connections. The username must be valid in order to set up the data source. | |
Password
Default Value: N/A | String/Expressions | Specify the password used to connect to the data source. Password will be used as the default when retrieving connections. The password must be valid in order to set up the data source. | |
JDBC URL
Default Value: N/A | String/Expression | Specify the URL of the JDBC database. | |
JDBC JARs | Use this fieldset to specify the JDBC JAR files to be loaded. A different driver binary for a driver must have a different name, the same name can not be reused for a different driver. If this property is left blank, a default J |