Skip to main content Skip to complementary content


Returns the number of elements in the current array.


Any expression can be used as argument, it will not be taken into account but it is required. Missing values are not counted, and in Talend Data Mapper null values are not counted either.


In the query below, the count function returns the number of elements in o.items, regardless of the argument specified.
FROM order AS o UNNEST o.items AS i
  count = count(o)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!