Skip to content

[multistage][bug] literal attachment not working properly with other expansion rules #11862

@walterddr

Description

@walterddr

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)

Metadata

Metadata

Assignees

Labels

bugmulti-stageRelated to the multi-stage query engine

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions