Rong Rong

oops. i meant to say `COUNT` instead of `SUM` in my previous comment for the non-null return. ^ but yes for these cases one row needs to be returned. consider...

> apologies missed this. Maybe the multi-stage engine supports this, but these are not valid queries at the moment in Pinot, so I don't think they apply. > yes they...

yes I agree with you @jadami10. i merely mentioned that - returning a single row of `0` for count - returning a single row of `null` for sum/min/max - i...

yeah also V2 is expecting the postgres behavior. because the same behavior occurs no matter the query is executed at top level or sub-query level. that's why I mentioned ```...

is this a duplicate of https://github.com/apache/pinot/issues/8045 or do we expect more / different from a DateTime type? specifically is it the binary compatibility with Hive's date datatype that we desire...

this should be mitigated by https://github.com/apache/pinot/pull/9582#discussion_r996227427 and should eventually be fixed systematically by addressing this issue: https://github.com/apache/pinot/issues/9611

readjusted the PR. PTAL

ah. ok i think this is indeed unexpected behavior. please let us know what your find in the log. thanks!

looks like the `pinot.server.instance.dataDir` extra config is conflicting with the definition in service's key `dataDir`. according to [kubernetes/helm/pinot/templates/server/configmap.yaml](https://github.com/apache/pinot/blob/287534262fd9ccd8507fd06efaec2dd14a4d29cf/kubernetes/helm/pinot/templates/server/configmap.yaml) you can see it appends both: ``` pinot.server.instance.dataDir={{ .Values.server.dataDir }} {{ .Values.server.extra.configs...

> We should add documentation and the logo as well and maybe take this out of draft mode for first feedback and testing. yes. will do once we get a...