edg956 commented on issue #17701:
URL: https://github.com/apache/pinot/issues/17701#issuecomment-3923077762
@Jackie-Jiang @gortiz @yashmayya here's the exception for the second query
```
Error Code: 720
QueryPlanningError:
Error composing query plan for: select
sum(case when (cast(age as float) < 35.0) then 1 else 0 end) as
age_group_1,
sum(case when (cast(age as float) >= 35.0 and cast(age as float) <
45.0) then 1 else 0 end) age_group_2,
sum(case when (cast(age as float) >= 45.0) then 1 else 0 end)
age_group_3
from profiler_test_table;
org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:138)
org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:158)
org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:133)
org.apache.pinot.broker.requesthandler.BrokerRequestHandlerDelegate.handleRequest(BrokerRequestHandlerDelegate.java:86)
class org.apache.calcite.rex.RexCall cannot be cast to class
org.apache.calcite.rex.RexInputRef (org.apache.calcite.rex.RexCall and
org.apache.calcite.rex.RexInputRef are in unnamed module of loader 'app')
org.apache.pinot.query.planner.logical.RexExpressionUtils.handleSearch(RexExpressionUtils.java:173)
org.apache.pinot.query.planner.logical.RexExpressionUtils.fromRexCall(RexExpressionUtils.java:133)
org.apache.pinot.query.planner.logical.RexExpressionUtils.fromRexNode(RexExpressionUtils.java:58)
org.apache.pinot.query.planner.logical.RexExpressionUtils.fromRexNodes(RexExpressionUtils.java:67)
```
I should say that I just tested all queries with multi-stage engine off and
they worked, but since we use queries that are only supported by the
multi-stage engine I discarded that option.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
