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
posexplode
posexplode(expr) – Separates the elements of array `expr` into multiple rows with positions, or the
pmod
pmod(expr1, expr2) – Returns the positive value of `expr1` mod `expr2`. Platforms: WhereOS, Spark, Hive
