SQL Functions

chr(expr) – Returns the ASCII character having the binary equivalent to `expr`. If n is

coalesce(expr1, expr2, …) – Returns the first non-null argument if exists. Otherwise, null. Platforms: WhereOS,

char(expr) – Returns the ASCII character having the binary equivalent to `expr`. If n is

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

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

ceiling(expr) – Returns the smallest integer not smaller than `expr`. Platforms: WhereOS, Spark, Hive Class: