posexplode_outer
posexplode_outer(expr) – Separates the elements of array `expr` into multiple rows with positions, or the
posexplodepairs
Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.PosExplodePairsUDTF More functions can be added to WhereOS via Python
position
position(substr, str[, pos]) – Returns the position of the first occurrence of `substr` in `str`
positive
positive(expr) – Returns the value of `expr`. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.UnaryPositive More functions
popcnt
popcnt(a [, b]) – Returns a popcount value select popcnt(3), popcnt(“3”), — 3=0x11 popcnt(array(1,3)); 2
populate_not_in
populate_not_in(list items, const int max_item_id [, const string options])- Returns a relation consists of that
