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

Highlighted
Four Stars

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.

 

PS: Blog coming soon on this!

 

Thanks!

Dan

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read