ARRAY_JOIN
ARRAY_JOIN(VALUES, SEPARATOR)
"a"
, "b"
, "c"
", "
"a, b, c"
5.5
", "
"5.5"
"a"
, "b"
, "c"
""
"abc"
ARRAY_MAX
1
, 0.2
, 30
30
ARRAY_MIN
1
, 0.2
, 30
0.2
ARRAY_SUM
1
, 0.2
, 30
31.2
CONCAT
COUNT_VALUES
0
"a"
, "b"
, "c"
3
COUNT_VALUES_IF
true
values in a given array.0
true
, false
, true
2
DISTINCT_VALUES
1
, 2
, 3
, 4
, 4
, 1
1
, 2
, 3
, 4
ELEMENT_AT
"a"
, "b"
, "c"
1
"b"
"a"
1
null
"a"
, "b"
, "c"
-1
null
FIRST_ELEMENT
null
"a"
, "b"
, "c"
"a"
LAST_ELEMENT
null
"a"
, "b"
, "c"
"c"
LEAST
[1, 0.2]
, [30]
0.2
PRESTO_CONCAT(STRING1, STRING2, ..., STRINGN)
STRING#
An expression to concatenate. "a"
, "b"
, "c"
"abc"
"1", "2" , "A", "B"
"12AB"