Skip to content

LOG()

Description

LOG(X) returns the natural logarithm of X.

Syntax

> LOG(X)

Arguments

Arguments Description
X Required. Any numeric data type supported now.

Examples

> drop table if exists t1;
> create table t1(a float, b float);
> insert into t1 values(2,-2);
> select log(a), log(b) from t1;
+--------+--------+
| log(a) | log(b) |
+--------+--------+
| 0.6931 |   NULL |
+--------+--------+

Constraints

LOG(X) only support one parameter input for now.