morrySnow commented on code in PR #1825: URL: https://github.com/apache/doris-website/pull/1825#discussion_r1924804314
########## docs/sql-manual/sql-functions/aggregate-functions/intersect-count.md: ########## @@ -24,49 +24,55 @@ under the License. ## Description -The INTERSECT_COUNT function is used to calculate the number of intersecting elements of the Bitmap data structure. +Calculate the intersection of two or more bitmaps +Usage: intersect_count(bitmap_column_to_count, filter_column, filter_values ...) +Example: intersect_count(user_id, event, 'A', 'B', 'C'), meaning find the intersect count of user_id in all A/B/C 3 bitmaps +Calculate the intersection count of elements in bitmap_column that match column_to_filter within filter_values, i.e., bitmap intersection count. ## Syntax ```sql -INTERSECT_COUNT(<bitmap_column>, <column_to_filter>, <filter_values>) +INTERSECT_COUNT(<bitmap_column>, <column_to_filter>, <filter_values> [, ...]) ``` -## Parameters +## Parameters -| Parameters | Description | -| -- | -- | -| `<bitmap_column>` | The expression that needs to be obtained. | -| `<column_to_filter>` | The dimension column that needs to be filtered. | -| `<filter_values>` | Different values of the filtering dimension column. | +| Parameter | Description | +|------------------|--------------------------------------------------| +| `bitmap_column` | The input bitmap parameter column | +| `column_to_filter` | The dimension column used for filtering | +| `filter_values` | The different values used to filter the dimension column | Review Comment: ```suggestion | `<bitmap_column>` | The input bitmap parameter column | | `<column_to_filter>` | The dimension column used for filtering | | `<filter_values>` | The different values used to filter the dimension column | ``` ########## docs/sql-manual/sql-functions/scalar-functions/numeric-functions/abs.md: ########## @@ -22,46 +22,61 @@ specific language governing permissions and limitations under the License. --> -## abs -### description -#### Syntax +## Description + +Returns the absolute value of `x` + +## Syntax ```sql -SMALLINT abs(TINYINT x) -INT abs(SMALLINT x) -BIGINT abs(INT x) -LARGEINT abs(BIGINT x) -LARGEINT abs(LARGEINT x) -DOUBLE abs(DOUBLE x) -FLOAT abs(FLOAT x) -DECIMAL abs(DECIMAL x)` +ABS(<x>) ``` -Returns the absolute value of `x`. +## Parameters + +| Parameter | Description | +| -- | -- | +| x | The value for which the absolute value is to be calculated | Review Comment: ```suggestion | `<x>` | The value for which the absolute value is to be calculated | ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
