Overview
spill_compression_codec specifies the compression algorithm type to implement data spill compression during SQL execution.
Privilege requirements
Query parameters
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 use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | NONE: no compression. |
| Value range |
|
| 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
By specifying different compression algorithms in the configuration parameters, you can reduce the amount of space required for persisting temporary data during operator execution.
Configuration example
Specifies the data compression algorithm for disk I/O during SQL execution as LZ4.
obclient> ALTER SYSTEM SET spill_compression_codec='LZ4';