You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "egalpin (via GitHub)" <gi...@apache.org> on 2023/06/02 22:18:55 UTC
[GitHub] [pinot] egalpin opened a new issue, #10838: Cannot group-by MV column with projection
egalpin opened a new issue, #10838:
URL: https://github.com/apache/pinot/issues/10838
Assuming that `myMVdateTimeCol` is an MV column of type `LONG`, the following will fail with a NullPointerException (root cause: `ProjectionOperator` is used rather than `GroupByOperator`, where `ProjectionOperator` which eventually causes a call to `FixedByteMVMutableForwardIndex#readDictIds` which throws `UnsupportedOperationException` from the default impl on the `MutableForwardIndex` interface).
```sql
SELECT
TODATETIME("myMVdateTimeCol", 'e:HH:mm:ss', 'UTC') as myTransformedVal,
count(1) as _count
FROM
myTable
GROUP BY
myTransformedVal
```
However, if the same query is executed without `TODATETIME` in the projection, it succeeds.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] egalpin commented on issue #10838: Cannot group-by MV column with transformation in projection
Posted by "egalpin (via GitHub)" <gi...@apache.org>.
egalpin commented on issue #10838:
URL: https://github.com/apache/pinot/issues/10838#issuecomment-1575080284
This actually just requires that there be `MV` variants of the transforms. I'll open a PR next week to add a few that I'm interested in.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] Jackie-Jiang closed issue #10838: Cannot group-by MV column with transformation in projection
Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang closed issue #10838: Cannot group-by MV column with transformation in projection
URL: https://github.com/apache/pinot/issues/10838
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org