saurabhd336 opened a new pull request, #11387: URL: https://github.com/apache/pinot/pull/11387
``` SELECT CAST(TIMESTAMPADD(DAY, 1, "Calcs"."date2") AS TIMESTAMP) AS "TEMP_Test__670684053__0_" FROM "Calcs" GROUP BY "TEMP_Test__670684053__0_" ``` seems to fail with ``` "errorCode": 200, "message": "QueryExecutionError:\njava.lang.RuntimeException: Error executing query: [0]@127.0.0.1:64177 MAIL_RECEIVE(RANDOM_DISTRIBUTED)\n└── [1]@127.0.0.1:64185 MAIL_SEND(RANDOM_DISTRIBUTED)->{[0]@127.0.0.1@{64177,64177}|[0]}\n └── [1]@127.0.0.1:64185 AGGREGATE_FINAL\n └── [1]@127.0.0.1:64185 MAIL_RECEIVE(HASH_DISTRIBUTED)\n └── [2]@127.0.0.1:64185 MAIL_SEND(HASH_DISTRIBUTED)->{[1]@127.0.0.1@{64185,64186}|[0]}\n...\nCaused by: java.lang.RuntimeException: Received error query execution result block: {1000=Incompatible selection result data schema: Expected: [TEMP_Test__670684053__0_(TIMESTAMP)]. Actual: [plus(date2,times('86400000','1'))(DOUBLE)]\njava.lang.IllegalStateException: Incompatible selection result data schema: Expected: [TEMP_Test__670684053__0_(TIMESTAMP)]. Actual: [plus(date2,times('86400000','1'))(DOUBLE)]\n\tat com.google.common.base.Preconditions.checkState(Preconditions.java:512)\n\tat org.apache.pinot.query.runtime.o perator.LeafStageTransferableBlockOperator.composeDistinctTransferableBlock(LeafStageTransferableBlockOperator.java:181)\n\tat org.apache.pinot.query.runtime.operator.LeafStageTransferableBlockOperator.composeTransferableBlock(LeafStageTransferableBlockOperator.java:160)" ``` -- 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-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org