nan
nan() – Returns the constant representing not-a-number. SELECT nan(), is_nan(nan()); NaN true Platforms: WhereOS, Spark,
mrr
mrr(array rankItems, array correctItems [, const int recommendSize = rankItems.size]) – Returns MRR Platforms: WhereOS,
mse
mse(double predicted, double actual) – Return a Mean Squared Error Platforms: WhereOS, Spark, Hive Class:
multiday_count
multiday_count(x) – Returns a count of events over several different periods, Platforms: WhereOS, Spark, Hive
named_struct
named_struct(name1, val1, name2, val2, …) – Creates a struct with the given field names and
month
month(date) – Returns the month component of the date/timestamp. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Month
