You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/08/17 15:51:40 UTC
[GitHub] [doris] a19920714liou opened a new pull request, #11878: [doc](fix) Add string to create table column_type
a19920714liou opened a new pull request, #11878:
URL: https://github.com/apache/doris/pull/11878
# Proposed changes
Issue Number: close #xxx
## Problem summary
Add string to create table column_type.
## Checklist(Required)
1. Does it affect the original behavior:
- [ ] Yes
- [x] No
- [ ] I don't know
2. Has unit tests been added:
- [ ] Yes
- [x] No
- [ ] No Need
3. Has document been added or modified:
- [x] Yes
- [ ] No
- [ ] No Need
4. Does it need to update dependencies:
- [ ] Yes
- [x] No
5. Are there any changes that cannot be rolled back:
- [ ] Yes (If Yes, please explain WHY)
- [x] No
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] stalary commented on a diff in pull request #11878: [doc](fix) Add string to create table column_type
Posted by GitBox <gi...@apache.org>.
stalary commented on code in PR #11878:
URL: https://github.com/apache/doris/pull/11878#discussion_r948547814
##########
docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md:
##########
@@ -91,6 +91,8 @@ distribution_info
定长字符串。长度范围：1 ~ 255。默认为1
VARCHAR[(length)]
变长字符串。长度范围：1 ~ 65533。默认为1
+ STRING
+ 变长字符串。最大（默认）支持1048576 字节（1MB）。String类型的长度还受 be 配置 `string_type_length_soft_limit_bytes`, 实际能存储的最大长度 取两者最小值，String类型只能用在value 列，不能用在 key 列和分区 分桶列
Review Comment:
```suggestion
STRING（M）
变长字符串。最大（默认）支持 1048576 字节（1MB）。String 类型的长度还受 be 中`string_type_length_soft_limit_bytes`参数控制, 实际能存储的最大长度取两者最小值，String类型只能用在 value 列，不能用在 key 列和分区/分桶列
```
##########
docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md:
##########
@@ -91,6 +91,8 @@ distribution_info
Fixed-length character string. Length range: 1 ~ 255. Default is 1
VARCHAR[(length)]
Variable length character string. Length range: 1 ~ 65533. Default is 1
+ STRING (M)
+ Variable length character string. Max legnth(default) is 1048576(1MB). The length of the String type is also limited by the configuration string_type_length_soft_limit_bytes of be, the actual maximum length that can be stored take the minimum value of both, the String type can only be used in the value column, not in the key column and the partition and bucket columns
Review Comment:
```suggestion
Variable length character string. Max legnth(default) is 1048576 byte(1MB). The length of the String type is also limited by the configuration `string_type_length_soft_limit_bytes` of be, the actual maximum length that can be stored take the minimum value of both, the String type can only be used in the value column, not in the key column and the partition and bucket columns
```
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] a19920714liou closed pull request #11878: [doc](fix) Add string to create table column_type
Posted by GitBox <gi...@apache.org>.
a19920714liou closed pull request #11878: [doc](fix) Add string to create table column_type
URL: https://github.com/apache/doris/pull/11878
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org