duneanalytics/harmonizer

Array and struct access operator is null safe in Spark, but not in Trino

vegarsti opened this issue · 0 comments

So e.g. account_keys[2].foo will cause the execution to fail in Trino, while in Spark this will just be null. Ideally we rewrite this to be case when cardinality(account_keys) >= 2 then account_keys[2].foo end which will do the same.