Blog

subarray(array values, int offset [, int length]) – Slices the given array by the given

string(expr) – Casts the value `expr` to the target data type `string`. Platforms: WhereOS, Spark,

struct(col1, col2, col3, …) – Creates a struct with the given field values. Platforms: WhereOS,

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

stddev_pop(expr) – Returns the population standard deviation calculated from values of a group. Platforms: WhereOS,

str_to_map(text[, pairDelim[, keyValueDelim]]) – Creates a map after splitting the text into key/value pairs using