Configuration Levels
SQream’s configuration parameters are based on the following hierarchy:
Cluster-Based Configuration
Cluster-based configuration lets you centralize configurations for all workers on the cluster. Only Regular and Cluster flag types can be modified on the cluster level. These modifications are persistent and stored at the metadata level, which are applied globally to all workers in the cluster.
Note
While cluster-based configuration was designed for configuring Workers, you can only configure Worker values set to the Regular or Cluster type.
Worker-Based Configuration
Worker-based configuration lets you modify individual workers using a worker configuration file. Worker-based configuration modifications are persistent.
Session-Based Configuration
Session-based configurations are not persistent and are deleted when your session ends. This method enables you to modify all required configurations while avoiding conflicts between flag attributes modified on different devices at different points in time. The SET flag_name command is used to modify flag values on the session level. Any modifications you make with the SET flag_name command apply only to your open session, and are not saved when it ends.
For example, when the query below has completed executing, the values configured will be restored to its previous setting:
set spoolMemoryGB=700;
select * from table a where date='2021-11-11'