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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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