Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

String Type should not be used in key column #10022

Open
3 tasks done
icedrugs89 opened this issue Jun 9, 2022 · 1 comment
Open
3 tasks done

String Type should not be used in key column #10022

icedrugs89 opened this issue Jun 9, 2022 · 1 comment

Comments

@icedrugs89
Copy link

Search before asking

  • I had searched in the issues 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后,提示如下错误:
image

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?

  • Yes I am willing to submit a PR!

Code of Conduct

@icedrugs89
Copy link
Author

product_def_no String类型 修改为varchar(100)可以解决

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant