use uniq for select

[amin-basiri]

i want to use uniq and uniqExact function on select

from clickhouse_backend import models


class Analytics(models.ClickhouseModel):
    aid = models.StringField(null=True)
    event_id = models.StringField(null=True)

   class Meta:
      db_table = "analytics"

and i want something like this:

SELECT uniq(aid) FROM analytics WHERE event_id = 'ksjfes'

or

SELECT count(uniq(aid)) FROM analytics WHERE event_id = 'ksjfes'

[jayvynl]

from clickhouse_backend.models import uniq
from django.db.models import Count

Analytics.objects.annotate(uniq_aid=uniq("aid"))

# You can try this
Analytics.objects.aggregate(count=Count(uniq("aid")))
# This may also work
Analytics.objects.aggregate(count=Count("aid", distinct=True))