morrySnow commented on code in PR #1852: URL: https://github.com/apache/doris-website/pull/1852#discussion_r1920104043
########## docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-from-string.md: ########## @@ -22,42 +22,62 @@ specific language governing permissions and limitations under the License. --> -## bitmap_from_string +## Description -### description -#### Syntax +Convert a string into a BITMAP. The string consists of a group of unsigned bigint numbers separated by commas. (The number values are between: 0 ~ 18446744073709551615) +For example, the string "0, 1, 2" will be converted into a Bitmap, where the 0th, 1st, and 2nd bits are set. When the input field is invalid, NULL is returned -`BITMAP BITMAP_FROM_STRING(VARCHAR input)` +## Syntax -Convert a string into a bitmap. The input string should be a comma separated unsigned bigint (ranging from 0 to 18446744073709551615). -For example: input string "0, 1, 2" will be converted to a Bitmap with bit 0, 1, 2 set. -If input string is invalid, return NULL. +```sql + BITMAP_FROM_STRING(<str>) +``` + +## Parameters + +| Parameter | Description | +|-----------|------------------------------------------------------------------------------------------------| +| `<str>` | Array string, for example "0, 1, 2" string will be converted to a Bitmap with bits 0, 1, 2 set | +## Return Value Review Comment: 中间加个空行,防止渲染错误 ########## docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-and-count.md: ########## @@ -24,61 +24,74 @@ specific language governing permissions and limitations under the License. --> -## bitmap_and_count -### description -#### Syntax +## Description -`BigIntVal bitmap_and_count(BITMAP lhs, BITMAP rhs, ...)` +Computes the intersection of two or more input BITMAPs and returns the number of intersections. -Calculate the intersection of two or more input bitmaps and return the number of intersections. - -### example +## Syntax +```sql +BITMAP_AND_COUNT(<bitmap>, <bitmap>,[, <bitmap>...]) ``` -MySQL> select bitmap_and_count(bitmap_from_string('1,2,3'),bitmap_empty()); -+---------------------------------------------------------------+ -| bitmap_and_count(bitmap_from_string('1,2,3'), bitmap_empty()) | -+---------------------------------------------------------------+ -| 0 | -+---------------------------------------------------------------+ +## Parameters -MySQL> select bitmap_and_count(bitmap_from_string('1,2,3'),bitmap_from_string('1,2,3')); -+----------------------------------------------------------------------------+ -| bitmap_and_count(bitmap_from_string('1,2,3'), bitmap_from_string('1,2,3')) | -+----------------------------------------------------------------------------+ -| 3 | -+----------------------------------------------------------------------------+ +| Parameter | Description | +|------------|----------------------------------------------------------------| +| `<bitmap>` | One of the original BITMAPs whose intersection is being sought | + +## Return Value +Returns an integer +- If the parameter has a null value, it returns NULL + +## Examples + +```sql MySQL> select bitmap_and_count(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')); Review Comment: 需要去掉 prompt ```suggestion select bitmap_and_count(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')); ``` -- 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