Reference

Authentication HiveServer2 (default)

Description

No description available [API reference]

Instructions

Connect to HiveServer2 with the standalone JDBC JAR. JDBC Bridge then exposes Hive SQL to Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. Note the HiveServer2 host and binary port (default 10000) and the default database name.
  2. Create a Hive / LDAP user if the cluster requires authentication. Lab clusters sometimes allow empty user and password.
  3. Replace hive-instance-host-name and the database in the JDBC URL after Finish (the wizard hides the URL; edit it on the DSN Main UI).
  4. Prefer the standalone JAR the wizard downloads. Do not mix it with a partial Hadoop classpath.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Use the standalone JAR only (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Apache Hive\hive-jdbc-4.2.0-standalone.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 10000). 		YES 10000
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the standalone JAR (e.g. org.apache.hive.jdbc.HiveDriver). 		org.apache.hive.jdbc.HiveDriver
Name: Database

Label: Database name

Database, schema, or catalog name (e.g. MyDatabase). 		MyDatabase
Name: UserName

Label: User name

HiveServer2 user. Leave empty if the cluster allows anonymous JDBC.
Name: Password

Label: Password

HiveServer2 password or LDAP secret. Leave empty if none.