This is an automated email from the ASF dual-hosted git repository. critas pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new 62a371f9 fix math function table (#710)
62a371f9 is described below
commit 62a371f98f9acaa052503ebd44de9345a39564f9
Author: leto-b <[email protected]>
AuthorDate: Tue Apr 22 12:17:43 2025 +0800
fix math function table (#710)
---
.../Master/Table/SQL-Manual/Basis-Function.md | 50 +++++++++++-----------
.../latest-Table/SQL-Manual/Basis-Function.md | 50 +++++++++++-----------
.../Master/Table/SQL-Manual/Basis-Function.md | 50 +++++++++++-----------
.../latest-Table/SQL-Manual/Basis-Function.md | 50 +++++++++++-----------
4 files changed, 100 insertions(+), 100 deletions(-)
diff --git a/src/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
b/src/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
index 4ecb0248..328f7fa8 100644
--- a/src/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
+++ b/src/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
@@ -635,31 +635,31 @@ It costs 0.319s
### 5.2 Mathematical functions
-| Function Name | Description
| Input | Output | Usage
|
-| :------------------------------- |
:----------------------------------------------------------- |
:-------------------------- | :----------------- | :--------- |
-| sin | Sine
| double, float, INT64, INT32 | double | sin(x)
|
-| cos | Cosine
| double, float, INT64, INT32 | double | cos(x)
|
-| tan | Tangent
| double, float, INT64, INT32 | double | tan(x)
|
-| asin | Inverse Sine
| double, float, INT64, INT32 | double | asin(x)
|
-| acos | Inverse Cosine
| double, float, INT64, INT32 | double | acos(x)
|
-| atan | Inverse Tangent
| double, float, INT64, INT32 | double | atan(x)
|
-| sinh | Hyperbolic Sine
| double, float, INT64, INT32 | double | sinh(x)
|
-| cosh | Hyperbolic Cosine
| double, float, INT64, INT32 | double | cosh(x)
|
-| tanh | Hyperbolic Tangent
| double, float, INT64, INT32 | double | tanh(x)
|
-| degrees | Converts angle `x` in radians to degrees
| double, float, INT64, INT32 | double |
degrees(x) |
-| radians | Radian Conversion from Degrees
| double, float, INT64, INT32 | double |
radians(x) |
-| abs | Absolute Value
| double, float, INT64, INT32 | Same as input type | abs(x)
|
-| sign | Returns the sign of `x`: - If `x = 0`,
returns `0` - If `x > 0`, returns `1` - If `x < 0`, returns `-1` For
`double/float` inputs: - If `x = NaN`, returns `NaN` - If `x = +Infinity`,
returns `1.0` - If `x = -Infinity`, returns `-1.0` | double, float, INT64,
INT32 | Same as input type | sign(x) |
-| ceil | Rounds `x` up to the nearest integer
| double, float, INT64, INT32 | double | ceil(x)
|
-| floor | Rounds `x` down to the nearest integer
| double, float, INT64, INT32 | double |
floor(x) |
-| exp | Returns `e^x` (Euler's number raised to
the power of `x`) | double, float, INT64, INT32 | double |
exp(x) |
-| ln | Returns the natural logarithm of `x`
| double, float, INT64, INT32 | double | ln(x)
|
-| log10 | Returns the base 10 logarithm of `x`
| double, float, INT64, INT32 | double |
log10(x) |
-| round | Rounds `x` to the nearest integer
| double, float, INT64, INT32 | double |
round(x) |
-| Rounds `x` to `d` decimal places | double, float, INT64, INT32
| double | round(x, d) |
|
-| sqrt | Returns the square root of `x`.
| double, float, INT64, INT32 | double | sqrt(x)
|
-| e | Returns Euler’s number `e`.
| | double | e()
|
-| pi | Pi (π)
| | double | pi()
|
+| Function Name | Description
| Input | Output | Usage
|
+|:--------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------|:--------------------|
:--------- |
+| sin | Sine
| double, float, INT64, INT32 | double |
sin(x) |
+| cos | Cosine
| double, float, INT64, INT32 | double |
cos(x) |
+| tan | Tangent
| double, float, INT64, INT32 | double |
tan(x) |
+| asin | Inverse Sine
| double, float, INT64, INT32 | double |
asin(x) |
+| acos | Inverse Cosine
| double, float, INT64, INT32 | double |
acos(x) |
+| atan | Inverse Tangent
| double, float, INT64, INT32 | double |
atan(x) |
+| sinh | Hyperbolic Sine
| double, float, INT64, INT32 | double |
sinh(x) |
+| cosh | Hyperbolic Cosine
| double, float, INT64, INT32 | double |
cosh(x) |
+| tanh | Hyperbolic Tangent
| double, float, INT64, INT32 | double |
tanh(x) |
+| degrees | Converts angle `x` in radians to degrees
| double, float, INT64, INT32 | double |
degrees(x) |
+| radians | Radian Conversion from Degrees
| double, float, INT64, INT32 | double |
radians(x) |
+| abs | Absolute Value
| double, float, INT64, INT32 | Same as input type |
abs(x) |
+| sign | Returns the sign of `x`: - If `x = 0`, returns `0` - If `x
> 0`, returns `1` - If `x < 0`, returns `-1` For `double/float` inputs: - If
`x = NaN`, returns `NaN` - If `x = +Infinity`, returns `1.0` - If `x =
-Infinity`, returns `-1.0` | double, float, INT64, INT32 | Same as input type
| sign(x) |
+| ceil | Rounds `x` up to the nearest integer
| double, float, INT64, INT32 | double |
ceil(x) |
+| floor | Rounds `x` down to the nearest integer
| double, float, INT64, INT32 | double |
floor(x) |
+| exp | Returns `e^x` (Euler's number raised to the power of `x`)
| double, float, INT64, INT32 | double |
exp(x) |
+| ln | Returns the natural logarithm of `x`
| double, float, INT64, INT32 | double | ln(x)
|
+| log10 | Returns the base 10 logarithm of `x`
| double, float, INT64, INT32 | double |
log10(x) |
+| round | Rounds `x` to the nearest integer
| double, float, INT64, INT32 | double |
round(x) |
+| round | Rounds `x` to `d` decimal places
| double, float, INT64, INT32 | double |
round(x, d)|
+| sqrt | Returns the square root of `x`.
| double, float, INT64, INT32 | double |
sqrt(x) |
+| e | Returns Euler’s number `e`.
| | double | e()
|
+| pi | Pi (π)
| | double | pi()
|
## 6. Conditional Expressions
diff --git a/src/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
b/src/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
index 4ecb0248..75734cc1 100644
--- a/src/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
+++ b/src/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
@@ -635,31 +635,31 @@ It costs 0.319s
### 5.2 Mathematical functions
-| Function Name | Description
| Input | Output | Usage
|
-| :------------------------------- |
:----------------------------------------------------------- |
:-------------------------- | :----------------- | :--------- |
-| sin | Sine
| double, float, INT64, INT32 | double | sin(x)
|
-| cos | Cosine
| double, float, INT64, INT32 | double | cos(x)
|
-| tan | Tangent
| double, float, INT64, INT32 | double | tan(x)
|
-| asin | Inverse Sine
| double, float, INT64, INT32 | double | asin(x)
|
-| acos | Inverse Cosine
| double, float, INT64, INT32 | double | acos(x)
|
-| atan | Inverse Tangent
| double, float, INT64, INT32 | double | atan(x)
|
-| sinh | Hyperbolic Sine
| double, float, INT64, INT32 | double | sinh(x)
|
-| cosh | Hyperbolic Cosine
| double, float, INT64, INT32 | double | cosh(x)
|
-| tanh | Hyperbolic Tangent
| double, float, INT64, INT32 | double | tanh(x)
|
-| degrees | Converts angle `x` in radians to degrees
| double, float, INT64, INT32 | double |
degrees(x) |
-| radians | Radian Conversion from Degrees
| double, float, INT64, INT32 | double |
radians(x) |
-| abs | Absolute Value
| double, float, INT64, INT32 | Same as input type | abs(x)
|
-| sign | Returns the sign of `x`: - If `x = 0`,
returns `0` - If `x > 0`, returns `1` - If `x < 0`, returns `-1` For
`double/float` inputs: - If `x = NaN`, returns `NaN` - If `x = +Infinity`,
returns `1.0` - If `x = -Infinity`, returns `-1.0` | double, float, INT64,
INT32 | Same as input type | sign(x) |
-| ceil | Rounds `x` up to the nearest integer
| double, float, INT64, INT32 | double | ceil(x)
|
-| floor | Rounds `x` down to the nearest integer
| double, float, INT64, INT32 | double |
floor(x) |
-| exp | Returns `e^x` (Euler's number raised to
the power of `x`) | double, float, INT64, INT32 | double |
exp(x) |
-| ln | Returns the natural logarithm of `x`
| double, float, INT64, INT32 | double | ln(x)
|
-| log10 | Returns the base 10 logarithm of `x`
| double, float, INT64, INT32 | double |
log10(x) |
-| round | Rounds `x` to the nearest integer
| double, float, INT64, INT32 | double |
round(x) |
-| Rounds `x` to `d` decimal places | double, float, INT64, INT32
| double | round(x, d) |
|
-| sqrt | Returns the square root of `x`.
| double, float, INT64, INT32 | double | sqrt(x)
|
-| e | Returns Euler’s number `e`.
| | double | e()
|
-| pi | Pi (π)
| | double | pi()
|
+| Function Name | Description
| Input | Output | Usage
|
+|:--------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------|:-------------------|
:--------- |
+| sin | Sine
| double, float, INT64, INT32 | double | sin(x)
|
+| cos | Cosine
| double, float, INT64, INT32 | double | cos(x)
|
+| tan | Tangent
| double, float, INT64, INT32 | double | tan(x)
|
+| asin | Inverse Sine
| double, float, INT64, INT32 | double |
asin(x) |
+| acos | Inverse Cosine
| double, float, INT64, INT32 | double |
acos(x) |
+| atan | Inverse Tangent
| double, float, INT64, INT32 | double |
atan(x) |
+| sinh | Hyperbolic Sine
| double, float, INT64, INT32 | double |
sinh(x) |
+| cosh | Hyperbolic Cosine
| double, float, INT64, INT32 | double |
cosh(x) |
+| tanh | Hyperbolic Tangent
| double, float, INT64, INT32 | double |
tanh(x) |
+| degrees | Converts angle `x` in radians to degrees
| double, float, INT64, INT32 | double |
degrees(x) |
+| radians | Radian Conversion from Degrees
| double, float, INT64, INT32 | double |
radians(x) |
+| abs | Absolute Value
| double, float, INT64, INT32 | Same as input type | abs(x)
|
+| sign | Returns the sign of `x`: - If `x = 0`, returns `0` - If `x
> 0`, returns `1` - If `x < 0`, returns `-1` For `double/float` inputs: - If
`x = NaN`, returns `NaN` - If `x = +Infinity`, returns `1.0` - If `x =
-Infinity`, returns `-1.0` | double, float, INT64, INT32 | Same as input type |
sign(x) |
+| ceil | Rounds `x` up to the nearest integer
| double, float, INT64, INT32 | double |
ceil(x) |
+| floor | Rounds `x` down to the nearest integer
| double, float, INT64, INT32 | double |
floor(x) |
+| exp | Returns `e^x` (Euler's number raised to the power of `x`)
| double, float, INT64, INT32 | double | exp(x)
|
+| ln | Returns the natural logarithm of `x`
| double, float, INT64, INT32 | double | ln(x)
|
+| log10 | Returns the base 10 logarithm of `x`
| double, float, INT64, INT32 | double |
log10(x) |
+| round | Rounds `x` to the nearest integer
| double, float, INT64, INT32 | double |
round(x) |
+| round | Rounds `x` to `d` decimal places
| double, float, INT64, INT32 | double |
round(x, d) |
+| sqrt | Returns the square root of `x`.
| double, float, INT64, INT32 | double |
sqrt(x) |
+| e | Returns Euler’s number `e`.
| | double | e()
|
+| pi | Pi (π)
| | double | pi()
|
## 6. Conditional Expressions
diff --git a/src/zh/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
b/src/zh/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
index 044fb381..de1f2fd1 100644
--- a/src/zh/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
+++ b/src/zh/UserGuide/Master/Table/SQL-Manual/Basis-Function.md
@@ -636,31 +636,31 @@ It costs 0.319s
### 5.2 数学函数
-| 函数名 | 描述
| 输入 | 输出 | 用法 |
-| ---------------------------- |
------------------------------------------------------------ |
--------------------------- | ---------------------- | ---------- |
-| sin | 正弦函数
| double、float、INT64、INT32 | double | sin(x) |
-| cos | 余弦函数
| double、float、INT64、INT32 | double | cos(x) |
-| tan | 正切函数
| double、float、INT64、INT32 | double | tan(x) |
-| asin | 反正弦函数
| double、float、INT64、INT32 | double | asin(x) |
-| acos | 反余弦函数
| double、float、INT64、INT32 | double | acos(x) |
-| atan | 反正切函数
| double、float、INT64、INT32 | double | atan(x) |
-| sinh | 双曲正弦函数
| double、float、INT64、INT32 | double | sinh(x) |
-| cosh | 双曲余弦函数
| double、float、INT64、INT32 | double | cosh(x) |
-| tanh | 双曲正切函数
| double、float、INT64、INT32 | double | tanh(x) |
-| degrees | 将弧度角 x 转换为度
| double、float、INT64、INT32 | double | degrees(x) |
-| radians | 将度转换为弧度
| double、float、INT64、INT32 | double | radians(x) |
-| abs | 绝对值
| double、float、INT64、INT32 | 返回与输入类型相同的值 | abs(x) |
-| sign | 返回 x 的符号函数，即：如果参数为 0，则返回 0，如果参数大于 0，则返回
1，如果参数小于 0，则返回 -1。对于 double/float 类型的参数，函数还会返回：如果参数为 NaN，则返回 NaN，如果参数为
+Infinity，则返回 1.0，如果参数为 -Infinity，则返回 -1.0。 | double、float、INT64、INT32 |
返回与输入类型相同的值 | sign(x) |
-| ceil | 返回 x 向上取整到最近的整数。
| double、float、INT64、INT32 | double | ceil(x) |
-| floor | 返回 x 向下取整到最近的整数。
| double、float、INT64、INT32 | double | floor(x) |
-| exp | 返回欧拉数 e 的 x 次幂。
| double、float、INT64、INT32 | double | exp(x) |
-| ln | 返回 x 的自然对数。
| double、float、INT64、INT32 | double | ln(x) |
-| log10 | 返回 x 的以 10 为底的对数。
| double、float、INT64、INT32 | double | log10(x) |
-| round | 返回 x 四舍五入到最近的整数。
| double、float、INT64、INT32 | double | round(x) |
-| 返回 x 四舍五入到 d 位小数。 | double、float、INT64、INT32
| double | round(x, d) | |
-| sqrt | 返回 x 的平方根。
| double、float、INT64、INT32 | double | sqrt(x) |
-| e | 自然指数
| | double | e() |
-| pi | π
| | double | pi()
|
+| 函数名 | 描述
| 输入 | 输出 | 用法 |
+|-----------|------------------------------------------------------------------------------------------------------------------------------------------------------------|
--------------------------- | ---------------------- | ---------- |
+| sin | 正弦函数
| double、float、INT64、INT32 | double | sin(x) |
+| cos | 余弦函数
| double、float、INT64、INT32 | double | cos(x) |
+| tan | 正切函数
| double、float、INT64、INT32 | double | tan(x) |
+| asin | 反正弦函数
| double、float、INT64、INT32 | double | asin(x) |
+| acos | 反余弦函数
| double、float、INT64、INT32 | double | acos(x) |
+| atan | 反正切函数
| double、float、INT64、INT32 | double | atan(x) |
+| sinh | 双曲正弦函数
| double、float、INT64、INT32 | double | sinh(x) |
+| cosh | 双曲余弦函数
| double、float、INT64、INT32 | double | cosh(x) |
+| tanh | 双曲正切函数
| double、float、INT64、INT32 | double | tanh(x) |
+| degrees | 将弧度角 x 转换为度
| double、float、INT64、INT32 | double | degrees(x) |
+| radians | 将度转换为弧度
| double、float、INT64、INT32 | double | radians(x) |
+| abs | 绝对值
| double、float、INT64、INT32 | 返回与输入类型相同的值 | abs(x) |
+| sign | 返回 x 的符号函数，即：如果参数为 0，则返回 0，如果参数大于 0，则返回 1，如果参数小于 0，则返回 -1。对于
double/float 类型的参数，函数还会返回：如果参数为 NaN，则返回 NaN，如果参数为 +Infinity，则返回 1.0，如果参数为
-Infinity，则返回 -1.0。 | double、float、INT64、INT32 | 返回与输入类型相同的值 | sign(x) |
+| ceil | 返回 x 向上取整到最近的整数。
| double、float、INT64、INT32 | double | ceil(x) |
+| floor | 返回 x 向下取整到最近的整数。
| double、float、INT64、INT32 | double | floor(x) |
+| exp | 返回欧拉数 e 的 x 次幂。
| double、float、INT64、INT32 | double | exp(x) |
+| ln | 返回 x 的自然对数。
| double、float、INT64、INT32 | double | ln(x) |
+| log10 | 返回 x 的以 10 为底的对数。
| double、float、INT64、INT32 | double | log10(x) |
+| round | 返回 x 四舍五入到最近的整数。
| double、float、INT64、INT32 | double | round(x) |
+| round | 返回 x 四舍五入到 d 位小数。
| double、float、INT64、INT32 | double
| round(x, d) |
+| sqrt | 返回 x 的平方根。
| double、float、INT64、INT32 | double | sqrt(x) |
+| e | 自然指数
| | double | e() |
+| pi | π
| | double | pi() |
## 6. 条件表达式
diff --git a/src/zh/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
b/src/zh/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
index 044fb381..383c53dd 100644
--- a/src/zh/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
+++ b/src/zh/UserGuide/latest-Table/SQL-Manual/Basis-Function.md
@@ -636,31 +636,31 @@ It costs 0.319s
### 5.2 数学函数
-| 函数名 | 描述
| 输入 | 输出 | 用法 |
-| ---------------------------- |
------------------------------------------------------------ |
--------------------------- | ---------------------- | ---------- |
-| sin | 正弦函数
| double、float、INT64、INT32 | double | sin(x) |
-| cos | 余弦函数
| double、float、INT64、INT32 | double | cos(x) |
-| tan | 正切函数
| double、float、INT64、INT32 | double | tan(x) |
-| asin | 反正弦函数
| double、float、INT64、INT32 | double | asin(x) |
-| acos | 反余弦函数
| double、float、INT64、INT32 | double | acos(x) |
-| atan | 反正切函数
| double、float、INT64、INT32 | double | atan(x) |
-| sinh | 双曲正弦函数
| double、float、INT64、INT32 | double | sinh(x) |
-| cosh | 双曲余弦函数
| double、float、INT64、INT32 | double | cosh(x) |
-| tanh | 双曲正切函数
| double、float、INT64、INT32 | double | tanh(x) |
-| degrees | 将弧度角 x 转换为度
| double、float、INT64、INT32 | double | degrees(x) |
-| radians | 将度转换为弧度
| double、float、INT64、INT32 | double | radians(x) |
-| abs | 绝对值
| double、float、INT64、INT32 | 返回与输入类型相同的值 | abs(x) |
-| sign | 返回 x 的符号函数，即：如果参数为 0，则返回 0，如果参数大于 0，则返回
1，如果参数小于 0，则返回 -1。对于 double/float 类型的参数，函数还会返回：如果参数为 NaN，则返回 NaN，如果参数为
+Infinity，则返回 1.0，如果参数为 -Infinity，则返回 -1.0。 | double、float、INT64、INT32 |
返回与输入类型相同的值 | sign(x) |
-| ceil | 返回 x 向上取整到最近的整数。
| double、float、INT64、INT32 | double | ceil(x) |
-| floor | 返回 x 向下取整到最近的整数。
| double、float、INT64、INT32 | double | floor(x) |
-| exp | 返回欧拉数 e 的 x 次幂。
| double、float、INT64、INT32 | double | exp(x) |
-| ln | 返回 x 的自然对数。
| double、float、INT64、INT32 | double | ln(x) |
-| log10 | 返回 x 的以 10 为底的对数。
| double、float、INT64、INT32 | double | log10(x) |
-| round | 返回 x 四舍五入到最近的整数。
| double、float、INT64、INT32 | double | round(x) |
-| 返回 x 四舍五入到 d 位小数。 | double、float、INT64、INT32
| double | round(x, d) | |
-| sqrt | 返回 x 的平方根。
| double、float、INT64、INT32 | double | sqrt(x) |
-| e | 自然指数
| | double | e() |
-| pi | π
| | double | pi()
|
+| 函数名 | 描述
| 输入 | 输出 |
用法 |
+|-------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------|
---------------------- | ---------- |
+| sin | 正弦函数
| double、float、INT64、INT32 | double |
sin(x) |
+| cos | 余弦函数
| double、float、INT64、INT32 | double |
cos(x) |
+| tan | 正切函数
| double、float、INT64、INT32 | double |
tan(x) |
+| asin | 反正弦函数
| double、float、INT64、INT32 | double |
asin(x) |
+| acos | 反余弦函数
| double、float、INT64、INT32 | double |
acos(x) |
+| atan | 反正切函数
| double、float、INT64、INT32 | double |
atan(x) |
+| sinh | 双曲正弦函数
| double、float、INT64、INT32 | double |
sinh(x) |
+| cosh | 双曲余弦函数
| double、float、INT64、INT32 | double |
cosh(x) |
+| tanh | 双曲正切函数
| double、float、INT64、INT32 | double |
tanh(x) |
+| degrees | 将弧度角 x 转换为度
| double、float、INT64、INT32 | double |
degrees(x) |
+| radians | 将度转换为弧度
| double、float、INT64、INT32 | double |
radians(x) |
+| abs | 绝对值
| double、float、INT64、INT32 | 返回与输入类型相同的值 | abs(x)
|
+| sign | 返回 x 的符号函数，即：如果参数为 0，则返回 0，如果参数大于 0，则返回 1，如果参数小于 0，则返回
-1。对于 double/float 类型的参数，函数还会返回：如果参数为 NaN，则返回 NaN，如果参数为 +Infinity，则返回 1.0，如果参数为
-Infinity，则返回 -1.0。 | double、float、INT64、INT32 | 返回与输入类型相同的值 | sign(x)
|
+| ceil | 返回 x 向上取整到最近的整数。
| double、float、INT64、INT32 | double |
ceil(x) |
+| floor | 返回 x 向下取整到最近的整数。
| double、float、INT64、INT32 | double |
floor(x) |
+| exp | 返回欧拉数 e 的 x 次幂。
| double、float、INT64、INT32 | double |
exp(x) |
+| ln | 返回 x 的自然对数。
| double、float、INT64、INT32 | double |
ln(x) |
+| log10 | 返回 x 的以 10 为底的对数。
| double、float、INT64、INT32 | double |
log10(x) |
+| round | 返回 x 四舍五入到最近的整数。
| double、float、INT64、INT32 | double |
round(x) |
+| round | 返回 x 四舍五入到 d 位小数。
| double、float、INT64、INT32 | double
| round(x, d) |
+| sqrt | 返回 x 的平方根。
| double、float、INT64、INT32 | double |
sqrt(x) |
+| e | 自然指数
| | double |
e() |
+| pi | π
| | double |
pi() |
## 6. 条件表达式
