LOG()

Description

LOG(X) returns the natural logarithm of X.

Syntax

1. > LOG(X)

Arguments

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

Examples

1. > drop table if exists t1;
2. > create table t1(a float, b float);
3. > insert into t1 values(2,-2);
4. > select log(a), log(b) from t1;
5. +--------+--------+
6. | log(a) | log(b) |
7. +--------+--------+
8. | 0.6931 |   NULL |
9. +--------+--------+

Constraints

  • LOG(X) only support one parameter input for now.
  • Currently, MatrixOne doesn’t support select function() without from tables.