Database, Data Engineering, Dbms, Data Modeling, Data Management.
value column as an auto-increment column (example below): CREATE TABLE `demo`.`tbl` ( `uid` BIGINT NOT NULL, `name` BIGINT NOT NULL, `id` BIGINT NOT NULL AUTO_INCREMENT, `value` BIGINT NOT NULL ) ENGINE=OLAP DUPLICATE KEY(`uid`, `name`) DISTRIBUTED BY HASH(`uid`) BUCKETS 10 PROPERTIES (