Database, Data Engineering, Dbms, Data Modeling, Data Management.
auto-increment column. CREATE TABLE `demo`.`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" ); Apart from a key column, you can also specify a