Hi Pinot Community. It seems the CASE WHEN query has a bug in 0.10.0 (it was working in 0.9.3). I have created an issue: https://github.com/apache/pinot/issues/8996, also post here to keep everyone updated

Thanks for reporting.