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

multiday_count(x) – Returns a count of events over several different periods, Platforms: WhereOS, Spark, Hive

named_struct(name1, val1, name2, val2, …) – Creates a struct with the given field names and

mrr(array rankItems, array correctItems [, const int recommendSize = rankItems.size]) – Returns MRR Platforms: WhereOS,

mse(double predicted, double actual) – Return a Mean Squared Error Platforms: WhereOS, Spark, Hive Class:

month(date) – Returns the month component of the date/timestamp. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Month