Enabling Live Aggregate Projections and Projections with Expressions
To create live aggregate and Top-K projections, or projections with expressions, the following configuration parameters must be set to 1 (default setting):
Configuration Parameter | Description | Enable | Disable |
---|---|---|---|
EnableGroupByProjections
|
Enables live aggregate projections | 1 | 0 |
EnableTopKProjections
|
Enables Top-K projections | 1 | 0 |
EnableExprsInProjections
|
Enables projections with expressions. | 1 | 0 |
To check current settings, use SHOW CURRENT
. For example:
=> SHOW CURRENT EnableGroupByProjections; level | name | setting ---------+--------------------------+--------- DEFAULT | EnableGroupByProjections | 1 (1 row)