Hi, does Pinot support query like this: “select count(case when boolean_field then id else null end) as cnt”, and “select * from table where nvl(field1, field2) < 100?

For the first one, pinot does not support

null

as value (it supports a special null index), so you can do

select sum(case when boolean_field then 1 else 0 end) as cnt

instead. And I think you can directly do

select sum(boolean_field) as cnt

because boolean type is stored as 1 and 0 internally.