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. The supported table formats are rowstore, columnstore, and compound.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.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. It does not affect the Meta tenant or the sys tenant.
When a user tenant creates a columnstore table, the table 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
The default table format for user tenants is set to 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";The default table format for user tenants is set to 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";