Hi, Why do we use DISTINCTCOUNT instead of using COUNTDISTINCT here ?

distinctcount

is the name of the function that does exact distinct counting? https://docs.pinot.apache.org/configuration-reference/functions/distinctcount

Yes. That’s right. Does it name should be COUNTDISTINCT ?

Oh I see. yeh I'm not sure why the name is that way around, @User will probably know

It is there from PQL days. Now that we moved to SQL a while back, you can also use the sql syntax of count(distinct, …).

OKay. I see, thanks ~