1 of 1

ABS

This page describes the ABS function in Lenses SQL.

ABS(numExpr)

Returns the absolute value of an expression that evaluates to a number type.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    ACOS(total/100.0) AS arccosine_total_ratio, 
    total 
FROM orders-events
LIMIT 1;

Output:

{
  "value": {
    "arccosine_total_ratio": "1.119313791750037",
    "total": 43.63
  }
}

This page describes the ABS function in Lenses SQL.

ABS(numExpr)

Returns the absolute value of an expression that evaluates to a number type.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    ACOS(total/100.0) AS arccosine_total_ratio, 
    total 
FROM orders-events
LIMIT 1;

Output:

{
  "value": {
    "arccosine_total_ratio": "1.119313791750037",
    "total": 43.63
  }
}