SQL Functions

rollup([col1[, col2 ..]]) – create a multi-dimensional rollup using the specified columns so that we

round(expr, d) – Returns `expr` rounded to `d` decimal places using HALF_UP rounding mode. Platforms:

rint(expr) – Returns the double value that is closest in value to the argument and

str rlike regexp – Returns true if `str` matches `regexp`, or false otherwise. Platforms: WhereOS,

rmse(double predicted, double actual) – Return a Root Mean Squared Error Platforms: WhereOS, Spark, Hive

reverse(array) – Returns a reversed string or an array with reverse order of elements. Platforms: