App generating Databricks Direct Query SQL with unquoted selection value
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.