Skip to content

Latest commit

 

History

History
33 lines (25 loc) · 828 Bytes

arrayunionstring.md

File metadata and controls

33 lines (25 loc) · 828 Bytes
description
This section contains reference documentation for the arrayUnionString function.

arrayUnionString

Create a union of two arrays of strings.

Signature

arrayUnionString('colName1', 'colName2')

Usage Examples

These examples are based on the Hybrid Quick Start.

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