Overview

You can use this account type to connect Hive Snaps with data sources that use Generic Hive Database account.

Prerequisites

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.

"Method not supported" error while validating Apache Hive JDBC v1.2.1 or earlier

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

Field Name		Field Type	Description
Label* Default Value: N/A Example: Generic Hive Database Account		String	Specify a unique label for the account.
Account properties*
Username Default Value: N/A Example: Snapuser		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 Example: Sn@pUser.3		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 Example: jdbc:hive://hostname/dbname:sasl.qop=auth-int		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