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)