SQL Functions

map_from_arrays(keys, values) – Creates a map with a pair of the given key/value arrays. All

map_from_entries(arrayOfEntries) – Returns a map created from the given array of entries. Platforms: WhereOS, Spark,

map_exclude_keys(Map map, array filteringKeys) – Returns the filtered entries of a map not having specified

manhattan_distance(list x, list y) – Returns sum(|x – y|) WITH docs as ( select 1

map(key0, value0, key1, value1, …) – Creates a map with the given key/value pairs. Platforms:

map_concat(map, …) – Returns the union of all the given maps Platforms: WhereOS, Spark, Hive