Hi Everyone. I'm currently setting up a table that has a MV column called

items

containing a list of

item_id

. From what I've tried

distinctcounthllmv()

can't be used as an aggregated function in a star-tree index. Has anyone ever faced a similar problem? If yes how did you solved it? Is it possible to calculate the raw-hll state at ingestion time and then perform the estimation at query time? Thanks everyone for helping

Yes you can have an hll column in ingested data and can still query it using hll function

do you have any documentation on how to perform this?