-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Closed
Labels
Description
see:
SELECT ,
AVG(int_val) AS average,
PERCENTILE(int_val, 50) AS median
FROM
tbl
will cause
Error Code: 200
java.util.concurrent.ExecutionException: org.apache.pinot.spi.exception.BadQueryRequestException: Invalid aggregation function: percentile($0,$1); Reason: null
at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:395)
at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2022)
at org.apache.pinot.query.service.server.QueryServer.submit(QueryServer.java:126)
at org.apache.pinot.common.proto.PinotQueryWorkerGrpc$MethodHandlers.invoke(PinotQueryWorkerGrpc.java:286)
...
Caused by: org.apache.pinot.spi.exception.BadQueryRequestException: Invalid aggregation function: percentile($0,$1); Reason: null
at org.apache.pinot.core.query.aggregation.function.AggregationFunctionFactory.getAggregationFunction(AggregationFunctionFactory.java:372)
at org.apache.pinot.query.runtime.operator.AggregateOperator.getAggFunctionForRawInput(AggregateOperator.java:250)
at org.apache.pinot.query.runtime.operator.AggregateOperator.getAggFunctions(AggregateOperator.java:205)
at org.apache.pinot.query.runtime.operator.AggregateOperator.<init>(AggregateOperator.java:97)
org.apache.pinot.query.service.dispatch.QueryDispatcher.submit(QueryDispatcher.java:148)
org.apache.pinot.query.service.dispatch.QueryDispatcher.submitAndReduce(QueryDispatcher.java:92)
org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:188)
org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:279)