App generating Databricks Direct Query SQL with unquoted selection value

tgrant — Thu, 07 Nov 2024 18:11:09 GMT

I have configured a Qlik Cloud application to query a Databricks cloud database using "Direct Query" and a custom SQL statement. I've simplified my application down to a single SQL statement and a single table. When the app loads, it uses my SQL statement to fetch the first batch of data, and it is successfully displayed in the table. When I make a selection on the table, the application generates the SQL to filter the table using the selection. Unfortunately, the SQL is not being generated properly and I get an error dialog.

Direct Query mode error: SQL Adaptor error: Connector error: ERROR [42703] [Qlik][Hardy] (80) 
Syntax or semantic analysis error thrown in server while executing query. 
Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query:
 [UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.catalyst.ExtendedAnalysisException:
 [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `DDG70`.

In Databricks, I can see the SQL that was generated and submitted. The SQL includes a WHERE clause with "IN (DDG70)" that should be "IN ('DDG70')".

I've simplified the App to just the custom SQL and table to show the issue.

Is there a work around or fix for this? For the complicated case, I need to use custom SQL.

topic App generating Databricks Direct Query SQL with unquoted selection value in App Development

App generating Databricks Direct Query SQL with unquoted selection value