posexplode_outer(expr) – Separates the elements of array `expr` into multiple rows with positions, or the

Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.PosExplodePairsUDTF More functions can be added to WhereOS via Python

position(substr, str[, pos]) – Returns the position of the first occurrence of `substr` in `str`

positive(expr) – Returns the value of `expr`. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.UnaryPositive More functions

populate_not_in(list items, const int max_item_id [, const string options])- Returns a relation consists of that

posexplode(expr) – Separates the elements of array `expr` into multiple rows with positions, or the