Also, ClickHouse is the only DBMS implementing aggregate function states as data types to allow them to be stored in tables, saved, loaded, and merged.

It allows incremental, continuous aggregate tables.

Other DBMSes like TimescaleDB implement a similar feature in a less generic way.