创建表时 自增ID出现错误

👨🏻‍💻 技术问答
1

doris版本： 2.0.4
创建脚本如下:
CREATE TABLE tbl (
id BIGINT NOT NULL AUTO_INCREMENT,
value BIGINT NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
“replication_allocation” = “tag.location.default: 3”
);

SQL错误（1105）：errCode = 2, detailMessage = auto increment column is not supported currently.

2

2.1才支持，或者自己编译master