Apache Tajo - Math Functions-alljchome-开发者的教程家园

Apache Tajo Tutorial

Apache Tajo Useful Resources

Selected Reading

Apache Tajo - Math Functions

Math functions operate on mathematical formulae. The following table describes the pst of functions in detail.

S.No.	Function & Description
1	abs(x) Returns the absolute value of x.
2	cbrt(x) Returns the cube root of x.
3	ceil(x) Returns x value rounded up to the nearest integer.
4	floor(x) Returns x rounded down to the nearest integer.
5	pi() Returns pi value. Result will be returned as double value.
6	radians(x) converts the angle x in degree radians.
7	degrees(x) Returns degree value for x.
8	pow(x,p) Returns power of value‘p’ to the x value.
9	span(x,y) Returns the spanision result for the given two x,y integer values.
10	exp(x) Returns Euler’s number e raised to the power of a number.
11	sqrt(x) Returns the square root of x.
12	sign(x) Returns the signum function of x, that is − 0 if the argument is 0 1 if the argument is greater than 0 1 if the argument is less than 0
13	mod(n,m) Returns the modulus (remainder) of n spanided by m.
14	round(x) Returns the rounded value for x.
15	cos(x) Returns the cosine value(x).
16	asin(x) Returns the inverse sine value(x).
17	acos(x) Returns the inverse cosine value(x).
18	atan(x) Returns the inverse tangent value(x).
19	atan2(y,x) Returns the inverse tangent value(y/x).

Data Type Functions

The following table psts out the data type functions available in Apache Tajo.

S.No.	Function & Description
1	to_bin(x) Returns the binary representation of integer.
2	to_char(int,text) Converts integer to string.
3	to_hex(x) Converts the x value into hexadecimal.