arrayUnionString
This section contains reference documentation for the arrayUnionString function.
Create a union of two arrays of strings.
arrayUnionString('colName1', 'colName2')
select DivTailNums,
DivAirports,
arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats
WHERE arraylength(DivTailNums) >= 2
limit 5
DivTailNums | DivAirports | unionIds |
|---|---|---|
N7713A,N7713A | IND,IND | N7713A,IND |
N344AA,N344AA | MCI,BOS | N344AA,MCI,BOS |
N7713A,N7713A | IND,IND | N7713A,IND |
N344AA,N344AA | MCI,BOS | N344AA,MCI,BOS |
Last modified 1yr ago