[GitHub] [incubator-doris] icedrugs89 opened a new issue, #10022: String Type should not be used in key column

[GitBox]

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-unsubscr...@doris.apache.org.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