Dremio JDBC storage plugin failed while trying setup the SQL query

1

HI guys,

I am facing the above issue when running this query( See attached Query)
This query is generated from Qlik Sense and if i take the exact same query and run in it in the Redshift cluster i get the expected results.
The suspected filed is gender(if i comment this field out then i am able to return the results)
Somehow i think the query is not being translated correctly from Qlik to Dremio

Dremio Query.zip (1.5 KB)

2

@Calvin_Klyn

The way you have zipped the file requires extra software to be installed, just download the profile and send it as is

3

@balaji.ramaswamy

Thank you i have downloaded and uploaded the profile as is, let me know if you are able to open it.

I also noticed the the below error:
(java.sql.SQLException) Amazon Invalid operation: length for type varchar cannot exceed 65535;
com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException():-1

19c67045-1ea1-49e0-8038-76af7d4b0995.zip (59.4 KB)

4

Additionally if i replace the IN Predicate with the LIKE predicate for gender and derived_race and run the same query in dremio then i am able to get the results
i.e
WHERE
gender like ‘%M%’ AND
derived_race like ‘%UNKNOWN%’

5

It seems like this issue only occurs when we are using an aggregation reflection.
If I use a raw reflection I am not getting this issue( though all fields must be displayed on the raw reflection for the query from Qlik to run successfully)

6

@Calvin_Klyn

Looks like a field width limit.

1 Like