I have only 1 instance but getting a replication_num table error since the default of 3 is wrong

[atwong]

am getting following error on
database.go:1162 ExecContext —
Error 1064: Unexpected exception: 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 [10004]. , table=orders_tmp, default_replication_num=3
(venv) soumilshah@Soumils-MB

[atwong]

Run on the starrocks server to set the server variable.

ADMIN SET FRONTEND CONFIG ('default_replication_num' ="1");

or set it on table create.

create table xxx (id int) properties('replication_num' = '1')

[soumilshah1995]

Thanks this has helped to to solve my issue

Thanks Albert