ARRAYLENGTH

This section contains reference documentation for the ARRAYLENGTH function.

Returns the length of a multi-value column or array expression. Pinot also accepts the alias CARDINALITY.

Supported Types

ARRAYLENGTH supports arrays of INT, LONG, FLOAT, DOUBLE, BIG_DECIMAL, STRING, and BYTES.

Signature

ARRAYLENGTH('colName')

Usage Examples

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(*)
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.