This is an automated email from the ASF dual-hosted git repository. gabriellee pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push: new f0b9fd6af25 add crc32 docs (#907) f0b9fd6af25 is described below commit f0b9fd6af2583a51060edc9089da938549831cfa Author: Gabriel <gabrielleeb...@gmail.com> AuthorDate: Wed Oct 16 09:49:11 2024 +0800 add crc32 docs (#907) --- .../sql-functions/string-functions/crc32.md | 51 ++++++++++++++++++++ .../sql-functions/string-functions/crc32.md | 56 ++++++++++++++++++++++ .../sql-functions/string-functions/crc32.md | 56 ++++++++++++++++++++++ .../sql-functions/string-functions/crc32.md | 56 ++++++++++++++++++++++ sidebars.json | 1 + .../sql-functions/string-functions/crc32.md | 51 ++++++++++++++++++++ .../sql-functions/string-functions/crc32.md | 51 ++++++++++++++++++++ versioned_sidebars/version-2.1-sidebars.json | 1 + versioned_sidebars/version-3.0-sidebars.json | 1 + 9 files changed, 324 insertions(+) diff --git a/docs/sql-manual/sql-functions/string-functions/crc32.md b/docs/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..72014f77432 --- /dev/null +++ b/docs/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,51 @@ +--- +{ + "title": "CRC32", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +Use CRC32 to compute the result. + +### Syntax + +`BIGINT crc32 (VARCHAR str)` + + +Returns the Cyclic Redundancy Check value of this string. + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +``` + +### Keywords + CRC32 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/crc32.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..99b41ed6a5b --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,56 @@ +--- +{ + "title": "CRC32", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +使用CRC32算法计算结果。 + +### Syntax + +`BIGINT crc32(VARCHAR str)` + +返回字符串的CRC值。 + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +mysql> select crc32("中国"); ++-----------------+ +| crc32('中国') | ++-----------------+ +| 737014929 | ++-----------------+ +``` + +### Keywords + CRC32 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..99b41ed6a5b --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,56 @@ +--- +{ + "title": "CRC32", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +使用CRC32算法计算结果。 + +### Syntax + +`BIGINT crc32(VARCHAR str)` + +返回字符串的CRC值。 + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +mysql> select crc32("中国"); ++-----------------+ +| crc32('中国') | ++-----------------+ +| 737014929 | ++-----------------+ +``` + +### Keywords + CRC32 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..99b41ed6a5b --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,56 @@ +--- +{ + "title": "CRC32", + "language": "zh-CN" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +使用CRC32算法计算结果。 + +### Syntax + +`BIGINT crc32(VARCHAR str)` + +返回字符串的CRC值。 + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +mysql> select crc32("中国"); ++-----------------+ +| crc32('中国') | ++-----------------+ +| 737014929 | ++-----------------+ +``` + +### Keywords + CRC32 diff --git a/sidebars.json b/sidebars.json index c37f65878f8..52d7ab2bdbd 100644 --- a/sidebars.json +++ b/sidebars.json @@ -854,6 +854,7 @@ "sql-manual/sql-functions/string-functions/from-base64", "sql-manual/sql-functions/string-functions/ascii", "sql-manual/sql-functions/string-functions/auto_partition_name", + "sql-manual/sql-functions/string-functions/crc32", "sql-manual/sql-functions/string-functions/length", "sql-manual/sql-functions/string-functions/bit-length", "sql-manual/sql-functions/string-functions/char-length", diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..72014f77432 --- /dev/null +++ b/versioned_docs/version-2.1/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,51 @@ +--- +{ + "title": "CRC32", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +Use CRC32 to compute the result. + +### Syntax + +`BIGINT crc32 (VARCHAR str)` + + +Returns the Cyclic Redundancy Check value of this string. + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +``` + +### Keywords + CRC32 diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md new file mode 100644 index 00000000000..72014f77432 --- /dev/null +++ b/versioned_docs/version-3.0/sql-manual/sql-functions/string-functions/crc32.md @@ -0,0 +1,51 @@ +--- +{ + "title": "CRC32", + "language": "en" +} +--- + +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> + +### Description + +Use CRC32 to compute the result. + +### Syntax + +`BIGINT crc32 (VARCHAR str)` + + +Returns the Cyclic Redundancy Check value of this string. + +### Example + +```sql +mysql> select crc32("abc"); ++--------------+ +| crc32('abc') | ++--------------+ +| 891568578 | ++--------------+ + +``` + +### Keywords + CRC32 diff --git a/versioned_sidebars/version-2.1-sidebars.json b/versioned_sidebars/version-2.1-sidebars.json index bd64ed342a3..76b62fbaa37 100644 --- a/versioned_sidebars/version-2.1-sidebars.json +++ b/versioned_sidebars/version-2.1-sidebars.json @@ -801,6 +801,7 @@ "sql-manual/sql-functions/string-functions/from-base64", "sql-manual/sql-functions/string-functions/ascii", "sql-manual/sql-functions/string-functions/auto-partition-name", + "sql-manual/sql-functions/string-functions/crc32", "sql-manual/sql-functions/string-functions/length", "sql-manual/sql-functions/string-functions/bit-length", "sql-manual/sql-functions/string-functions/char-length", diff --git a/versioned_sidebars/version-3.0-sidebars.json b/versioned_sidebars/version-3.0-sidebars.json index 43388f5e583..c5c7894b8f4 100644 --- a/versioned_sidebars/version-3.0-sidebars.json +++ b/versioned_sidebars/version-3.0-sidebars.json @@ -845,6 +845,7 @@ "sql-manual/sql-functions/string-functions/from-base64", "sql-manual/sql-functions/string-functions/ascii", "sql-manual/sql-functions/string-functions/auto-partition-name", + "sql-manual/sql-functions/string-functions/crc32", "sql-manual/sql-functions/string-functions/length", "sql-manual/sql-functions/string-functions/bit-length", "sql-manual/sql-functions/string-functions/char-length", --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org