Apache Pinot Docs
Search…
latest
Configuration Reference
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.
1
select ARRAYLENGTH(RandomAirports) AS length, count(*)
2
from airlineStats
3
GROUP BY length
4
ORDER BY count(*) DESC
5
LIMIT 5
Copied!
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.
Copy link