SELECTDB创建Doris表失败, auto increment column is not supported currently

Viewed 32

CREATE TABLE IF NOT EXISTS env_system_dev.sys_access_type (
id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
type_name VARCHAR(135) NOT NULL COMMENT '接入类型名称',
create_user INT NULL COMMENT '创建者',
update_user INT NULL COMMENT '更新者',
create_time datetimev2 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time datetimev2 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
description VARCHAR(384) NULL COMMENT '描述',
is_delete TINYINT NOT NULL DEFAULT "0" COMMENT '是否已删除,0:未删除,1:已删除'
) ENGINE=OLAP
UNIQUE KEY(id)
COMMENT '系统接入类型表'
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
图片.png

1 Answers

自增列是在2.1才开始支持的