Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. 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.

]]> Kyuubi with SSL and user/password (LDAP-style). URL session vars use semicolons, same family as HiveServer2.

1. Confirm TLS is enabled on the Kyuubi server and that you have an LDAP or custom user.
2. This Auth sets ssl=true. Paste user and password. If the driver asks for a trust store password, set JVM truststore properties on the Bridge rather than putting a secret in XML.
3. Keep this tile separate from Hive (port 10000, jdbc:hive2://) and Spark Thrift Server.
4. After Finish, replace host, port, and schema.
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.

]]> Lists tables available to this connection. Use this in Power BI or a SQL Server Linked Server to confirm the catalog before building reports.

]]> Returns rows from default.MyTable. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from default.MyTable. Swap the column and literal for your schema.

]]> Joins two tables on a key. Use in Azure Data Factory or SSIS when you need a combined extract.

]]> Counts rows per group. Typical Power BI import pattern before a visual.

]]> Keeps groups whose count is at least 10.

]]> = 10]]> Returns the first 100 rows ordered by a column. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in default.MyTable.

]]> Maps a column to labels with CASE.

]]> Returns a column list instead of star. Prefer this in Linked Server views.

]]> Lists databases/schemas visible to this Kyuubi session.

]]>