Apache Pinot Docs
Search…
latest
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 Hybrid Quick Start.
1
select DivTailNums,
2
DivAirports,
3
arrayUnionString(DivTailNums, DivAirports) AS unionIds
4
from airlineStats
5
WHERE arraylength(DivTailNums) >= 2
6
limit 5
Copied!
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 2mo ago
Copy link