Using hll_cardinality(hll_union_agg(users)) with OVER partition by

[Dagnan]

Hi, There is an example about using #hll_union_agg(users) OVER (ORDER BY date ASC ROWS 6 PRECEDING).

However if I try to use it with OVER(partition by date) it does not work: ERROR: column "users" must appear in the GROUP BY clause or be used in an aggregate function.

[ghost]

Hi @Dagnan, could you please provide the whole query you're running? Not sure thatI can help with the information you've provided.

[Dagnan]

Hi. I'm sorry I'm not using postgres-hll directly but I think the request itself was SELECT #hll_union_agg(users) OVER (ORDER BY date ASC ROWS 6 PRECEDING).