CREATE TABLE user_back (
user_id int(11) NOT NULL,
brand int(11) NULL COMMENT '品牌',
user_name varchar(90) NULL
) ENGINE=OLAP
UNIQUE KEY(user_id, brand)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(user_id, brand) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"store_row_column" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);
INSERT INTO user_back (user_id,brand,user_name) VALUES (2,1,'erewtwt');
update user_back set user_name = '66666' where user_id =2 and brand =1;
