我参考这里面的存算一体部署 https://docs.starrocks.io/zh/docs/deployment/deploy_manually/
我有3台机器,第一个节点运行fe和be,另外两个节点只运行be,安装后我通过SHOW BACKENDS 看到3个be节点都是alive=true,LastHeartbeat都是当前时间,TabletNum第一个节点为15,后两个be节点的TabletNum均为0,然后:
1)运行CREATE TABLE test (id INT) 报错:
SQL 错误 [1064] [42000]: Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [11001,11002,12394]. , table=test, replication_num=3, default_replication_num=3
2)运行CREATE TABLE test (id INT) PROPERTIES( “replication_num” = “3” )报错:
SQL 错误 [1064] [42000]: Table replication num should be less than or equal to the number of available BE nodes. You can change this default by setting the replication_num table properties. Current alive backend is [11001,11002,12394]. , table=test, replication_num=3, default_replication_num=3
3)运行CREATE TABLE test (id INT) PROPERTIES( “replication_num” = “1” )就成功了
我的问题是,如果想要运行CREATE TABLE test (id INT) 成功,我需要做哪些操作?