Powered by GitBook

1 of 1

Loading...

arrayUnionString

This section contains reference documentation for the arrayUnionString function.

Create a union of two arrays of strings.

Signature

arrayUnionString('colName1', 'colName2')

Usage Examples

These examples are based on the .

DivTailNums

DivAirports

unionIds

MCI,BOS

N344AA,MCI,BOS

N7713A,N7713A

IND,IND

N7713A,IND

N344AA,N344AA

MCI,BOS

N344AA,MCI,BOS

N7713A,N7713A

IND,IND

N7713A,IND

Hybrid Quick Start

N344AA,N344AA

select DivTailNums, 
       DivAirports,
       arrayUnionString(DivTailNums, DivAirports) AS unionIds
from airlineStats 
WHERE arraylength(DivTailNums) >= 2
limit 5