Last updated 2 years ago
Was this helpful?
Concatenates two arrays of longs.
arrayConcatLong('colName1', 'colName2')
This example assumes the multiValueTable columns mvCol1 and mvCol2 are both of type LONG with singleValueField in the table schema set to false.
select mvCol1, arrayConcatLong(mvCol1, mvCol2) AS concatLongs from multiValueTable WHERE arraylength(mvCol1) >= 2 limit 5
This section contains reference documentation for the arrayConcatLong function.