1 of 26

Numeric

This page describes how to use numeric functions in Lenses SQL Processors.

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
  }
}

ACOS

This page describes the ACOS function in Lenses SQL.

ACOS(numExpr)

Returns the trigonometric arc cosine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT ACOS(extra) 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "ACOS": "1.0471975511965979"
  }
}

ASIN

This page describes the ASIN function in Lenses SQL.

ASIN(numExpr)

Returns the trigonometric arc sine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT ASIN(extra) 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "ASIN": "0.5235987755982989"
  }
}

ATAN

This page describes the ATAN function in Lenses SQL.

ATAN(numExpr)

Returns the trigonometric arc tangent of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT ATAN(pickup_longitude) 
FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "ATAN": "-1.5572801259337674"
  }
}

CBRT

This page describes the CBRT function in Lenses SQL.

CBRT(numExpr)

Returns the cube root of numExpr.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    CBRT(integer),
    integer 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "CBRT": "25.483906287370523",
    "integer": 16550
  }
}

CEIL

This page describes the CEIL function in Lenses SQL.

CEIL(numExpr)

Returns the absolute value of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    CEIL(float),
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "CEIL": 96,
    "float": 95.95
  }
}

COSH

This page describes the COSH function in Lenses SQL.

COSH(numExpr)

Returns the hyperbolic cosine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    COSH(float),
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "COSH": "2.3416691959782676E41",
    "float": 95.95
  }
}

COS

This page describes the COS function in Lenses SQL.

COS(numExpr)

Returns the trigonometric cosine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    COS(float),
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "COS": "-0.13104605979102568",
    "float": 95.95
  }
}

DEGREES

This page describes the DEGRESS function in Lenses SQL.

DEGREES(numExpr)

Converts the input expression to degrees.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DEGREES(integer),
    integer 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "DEGREES": "948245.1509415124",
    "integer": 16550
  }
}

DISTANCE

This page describes the DISTANCE function in Lenses SQL.

DISTANCE(x1,y1,x2,y2)

Calculates the distance between two points using the haversine method.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DISTANCE(pickup_latitude, pickup_longitude, dropoff_latitude, dropoff_longitude) 
    FROM nyc-yellow-taxi-trip
LIMIT 1;

Output:

{
  "value": {
    "DISTANCE": "8579.658400770431"
  }
}

FLOOR

This page describes the FLOOR function in Lenses SQL.

FLOOR(numExpr)

Returns the largest value not greater than the argument.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    FLOOR(float),
    float 
FROM numbers-data
LIMIT 2;

Output:

{
  "value": {
    "FLOOR": 19,
    "float": 19.7
  }
}
{
  "value": {
    "FLOOR": 83,
    "float": 83.82
  }
}

MAX

This page describes the MAX function in Lenses SQL.

MAX(numExpr1,numExpr2,numExpr3)

Returns the maximum element from an arbitrary number of given elements.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT MAX(integer, float) 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "MAX": 16550
  }
}

MIN

This page describes the MIN function in Lenses SQL.

Returns the minimum element from an arbitrary number of given elements.

Available in:

Processors

SQL Studio

Sample code:

Output:

MOD

This page describes the MOD function in Lenses SQL.

Alias for %.

Available in:

Processors

SQL Studio

Sample code:

Output:

NEG

This page describes the NEG function in Lenses SQL.

Returns the negative value of an expression it has to evaluate to a number type.

Available in:

Processors

SQL Studio

Sample code:

Output:

POW

This page describes the POW function in Lenses SQL.

Returns numExp1 raised to the numExp2 power.

Available in:

Processors

SQL Studio

Sample code:

Output:

RADIANS

This page describes the RADIANS function in Lenses SQL.

Converts the input expression to radians.

Available in:

Processors

SQL Studio

Sample code:

Output:

RANDINT

This page describes the RANDINT function in Lenses SQL.

RANDINT()

Returns a random integer.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT RANDINT() 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "RANDINT": 395069592
  }
}

ROUND

This page describes the ROUND function in Lenses SQL.

ROUND(numExpr)

Returns the closest integer of an expression, with ties rounding towards positive infinity.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    ROUND(float), 
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "ROUND": 96,
    "float": 95.95
  }
}

SIGN

This page describes the SIGN function in Lenses SQL.

SIGN(numExpr)

Returns +1 if a value is positive or -1 if a value is negative.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SIGN(integer) AS positive, 
    SIGN(NEG(integer)) AS negative 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "positive": 1,
    "negative": -1
  }
}

We use the NEG function to emulate a negative value in this function.

SINH

This page describes the SINH function in Lenses SQL.

SINH(numExpr)

Returns the hyperbolic sine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SINH(float), 
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "SINH": "2.3416691959782676E41",
    "float": 95.95
  }
}

SIN

This page describes the SIN function in Lenses SQL.

SIN(numExpr)

Returns the hyperbolic sine of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SIN(float), 
    float 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "SIN": "0.991376280840553",
    "float": 95.95
  }
}

SQRT

This page describes the SQRT function in Lenses SQL.

SQRT(numExpr)

Returns the square root of numExpr.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SQRT(integer), 
    integer 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "SQRT": "128.64680330268607",
    "integer": 16550
  }
}

TANH

This page describes the TANH function in Lenses SQL.

TANH(numExpr)

Returns the hyperbolic tangent of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    TANH(integer), 
    integer 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "TANH": 1,
    "float": 95.95
  }
}

TAN

This page describes the TAN function in Lenses SQL.

TAN (numExpr)

Returns the trigonometric tangent of an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    TAN(integer), 
    integer 
FROM numbers-data
LIMIT 1;

Output:

{
  "value": {
    "TAN": "0.09014387261790552",
    "integer": 16550
  }
}