Note
This parameter is introduced since OceanBase Database V4.3.0.
Purpose
The default_table_store_format parameter specifies the default format for a table created in a user tenant, which can be a rowstore table, columnstore table, or rowstore-columnstore redundant table.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | String |
| Default value | row |
| Value range | ("row", "column", "compound")
Note
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Considerations
This parameter is valid only for user tenants and does not affect meta tenants or the sys tenant.
When you create a table in a user tenant, you can directly specify the default format of the table as rowstore, columnstore, or rowstore-columnstore redundant without modifying the original table creation statement.
This parameter takes effect only for table creation statements without a
with column groupclause, and is invalid for index tables.
Examples
Set the default table format to
columnfor a user tenant. Thewith column group(each column)clause is automatically appended to the table creation statement.obclient> ALTER SYSTEM SET default_table_store_format = "column";Set the default table format to
compoundfor a user tenant. Thewith column group(all columns, each column)clause is automatically appended to the table creation statement.obclient> ALTER SYSTEM SET default_table_store_format = "compound";