How to raise a jira? SQL produced for Athena needs a tweak

Anonymous — Sat, 16 Nov 2024 02:56:02 GMT

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.

PS: Blog coming soon on this!

Thanks!

Dan

Re: How to raise a jira? SQL produced for Athena needs a tweak

Anonymous — Tue, 09 Mar 2021 03:25:06 GMT

Hello,

Feel free to create a jira issue on talend bug tracker.

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

topic How to raise a jira? SQL produced for Athena needs a tweak in Data Quality

How to raise a jira? SQL produced for Athena needs a tweak

Re: How to raise a jira? SQL produced for Athena needs a tweak