We can use an AggregatedMergeTree table engine, which can be used for a aggregating rows.
Generally in aggregated data we are not interested in storing all unique identifiers and still want to do a count distinct. Still we want to have the ability to do another aggregation to get unique count on these rows afterwards (trough grouping rows in a select query). This is where HyperLogLog comes in handy, wich is implemented as the uniqState function in clickhouse.
I would like to store a hyperloglog directly trough an insert query and offer it to a clickhouse table from my client application. Is this possible?