Overview
default_table_store_format specifies the default format for creating tables in a user tenant, including row-store, pure columnar storage, and hybrid row-column storage.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | row |
| Value range | ('row', 'column', 'compound')
Note
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
This parameter only affects the default format for creating primary tables in user tenants and has no effect on Meta or sys tenants.
When you create a columnar table for a tenant, you can specify the default storage mode of the table as row-based, columnar, or hybrid row-column storage without modifying the original table creation statement.
This parameter takes effect only on statements that create tables without the
with column groupclause; it does not apply to index tables.
Configuration example
When you create a table in a user tenant, the default format is set to a pure columnar storage table. The
with column group(each column)clause is automatically added after the table creation statement.obclient> ALTER SYSTEM SET default_table_store_format = 'column';When you create a table in a user tenant, the default format is a redundant row-store columnar table. The
with column group(all columns, each column)clause is automatically added to the table creation statement.obclient> ALTER SYSTEM SET default_table_store_format = 'compound';
References
- Columnar storage
- Create a table