Apache Tajo - sign(x)

Let us now check the sign(x) function with the following query.

Query

default> select sign(4) as signum; 

Result

The above query will generate the following result.

signum 
------------------------------- 
1.0 

Here, the signum value is 4 which is greater than 0. So, the result is 1. If the value is <0 then result will be -1.