Aggregation information in system tables

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

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

Table	Fields
`TABLES`	`TABLE_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`