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/06/09 03:36:37 UTC
[GitHub] [incubator-doris] icedrugs89 opened a new issue, #10022: String Type should not be used in key column
icedrugs89 opened a new issue, #10022:
URL: https://github.com/apache/incubator-doris/issues/10022
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.1.0-preview2
### What's Wrong?
1、1.0.0版本创建表时，使用更新模型UNIQUE KEY的key类型为String是可以创建成功的，升级到1.1.0-preview2后，提示如下错误：
<img width="943" alt="image" src="https://user-images.githubusercontent.com/100941547/172758441-7c9c68a6-5f0a-4e4b-bc9c-a2821711228c.png">
### What You Expected?
UNIQUE KEY更新模型可以使用字符串作为索引列
### How to Reproduce?
CREATE TABLE `test02`(
`product_def_no` String COMMENT '产品定义号',
`id` varchar(100) COMMENT '物理主键',
`cust_source` varchar(100) COMMENT '客户渠道',
`cust_seg` String COMMENT '客户风险等级',
`pday` String
)
UNIQUE KEY(product_def_no,id,cust_source)
DISTRIBUTED BY HASH(product_def_no) BUCKETS 1
properties(
"replication_allocation"="tag.location.group_import:1, tag.location.group_normal_read:2"
)
### Anything Else?
_No response_
### Are you willing to submit PR?
- [X] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.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] [incubator-doris] icedrugs89 commented on issue #10022: String Type should not be used in key column
Posted by GitBox <gi...@apache.org>.
icedrugs89 commented on issue #10022:
URL: https://github.com/apache/incubator-doris/issues/10022#issuecomment-1150633806
`product_def_no` String类型 修改为varchar(100)可以解决
--
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