Reference

Authentication Default

Description

No description available [API reference]

Instructions

Apache Kyuubi JDBC (shaded HiveServer2 client) from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. This tile is distinct from Apache Hive and Apache Spark: Kyuubi speaks jdbc:kyuubi:// on port 10009 by default and uses KyuubiHiveDriver.

  1. Note the Kyuubi server host and binary port (default 10009) and the default schema name.
  2. Create a Kyuubi / LDAP user if the server requires authentication. Lab clusters sometimes allow empty user and password.
  3. The wizard downloads kyuubi-hive-jdbc-shaded 1.11.1. Do not mix it with a standalone Hive JAR on the same DSN.
  4. After Finish, replace the host (e.g. MyHostName) and schema on the DSN Main UI.
  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. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Apache Kyuubi\kyuubi-hive-jdbc-shaded-1.11.1.jar
Name: HostName

Label: Host

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

Label: TCP port

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

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.kyuubi.jdbc.KyuubiHiveDriver). 		org.apache.kyuubi.jdbc.KyuubiHiveDriver
Name: Database

Label: Database name

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

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.