ARRAYLENGTH

This section contains reference documentation for the ARRAYLENGTH function.

Returns the length of a multi-value column

Signature

ARRAYLENGTH('colName')

Usage Examples

These examples are based on the Hybrid Quick Start.

select ARRAYLENGTH(RandomAirports) AS length, count(*) 
from airlineStats 
GROUP BY length
ORDER BY count(*) DESC
LIMIT 5
lengthcount(*)

1

5382

37

267

33

223

17

166

22

160

The count(*) values will increase each time we execute the query as data is constantly being ingested by the Hybrid Quick Start.