Database Reference
In-Depth Information
Return
type
Function name
Usage
ABS(DOUBLE a)
To return the absolute value of the argument
DOUBLE
COS(DOUBLE a)
To return the cosine of the argument
DOUBLE
BIN(BIGINT a)
To return the binary representation of the integer
value
DOUBLE
FLOOR(DOUBLE
a)
To return the largest, least, or equal to the argu-
ment
INT
PI()
To return the value of contact Pi
DOUBLE
RAND(INT seed)
To return a random value between 0 and 1
DOUBLE
Besides these, there are several other mathematical functions in Impala such as
SIGN
,
SIN
,
SQRT
,
TAN
,
ROUND
,
POW
,
NEGATIVE
,
HEX
,
DEGREES
, and
ASIN
. To study
most of the functions, please visit the Impala documentation at Cloudera's website.
Now, let's study a few of the common string built-in functions in the following table:
