cockroach 基于hash分片数据

cockroach 基于hash分片数据

set experimental_enable_hash_sharded_indexes=on;
create table t1(a int,b int,c varchar(1000),primary key(a) using hash with bucket_count=3);
alter table t1 partition by list(dbms_internal_a_shard_12)
(
partition p1 values in (0),
partition p2 values in (1),
partition p3 values in (2)
);
alter partition p1 of table t1 CONFIGURE ZONE USING num_replicas = 3,constraints = '{"+nanjing":1,"+beijing":1,"+tianjin":1}', lease_preferences = '[[+beijing]]';
alter partition p2 of table t1 CONFIGURE ZONE USING num_num_replicas = 3,constraints = '{"+nanjing":1,"+beijing":1,"+tianjin":1}', lease_preferences = '[[+beijing]]';
alter partition p3 of table t1 CONFIGURE ZONE USING num_replicas = 3,constraints = '{"+nanjing":1,"+beijing":1,"+tianjin":1}', lease_preferences = '[[+beijing]]';