How to get a length of the array in Denodo?

Question

I have a column in the Denodo view with the type ARRAY. How can I get the length of this array? Standard sql ARRAY_LENGTH function is not working.

Answer 1

You can use

COUNT((<ARRAY_FIELD>).value)

Notice that you can not use COUNT() over the aggregate function LIST() directly.