arrayDistinctString
This section contains reference documentation for the arrayDistinctString function.
Last updated
Was this helpful?
This section contains reference documentation for the arrayDistinctString function.
Last updated
Was this helpful?
Was this helpful?
Returns unique values in an array of strings.
arrayDistinctString('colName')
These examples are based on the Hybrid Quick Start.
select DivTailNums,
arrayDistinctString(DivTailNums) AS unique
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5
N7713A,N7713A
N7713A
N344AA,N344AA
N344AA
N344AA,N344AA
N344AA
N7713A,N7713A
N7713A