Note
For V4.3.1, this parameter is available starting with V4.3.1.
Description
spill_compression_codec specifies the compression algorithm for data spilling during SQL execution.
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 use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | NONE, indicating no compression. |
| Value range |
|
| 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
Specify different compression algorithms to reduce the space required for temporary data spilling during operator execution.
Examples
Set the compression algorithm for data spilling during SQL execution to LZ4.
obclient> ALTER SYSTEM SET spill_compression_codec='LZ4';