search

Tencent / TBase

TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
Other
1.38k stars 261 forks source link

alter table test_update delete node report error: this operation is not permitted #63

Open l1t1 opened 4 years ago

l1t1 commented 4 years ago

create table test_update( id int,code int,primary key(id)); insert into test_update select id 100+code%100 ,id100+code%100 from generate_series(1,704754) id,generate_series(1,17) code;

test=# alter table test_update delete node(dn001); ERROR: this operation is not permitted

l1t1 commented 4 years ago

but in postgres xl, it works test=# alter table test_update delete node(dn1); ALTER TABLE Time: 38552.665 ms (00:38.553)

JennyJennyChen commented 4 years ago

In order to facilitate expansion, TBase modified PGXL and added a shard map layer. If you want to delete a node, you must move all shards on this node to other nodes and modify the shard routing information. This part is done through the management and control system, which is not open source for the time being