https://pinot.apache.org/ logo
#general
Title
# general
m

Minglei Zhang

02/21/2022, 12:44 PM
Hi, Why do we use DISTINCTCOUNT instead of using COUNTDISTINCT here ?
m

Mark Needham

02/21/2022, 12:47 PM
distinctcount
is the name of the function that does exact distinct counting? https://docs.pinot.apache.org/configuration-reference/functions/distinctcount
m

Minglei Zhang

02/21/2022, 12:54 PM
Yes. That’s right. Does it name should be COUNTDISTINCT ?
m

Mark Needham

02/21/2022, 12:55 PM
Oh I see. yeh I'm not sure why the name is that way around, @User will probably know
m

Mayank

02/21/2022, 2:45 PM
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, …).
m

Minglei Zhang

02/22/2022, 3:56 AM
OKay. I see, thanks ~