popcnt(a [, b]) – Returns a popcount value select popcnt(3), popcnt(“3”), — 3=0x11 popcnt(array(1,3)); 2

pi() – Returns pi. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Pi More functions can be added

plsa_predict(string word, float value, int label, float prob[, const string options]) – Returns a list

pmod(expr1, expr2) – Returns the positive value of `expr1` mod `expr2`. Platforms: WhereOS, Spark, Hive

polynomial_features(feature_vector in array) – Returns a feature vectorhaving polynomial feature space Platforms: WhereOS, Spark, Hive

percentile(col, percentage [, frequency]) – Returns the exact percentile value of numeric column `col` at