Feature Request: add support for percentile function

[MLikeWater]

Issue Type

Feature

Have you searched for existing issues?

Yes

Link to Relevant Documentation

No response

Question Details

By using PERCENTILE function, the data is segmented to better understand the distribution of the data.

[github-actions]

Stale issue message. Please comment to remove stale tag. Otherwise this issue will be closed soon.

[fucangfy]

Hi @MLikeWater , is it like window function PERCENT_RANK in mysql or the aggregation function PERCENTILE_APPROX in https://www.alibabacloud.com/help/en/maxcompute/user-guide/percentile-approx

[MLikeWater]

Hi @MLikeWater , is it like window function PERCENT_RANK in mysql or the aggregation function PERCENTILE_APPROX in https://www.alibabacloud.com/help/en/maxcompute/user-guide/percentile-approx

@fucangfy Thank you for your question. Our goal is to implement the functionality using the PERCENTILE_APPROX aggregation function, similar to the one described in the Alibaba Cloud MaxCompute documentation, not the PERCENT_RANK window function in MySQL.

[fucangfy]

got it, thank you. We are planning to introduce this feature in our future releases.