Authentication Hive 4 (SSL / LDAP)
Description
No description available [API reference]
Instructions
Hive 4 HiveServer2 with SSL and user/password (LDAP or custom). Power BI's old Hive LLAP ODBC path is being deprecated; this JDBC standalone JAR is the durable Excel / SSIS / Linked Server path.
- Confirm Hive 4.x HiveServer2 host, port
10000(or your HS2 port), and that SSL is enabled. - Create or reuse an LDAP / Hive user. Paste user and password here. Do not use a personal employee login for unattended refresh.
- The wizard downloads
hive-jdbc-4.2.0-standalone.jar. Keep SSL=true unless your lab is plaintext (then use Default Auth). - After Finish, edit the JDBC URL on the DSN Main UI to replace the host (e.g. MyHostName) and database (e.g. MyDatabase).
- Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
- Done. You can query from C#, Python, PowerShell, and ODBC apps.
Parameters
| Parameter | Required | Default value | Options | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Name:
Label: JDBC driver file(s) Hive 4 standalone JAR. Filled by the wizard after download (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). |
YES |
C:\ZappySys\Jdbc\Apache Hive\hive-jdbc-4.2.0-standalone.jar
|
|||||||||
|
Name:
Label: Host JDBC host name or IP (e.g. MyHostName). |
YES |
MyHostName
|
|||||||||
|
Name:
Label: TCP port JDBC port (e.g. 10000). |
YES |
10000
|
|||||||||
|
Name:
Label: User name LDAP or Hive user for HiveServer2. |
YES | ||||||||||
|
Name:
Label: Password LDAP or Hive password. |
YES | ||||||||||
|
Name:
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:
Label: Database name Database, schema, or catalog name (e.g. MyDatabase). |
MyDatabase
|
||||||||||
|
Name:
Label: SSL SSL flag for this JDBC URL (e.g. Yes from the dropdown). |
true
|
|