description |
---|
This section contains reference documentation for the arrayDistinctString function. |
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
DivTailNums | unique |
---|---|
N7713A,N7713A | N7713A |
N344AA,N344AA | N344AA |
N344AA,N344AA | N344AA |
N7713A,N7713A | N7713A |