siddharthteotia opened a new issue, #10677:
URL: https://github.com/apache/pinot/issues/10677
Creating this to track an issue received in user feedback. Yet to take a look
Query
```
SET useMultistageEngine=true;
select orderID, max(cast(updatedTime as DOUBLE)) over(partition by orderID)
from foodOrderFact;
```
Broker Exception
```
[
{
"message": "QueryExecutionError:\njava.lang.RuntimeException: Received
error query execution result block: {1000=Incompatible selection result data
schema: Expected: [orderID(STRING),EXPR$1(DOUBLE)]. Actual:
[max_cast(updatedTime,'DOUBLE')(DOUBLE)]\njava.lang.IllegalStateException:
Incompatible selection result data schema: Expected:
[orderID(STRING),EXPR$1(DOUBLE)]. Actual:
[max_cast(updatedTime,'DOUBLE')(DOUBLE)]\n\tat
org.apache.pinot.shaded.com.google.common.base.Preconditions.checkState(Preconditions.java:444)\n\tat
org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeAggregationTransferableBlock(LeafStageTransferableBlockOperator.java:185)\n\tat
org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeTransferableBlock(LeafStageTransferableBlockOperator.java:125)",
"errorCode": 200
}
]
```
Server Exception:
```
(OpChain{7_1}): Completed erroneously (7_1) Queued Count: 2, Executing Time:
0ms, Queued Time: 16ms {1000=Incompatible selection result data schema:
Expected: [orderID(STRING),EXPR$1(DOUBLE)]. Actual:
[max_cast(updatedTime,'DOUBLE')(DOUBLE)]
java.lang.IllegalStateException: Incompatible selection result data schema:
Expected: [orderID(STRING),EXPR$1(DOUBLE)]. Actual:
[max_cast(updatedTime,'DOUBLE')(DOUBLE)]
at
org.apache.pinot.shaded.com.google.common.base.Preconditions.checkState(Preconditions.java:444)
at
org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeAggregationTransferableBlock(LeafStageTransferableBlockOperator.java:185)
at
org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeTransferableBlock(LeafStageTransferableBlockOperator.java:125)
at
org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.getNextBlock(LeafStageTransferableBlockOperator.java:97)}
```
--
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]
