hi, team, any insight on this SQL issue I am trying to use

distinctCount

aggregation function to count under different conditions

select distinctCount(case when condition1 then colA else null end) as condition1Count,
    distinctCount(case when condition2 then colA else null end) as condition2Count,
    distinctCount(case when condition3 then colA else null end) as condition3Count
from tableA

colA is type int or String. but looks like it’s not supported in pinot cause null is not supported in the selection query Will there be a future support for this.

It requires same type for functions to be applied. You can cast them to string always

do you mean change the

null

to

'null'

? I tried that by then

'null'

is counted as one distinct value

yes, right now the work around is to handle null as one distinct value. The real null support in aggregation function will be supported later

ok, thanks