Note
For V4.3.0, this parameter is available starting with V4.3.0.
Description
default_table_store_format specifies the default table format for user tenants, including rowstore, columnstore, and hybrid rowstore-columnstore.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| 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. The setting takes effect immediately. |
Considerations
This parameter only affects the default table format for user tenants and has no effect on the Meta tenant or the
systenant.If you do not add the
with column groupclause when creating a columnstore table, the created table will be automatically set to rowstore, columnstore, or hybrid rowstore-columnstore mode.This parameter only takes effect if you do not add the
with column groupclause when creating a table. It has no effect on index tables.
Examples
This parameter is set to columnstore mode. When you create a table, the system automatically adds the
with column group(each column)clause.obclient> ALTER SYSTEM SET default_table_store_format = "column";This parameter is set to hybrid rowstore-columnstore mode. When you create a table, the system automatically adds the
with column group(all columns, each column)clause.obclient> ALTER SYSTEM SET default_table_store_format = "compound";