This is an automated email from the ASF dual-hosted git repository.
lancelly pushed a commit to branch max_min_by
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
commit 613fc17ecb15ee92041ee94aa1fd74aa7796bb99
Author: lancelly <14...@qq.com>
AuthorDate: Wed Feb 28 16:52:05 2024 +0800
max_by_docs
---
.../Master/User-Manual/Operator-and-Expression.md | 34 +++++++++++-----------
.../latest/User-Manual/Operator-and-Expression.md | 34 +++++++++++-----------
2 files changed, 34 insertions(+), 34 deletions(-)
diff --git a/src/UserGuide/Master/User-Manual/Operator-and-Expression.md b/src/UserGuide/Master/User-Manual/Operator-and-Expression.md
index 4454f44..0a4d393 100644
--- a/src/UserGuide/Master/User-Manual/Operator-and-Expression.md
+++ b/src/UserGuide/Master/User-Manual/Operator-and-Expression.md
@@ -99,23 +99,23 @@ The built-in functions can be used in IoTDB without registration, and the functi
### Aggregate Functions
-| Function Name | Description | Allowed Input Series Data Types | Required Attributes | Output Series Data Type |
-| ------------- | ------------------------------------------------------------ | ------------------------------- | ------------------------------------------------------------ | ----------------------------------- |
-| SUM | Summation. | INT32 INT64 FLOAT DOUBLE | / | DOUBLE |
-| COUNT | Counts the number of data points. | All types | / | INT |
-| AVG | Average. | INT32 INT64 FLOAT DOUBLE | / | DOUBLE |
-| EXTREME | Finds the value with the largest absolute value. Returns a positive value if the maximum absolute value of positive and negative values is equal. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| MAX_VALUE | Find the maximum value. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| MIN_VALUE | Find the minimum value. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| FIRST_VALUE | Find the value with the smallest timestamp. | All data types | / | Consistent with input data type |
-| LAST_VALUE | Find the value with the largest timestamp. | All data types | / | Consistent with input data type |
-| MAX_TIME | Find the maximum timestamp. | All data Types | / | Timestamp |
-| MIN_TIME | Find the minimum timestamp. | All data Types | / | Timestamp |
-| COUNT_IF | Find the number of data points that continuously meet a given condition and the number of data points that meet the condition (represented by keep) meet the specified threshold. | BOOLEAN | `[keep >=/>/=/!=/</<=]threshold`：The specified threshold or threshold condition, it is equivalent to `keep >= threshold` if `threshold` is used alone, type of `threshold` is `INT64` `ignoreNull`：Optional, default value is `true`；If the value is `true`, null va [...]
-| TIME_DURATION | Find the difference between the timestamp of the largest non-null value and the timestamp of the smallest non-null value in a column | All data Types | / | INT64 |
-| MODE | Find the mode. Note: 1.Having too many different values in the input series risks a memory exception; 2.If all the elements have the same number of occurrences, that is no Mode, return the value with earliest time; 3.If there are many Modes, return the Mode with earliest time. | All data Types | / | Consistent with the input data type |
-| MAX_BY | MAX_BY(x, y) returns the value of x corresponding to the maximum value of the input y. MAX_BY(time, x) returns the timestamp when x is at its maximum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | Consistent with the data type of the first input x. |
-| MIN_BY | MIN_BY(x, y) returns the value of x corresponding to the minimum value of the input y. MIN_BY(time, x) returns the timestamp when x is at its minimum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | Consistent with the data type of the first input x. |
+| Function Name | Description | Allowed Input Series Data Types | Required Attributes [...]
+| ------------- | ------------------------------------------------------------ | ------------------------------- |------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ [...]
+| SUM | Summation. | INT32 INT64 FLOAT DOUBLE | / [...]
+| COUNT | Counts the number of data points. | All types | / [...]
+| AVG | Average. | INT32 INT64 FLOAT DOUBLE | / [...]
+| EXTREME | Finds the value with the largest absolute value. Returns a positive value if the maximum absolute value of positive and negative values is equal. | INT32 INT64 FLOAT DOUBLE | / [...]
+| MAX_VALUE | Find the maximum value. | INT32 INT64 FLOAT DOUBLE | / [...]
+| MIN_VALUE | Find the minimum value. | INT32 INT64 FLOAT DOUBLE | / [...]
+| FIRST_VALUE | Find the value with the smallest timestamp. | All data types | / [...]
+| LAST_VALUE | Find the value with the largest timestamp. | All data types | / [...]
+| MAX_TIME | Find the maximum timestamp. | All data Types | / [...]
+| MIN_TIME | Find the minimum timestamp. | All data Types | / [...]
+| COUNT_IF | Find the number of data points that continuously meet a given condition and the number of data points that meet the condition (represented by keep) meet the specified threshold. | BOOLEAN | `[keep >=/>/=/!=/</<=]threshold`：The specified threshold or threshold condition, it is equivalent to `keep >= threshold` if `threshold` is used alone, type of `threshold` is `INT64` `ignoreNull`：Optional, default value is `true`；If the value is `true`, null va [...]
+| TIME_DURATION | Find the difference between the timestamp of the largest non-null value and the timestamp of the smallest non-null value in a column | All data Types | / [...]
+| MODE | Find the mode. Note: 1.Having too many different values in the input series risks a memory exception; 2.If all the elements have the same number of occurrences, that is no Mode, return the value with earliest time; 3.If there are many Modes, return the Mode with earliest time. | All data Types | / [...]
+| MAX_BY | MAX_BY(x, y) returns the value of x corresponding to the maximum value of the input y. MAX_BY(time, x) returns the timestamp when x is at its maximum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | \ [...]
+| MIN_BY | MIN_BY(x, y) returns the value of x corresponding to the minimum value of the input y. MIN_BY(time, x) returns the timestamp when x is at its minimum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | \ | Consistent with the data type of the first input x. |
For details and examples, see the document [Aggregate Functions](../Operators-Functions/Aggregation.md).
diff --git a/src/UserGuide/latest/User-Manual/Operator-and-Expression.md b/src/UserGuide/latest/User-Manual/Operator-and-Expression.md
index 4ca8bf8..ded3567 100644
--- a/src/UserGuide/latest/User-Manual/Operator-and-Expression.md
+++ b/src/UserGuide/latest/User-Manual/Operator-and-Expression.md
@@ -99,23 +99,23 @@ The built-in functions can be used in IoTDB without registration, and the functi
### Aggregate Functions
-| Function Name | Description | Allowed Input Series Data Types | Required Attributes | Output Series Data Type |
-|---------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| ------------------------------- | ------------------------------------------------------------ | ----------------------------------- |
-| SUM | Summation. | INT32 INT64 FLOAT DOUBLE | / | DOUBLE |
-| COUNT | Counts the number of data points. | All types | / | INT |
-| AVG | Average. | INT32 INT64 FLOAT DOUBLE | / | DOUBLE |
-| EXTREME | Finds the value with the largest absolute value. Returns a positive value if the maximum absolute value of positive and negative values is equal. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| MAX_VALUE | Find the maximum value. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| MIN_VALUE | Find the minimum value. | INT32 INT64 FLOAT DOUBLE | / | Consistent with the input data type |
-| FIRST_VALUE | Find the value with the smallest timestamp. | All data types | / | Consistent with input data type |
-| LAST_VALUE | Find the value with the largest timestamp. | All data types | / | Consistent with input data type |
-| MAX_TIME | Find the maximum timestamp. | All data Types | / | Timestamp |
-| MIN_TIME | Find the minimum timestamp. | All data Types | / | Timestamp |
-| COUNT_IF | Find the number of data points that continuously meet a given condition and the number of data points that meet the condition (represented by keep) meet the specified threshold. | BOOLEAN | `[keep >=/>/=/!=/</<=]threshold`：The specified threshold or threshold condition, it is equivalent to `keep >= threshold` if `threshold` is used alone, type o [...]
-| TIME_DURATION | Find the difference between the timestamp of the largest non-null value and the timestamp of the smallest non-null value in a column | All data Types | / | INT64 |
-| MODE | Find the mode. Note: 1.Having too many different values in the input series risks a memory exception; 2.If all the elements have the same number of occurrences, that is no Mode, return the value with earliest time; 3.If there are many Modes, return the Mode with earliest time. | All data Types | / | Consistent with the input data type |
-| MAX_BY | MAX_BY(x, y) returns the value of x corresponding to the maximum value of the input y. MAX_BY(time, x) returns the timestamp when x is at its maximum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | Consistent with the data type of the first input x. |
-| MIN_BY | MIN_BY(x, y) returns the value of x corresponding to the minimum value of the input y. MIN_BY(time, x) returns the timestamp when x is at its minimum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | Consistent with the data type of the first input x. |
+| Function Name | Description | Allowed Input Series Data Types | Required Attributes [...]
+|---------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| ------------------------------- |-------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| SUM | Summation. | INT32 INT64 FLOAT DOUBLE | / [...]
+| COUNT | Counts the number of data points. | All types | / [...]
+| AVG | Average. | INT32 INT64 FLOAT DOUBLE | / [...]
+| EXTREME | Finds the value with the largest absolute value. Returns a positive value if the maximum absolute value of positive and negative values is equal. | INT32 INT64 FLOAT DOUBLE | / [...]
+| MAX_VALUE | Find the maximum value. | INT32 INT64 FLOAT DOUBLE | / [...]
+| MIN_VALUE | Find the minimum value. | INT32 INT64 FLOAT DOUBLE | / [...]
+| FIRST_VALUE | Find the value with the smallest timestamp. | All data types | / [...]
+| LAST_VALUE | Find the value with the largest timestamp. | All data types | / [...]
+| MAX_TIME | Find the maximum timestamp. | All data Types | / [...]
+| MIN_TIME | Find the minimum timestamp. | All data Types | / [...]
+| COUNT_IF | Find the number of data points that continuously meet a given condition and the number of data points that meet the condition (represented by keep) meet the specified threshold. | BOOLEAN | `[keep >=/>/=/!=/</<=]threshold`：The specified threshold or threshold condition, it is equivalent to `keep >= threshold` if `threshold` is used alone, type o [...]
+| TIME_DURATION | Find the difference between the timestamp of the largest non-null value and the timestamp of the smallest non-null value in a column | All data Types | / [...]
+| MODE | Find the mode. Note: 1.Having too many different values in the input series risks a memory exception; 2.If all the elements have the same number of occurrences, that is no Mode, return the value with earliest time; 3.If there are many Modes, return the Mode with earliest time. | All data Types | / [...]
+| MAX_BY | MAX_BY(x, y) returns the value of x corresponding to the maximum value of the input y. MAX_BY(time, x) returns the timestamp when x is at its maximum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | / [...]
+| MIN_BY | MIN_BY(x, y) returns the value of x corresponding to the minimum value of the input y. MIN_BY(time, x) returns the timestamp when x is at its minimum value. | The first input x can be of any type, while the second input y must be of type INT32, INT64, FLOAT, or DOUBLE. | / | Consistent with the data type of the first input x. |
For details and examples, see the document [Aggregate Functions](../Operators-Functions/Aggregation.md).