使用DROPP可以正常删除节点,但是这会丢失数据。
因此,根据官方的建议,采用DECOMMISSION下线节点。但是下线时遇到问题,执行DECOMMISSION返回如下错误:
ERROR 1105 (HY000): errCode = 2, detailMessage = After decommission, partition column_statistics of table __internal_schema.column_statistics 's replication allocation { tag.location.default: 3 } > available backend num 1 on tag {"location" : "default"}, otherwise need to decrease the partition's replication num.