I want to get the sum of distinct values from my ksql table.
I couldn’t find Distinct Aggregate Function in the docs and I tried to reach the same conclusion with this query:
SUM(TOPKDISTINCT(Price, COUNT_DISTINCT(Price))) but then I got this error that inditaces nested aggregates are completely forbidden
Aggregate functions can not be nested: SUM(TOPKDISTINCT())
It looks like a basic sql query but is it possible to try this query against a ksql table?
Any info would be great.
Thanks in advance