DISTINCTCOUNTMV

This section contains reference documentation for the DISTINCTCOUNTMV function.

Returns the count of distinct row values in a group

Signature

DISTINCTCOUNTMV(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:

select DivTailNums
from airlineStats 
where arraylength(DivTailNums) > 1

DivTailNums
N7713A,N7713A
N344AA,N344AA
N344AA,N344AA
N7713A,N7713A

You can count the distinct number of items in these rows by running the following query:

select DISTINCTCOUNTMV(DivTailNums) AS value
from airlineStats 
where arraylength(DivTailNums) > 1

value
2