OceaseBase的数据分片

老师们好:
OceanBase的数据分散在多台服务器上存储,是通过表分区的方式,还是通过表分片的方式呢?在社区版4.0上测试了下分片的建表语法报错:
obclient [oceanbase]> CREATE TABLE mytable (
→ id INT PRIMARY KEY,
→ name VARCHAR(255),
→ age INT
→ )
→ DISTRIBUTED BY HASH(id) BUCKETS 16;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near ‘DISTRIBUTED BY HASH(id) BUCKETS 16’ at line 6
obclient [oceanbase]>

谢谢!

你先了解下OceanBase 数据库的分区介绍和分区类型 https://www.oceanbase.com/docs/community-observer-cn-10000000000901593

你这是创建分区表语法错了,参考上面这位同学发的文档试试呢

也就是OceanBase数据分布式存储是通过分区,而不是通过分片这种方式?

OB里面是以分区形式来的,按分区的粒度自动均衡到不同的OBServer节点,打散数据