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)