EXP()

Description

The EXP() function returns the value of e (the base of natural logarithms) raised to the power of X.

Syntax

1. > EXP(number)

Arguments

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

Examples

1. > drop table if exists t1;
2. > create table t1(a int ,b float);
3. > insert into t1 values(-4, 2.45);
4. > insert into t1 values(6, -3.62);
5. > select exp(a), exp(b) from t1;
6. +----------+---------+
7. | exp(a)   | exp(b)  |
8. +----------+---------+
9. |   0.0183 | 11.5883 |
10. | 403.4288 |  0.0268 |
11. +----------+---------+

Constraints

Currently, MatrixOne doesn’t support select function() without from tables.