System Table Fields

You can query the following system table fields for information about live aggregate projections, Top-K projections, and projections with expressions:

Table Fields
TABLES HAS_AGGREGATE_PROJECTION
PROJECTIONS AGGREGATE_TYPE
HAS_EXPRESSIONS
AGGREGATE_TYPE
 PROJECTION_COLUMNS COLUMN_EXPRESSION
IS_AGGREGATE
IS_EXPRESSION
ORDER_BY_POSITION
ORDER_BY_TYPE
PARTITION_BY_POSITION