Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. Spark Thrift Server from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Start Spark Thrift Server or note the existing host and HS2 port (default 10000).
2. Download the standalone Hive JDBC JAR (the wizard does this). Do not mix a partial Hadoop classpath.
3. Create a user if the cluster uses auth; otherwise leave user/password empty.
4. After Finish, replace the host (e.g. MyHostName) 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.

]]> Spark Thrift Server with SSL from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Same as Default Auth, plus TLS. Fill LDAP/Hive user and password.
2. Do not use a personal employee login for unattended Power BI or Linked Server refresh.
3. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
4. 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 employees. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from employees.

]]> 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.

]]> Returns the first 100 rows. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in employees.

]]> Maps a column to labels with CASE.

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

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

]]> = 1]]> Returns selected columns for employees in the Sales department. Use in Power BI or Excel to preview a filtered extract.

]]> Ranks employees by salary within each department (highest first).

]]> Extracts the city field from a JSON string in user_data.

]]> Turns array elements into separate rows and filters for users interested in hiking.

]]> Parses the browser name from the user_agent string. Useful for SSRS or Crystal Reports web-log extracts.

]]>