Apache Pinot Docs
Search…
latest
arrayConcatString
This section contains reference documentation for the arrayConcatString function.
Concatenates two arrays of strings.

Signature

arrayConcatString('colName1', 'colName2')

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select DivTailNums,
2
arrayConcatString(DivTailNums, DivTailNums) AS concatIds
3
from airlineStats
4
WHERE arraylength(DivTailNums) >= 2
5
limit 5
Copied!
DivTailNums
concatIds
N7713A,N7713A
N7713A,N7713A,N7713A,N7713A
N344AA,N344AA
N344AA,N344AA,N344AA,N344AA
N344AA,N344AA
N344AA,N344AA,N344AA,N344AA
N7713A,N7713A
N7713A,N7713A,N7713A,N7713A
Copy link