Apache Pinot Docs
Search…
latest
COUNTMV
This section contains reference documentation for the COUNTMV function.
Get the count of rows in a group

Signature

COUNTMV(colName)

Usage Examples

These examples are based on the Hybrid Quick Start.
The following query returns the documents that have a DivTailNums with more than one value:
1
select DivTailNums
2
from airlineStats
3
where arraylength(DivTailNums) > 1
Copied!
DivTailNums
N7713A,N7713A
N344AA,N344AA
N344AA,N344AA
N7713A,N7713A
You can count the number of items in these rows by running the following query:
1
select COUNTMV(DivTailNums) AS value
2
from airlineStats
3
where arraylength(DivTailNums) > 1
Copied!
value
8
Last modified 18d ago
Copy link