How to raise a jira? SQL produced for Athena needs a tweak
Hi,
The SQL produced for Athena uses the wrong SQL syntax - it needs to use coalesce not ifnull
SELECT MIN(CHAR_LENGTH("last outcome category")) FROM "datalake"."fact_crimes" WHERE ("last outcome category" IS NOT NULL ) AND (TRIM(IFNULL("last outcome category",'NULL TALEND')) <> '' )
I tried to raise a jira, but I don't have an account and can't see where to register for one?
Other than that, the SQL in the DQ tool all works so this would be a pretty minor tweak to be able to add some significant support! Once you have Athena you (by definition) also have presto too.
