ARRAYLENGTH
This section contains reference documentation for the ARRAYLENGTH function.
Returns the length of a multi-value column
ARRAYLENGTH('colName')
select ARRAYLENGTH(RandomAirports) AS length, count(*)
from airlineStats
GROUP BY length
ORDER BY count(*) DESC
LIMIT 5
length | count(*) |
|---|---|
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.Last modified 1yr ago