first_index(x) – Last value in an array Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.collect.FirstIndexUDF More functions

first_value(expr[, isIgnoreNull]) – Returns the first value of `expr` for a group of rows. If

flatten(arrayOfArrays) – Transforms an array of arrays into a single array. Platforms: WhereOS, Spark, Hive

find_in_set(str, str_array) – Returns the index (1-based) of the given string (`str`) in the comma-delimited

first(expr[, isIgnoreNull]) – Returns the first value of `expr` for a group of rows. If

first_element(x) – Returns the first element in an array SELECT first_element(array(‘a’,’b’,’c’)); a SELECT first_element(array()); NULL