Skip to content

SQL: PERCENTILE and PERCENTILE_RANK's second argument failure #37099

@astefan

Description

@astefan

Same behavior for percentile function.

sql> select percentile_rank(num2, 12+12) from calcs;
Server error [Server encountered an error [can't be rewritten]. [java.lang.UnsupportedOperationException: can't be rewritten
        at org.elasticsearch.xpack.sql.expression.function.aggregate.InnerAggregate.replaceChildren(InnerAggregate.java:47)
        at org.elasticsearch.xpack.sql.expression.function.aggregate.InnerAggregate.replaceChildren(InnerAggregate.java:16)
        at org.elasticsearch.xpack.sql.tree.Node.transformChildren(Node.java:212)
        at org.elasticsearch.xpack.sql.tree.Node.transformDown(Node.java:169)
        at org.elasticsearch.xpack.sql.plan.QueryPlan.lambda$transformExpressionsDown$2(QueryPlan.java:60)
        at org.elasticsearch.xpack.sql.plan.QueryPlan.doTransformExpression(QueryPlan.java:69)
        at org.elasticsearch.xpack.sql.plan.QueryPlan.doTransformExpression(QueryPlan.java:85)
        at org.elasticsearch.xpack.sql.plan.QueryPlan.lambda$transformExpressionsDown$3(QueryPlan.java:60)

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions