left(str, len) – Returns the leftmost `len`(`len` can be string type) characters from the string

length(expr) – Returns the character length of string data or number of bytes of binary

lat2tiley(double lat, int zoom)::int – Returns the tile number of the given latitude and zoom

lcase(str) – Returns `str` with all characters changed to lowercase. Platforms: WhereOS, Spark, Hive Class:

lda_predict(string word, float value, int label, float lambda[, const string options]) – Returns a list

last_element(x) – Return the last element in an array SELECT last_element(array(‘a’,’b’,’c’)); c Platforms: WhereOS, Spark,