Blog

substring_index(str, delim, count) – Returns the substring from `str` before `count` occurrences of the delimiter

sum an array of doubles Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.timeseries.SumArrayUDF More functions can be

sum(expr) – Returns the sum calculated from values of a group. Platforms: WhereOS, Spark, Hive

subarray_startwith(array original, int|text key) – Returns an array that starts with the specified key SELECT

substring(str, pos[, len]) – Returns the substring of `str` that starts at `pos` and is

substr(str, pos[, len]) – Returns the substring of `str` that starts at `pos` and is