This section contains reference documentation for the ARRAYLENGTH function.
Was this helpful?
Returns the length of a multi-value column
ARRAYLENGTH('colName')
These examples are based on the .
select ARRAYLENGTH(RandomAirports) AS length, count(*) from airlineStats GROUP BY length ORDER BY count(*) DESC LIMIT 5
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.
count(*)