Blog

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

feature_pairs(feature_vector in array, [, const string options]) – Returns a relation Platforms: WhereOS, Spark, Hive

ffm_features(const array featureNames, feature1, feature2, .. [, const string options]) – Takes categorical variables and

filter(expr, func) – Filters the input array using the given predicate. Platforms: WhereOS, Spark, Hive