LOG()

Description

LOG(X) returns the natural logarithm of X.

Syntax

  1. > LOG(X)

Arguments

ArgumentsDescription
XRequired. 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.