参数设置问题

Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221657910
Server version: OceanBase 4.3.5.6

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [SYS]> ALTER SYSTEM SET default_table_store_format = “column”;
OBE-00600: internal error code, arguments: -5023, Illegal type
obclient [SYS]> ALTER SYSTEM SET default_table_store_format = “compound”;
OBE-00600: internal error code, arguments: -5023, Illegal type
obclient [SYS]> ALTER SYSTEM SET default_table_store_format = “row”;
OBE-00600: internal error code, arguments: -5023, Illegal type

obclient [SYS]> show parameters like ‘default_table_store_format’\G
*************************** 1. row ***************************
ZONE: zone1
SVR_TYPE: observer
SVR_IP: 127.0.0.1
SVR_PORT: 2882
NAME: default_table_store_format
DATA_TYPE: STRING
VALUE: row
INFO: Specify the default storage format of creating table: row, column, compound format of row and columnvalues: row, column, compound
SECTION: TENANT
SCOPE: TENANT
SOURCE: DEFAULT
EDIT_LEVEL: DYNAMIC_EFFECTIVE
DEFAULT_VALUE: row
ISDEFAULT: 1
1 row in set (0.018 sec)

1 个赞

obclient [SYS]> ALTER SYSTEM SET default_table_store_format = ‘row’;
Query OK, 0 rows affected (0.044 sec)

obclient [SYS]> ALTER SYSTEM SET default_table_store_format = ‘column’;
Query OK, 0 rows affected (0.025 sec)

obclient [SYS]> ALTER SYSTEM SET default_table_store_format = ‘compound’;
Query OK, 0 rows affected (0.019 sec)

什么问题呢?具体说一下

参数值不能用双引号,要用单引号

文档应该是有问题 你发一下链接