SQL Functions

mhash(string word) returns a murmurhash3 INT value starting from 1 Platforms: WhereOS, Spark, Hive Class:

map_url(double lat, double lon, int zoom [, const string option]) – Returns a URL string

map_values(map) – Returns an unordered array containing the values of the map. Platforms: WhereOS, Spark,

max(expr) – Returns the maximum value of `expr`. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.aggregate.Max More

max_label(double value, string label) – Returns a label that has the maximum value Platforms: WhereOS,

map_tail_n(map SRC, int N) – Returns the last N elements from a sorted array of