Blog

nan() – Returns the constant representing not-a-number. SELECT nan(), is_nan(nan()); NaN true Platforms: WhereOS, Spark,

nanvl(expr1, expr2) – Returns `expr1` if it’s not NaN, or `expr2` otherwise. Platforms: WhereOS, Spark,

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

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

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

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