Logarithmic Functions in Apache AGE

ApacheAGE being a multipurpose extension provides a range of functions including the logarithmic functions that are quite useful, we have discussed them in detail below:

e

e() returns the base of the natural logarithm, e.

Syntax:e()

Returns:
An agtype float.


Query:

SELECT *
FROM cypher('graph_name', $$
    RETURN e()
$$) as (e agtype);

Results

sqrt

sqrt() returns the square root of a number.

Syntax:sqrt(expression)

Returns:
An agtype float.


Query
SELECT *
FROM cypher('graph_name', $$
RETURN sqrt(144)
$$) as (results agtype);

Results

exp

exp() returns e^n, where e is the base of the natural logarithm, and n is the value of the argument expression.

Syntax: e(expression)

Returns:
An agtype Float.

Arguments:

Considerations:

• exp(null) returns null.

Query:

SELECT *
FROM cypher('graph_name', $$
    RETURN exp(2)
$$) as (e agtype);

e to the power of 2 is returned.

Result:

log

log() returns the natural logarithm of a number.

Syntax:log(expression)

Returns:
An agtype Float.

Arguments:

Considerations:

• log(null) returns null.
• log(0) returns null.

Query:

SELECT *
FROM cypher('graph_name', $$
    RETURN log(27)
$$) as (natural_logarithm agtype);

The natural logarithm of 27 is returned.

Result:

log10

log10() returns the common logarithm (base 10) of a number.

Syntax:log10(expression)

Returns:
An agtype Float.

Arguments:

Considerations:

• log10(null) returns null.
• log10(0) returns null.

Query:
SELECT *
FROM cypher('graph_name', $$
RETURN log10(27)
$$) as (common_logarithm agtype);

The common logarithm of 27 is returned.

Result: