老师们好:
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]>
谢谢!