log

Calculates the logarithm of a number to a specified base (or radix). If the base is not specified, this function is equivalent to ln.

Syntax

log([base,] arg)

Parameters

• base: Optional. The base. Only DOUBLE data type is supported. If this parameter is not specified, this function is equivalent to ln.

NOTE

StarRocks returns NULL if base is specified as a negative, 0, or 1.

• arg: The value whose logarithm you want to calculate. Only DOUBLE data type is supported.

NOTE

StarRocks returns NULL if arg is specified as a negative or 0.

Return value

Returns a value of the DOUBLE data type.

Example

Example 1: Calculate the logarithm of 8 to the base 2.

mysql> select log(2,8);
+-----------+
| log(2, 8) |
+-----------+
|         3 |
+-----------+
1 row in set (0.01 sec)

Example 2: Calculate the logarithm of 10 to the base e (with the base not specified).

mysql> select log(10);
+-------------------+
| log(10)           |
+-------------------+
| 2.302585092994046 |
+-------------------+
1 row in set (0.09 sec)