apache / apache/doris-website

Issue on docs data-model/unique

Open
#2,485 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
MDX
Stars
133
Forks
464
Avg merge
1d 1h
Merged PRs (30d)
50

Description

- Page Link: https://doris.apache.org/zh-CN/docs/table-design/data-model/unique

- Version: 2.1

- Reason: 缺少了一条限制条件 “使用Unique表时,为了保证数据的唯一性,distributed by字段中不能包含非Key列”。案例:当我用下面这个SQL建表时,会报错 “1105: errCode = 2, detailMessage = Distribution column[c3] is not key column”

```sql
CREATE TABLE t1 (`c1` INT NULL, `c2` INT NULL, `c3` INT NULL)
ENGINE = OLAP
UNIQUE KEY(`c1`, c2)
DISTRIBUTED BY HASH(`c2`, c3)
BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
```

- May I contribute to this pull request? Our company has been frequently using Doris lately. If given the chance, I would also like to gradually become involved in the community.(如果确认该Issue的话,可以由我来提交PR吗,我很希望参与到doris社区当中)

- ScreenShot:

![Image](https://github.com/user-attachments/assets/c83fcc2c-d5d5-45fc-9774-20bd327d4082)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.