arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

ARRAYLENGTH

This section contains reference documentation for the ARRAYLENGTH function.

Returns the length of a multi-value column

hashtag
Signature

ARRAYLENGTH('colName')

hashtag
Usage Examples

These examples are based on the .

length
count(*)
circle-info

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

1

5382

37

267

33

223

17

166

22

160

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