Note
For Vx.x.x, this parameter is available starting with Vx.x.x.
Description
default_table_store_format specifies the default table format for user tenants. The supported formats are rowstore, columnstore, and compound.
Privilege requirements
Query the parameter
systenants and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
systenants 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. It does not affect the Meta tenant or the sys tenant.
When a user tenant creates a columnstore table, the default table format can be specified as rowstore, columnstore, or compound without modifying the original CREATE TABLE statement.
This parameter only takes effect when the
with column groupclause is not specified in the CREATE TABLE statement. It does not take effect for index tables.
Examples
Specify the default table format for user tenants as columnstore. The
with column group(each column)clause is automatically added to the CREATE TABLE statement.obclient> ALTER SYSTEM SET default_table_store_format = "column";Specify the default table format for user tenants as compound. The
with column group(all columns, each column)clause is automatically added to the CREATE TABLE statement.obclient> ALTER SYSTEM SET default_table_store_format = "compound";