Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tgrant
Contributor
Contributor

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.

tgrant_0-1730927458385.png 

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')".

tgrant_1-1730928272036.png

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

tgrant_2-1730928609691.png

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

 

Labels (2)
0 Replies