1 of 1

ARRAYLENGTH

This section contains reference documentation for the ARRAYLENGTH function.

Returns the length of a multi-value column

Signature

ARRAYLENGTH('colName')

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

length

count(*)

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

This section contains reference documentation for the ARRAYLENGTH function.

Returns the length of a multi-value column

ARRAYLENGTH('colName')

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

length

count(*)

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