[
https://issues.apache.org/jira/browse/KYLIN-5082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17411003#comment-17411003
]
ASF GitHub Bot commented on KYLIN-5082:
---------------------------------------
Mukvin commented on pull request #1742:
URL: https://github.com/apache/kylin/pull/1742#issuecomment-914075360
## Test Evidence
SQL:
`SELECT
percentile_approx(seller_id, 0.3) AS seller_percentile
FROM kylin_sales
where PART_DT = date '2012-01-01'
GROUP BY part_dt, trans_id`
### expect result
1. execute plan stages size is 1
2. in kylin.log
```
2021-09-07 15:40:47,349 INFO [Query
bbe6c95c-2a65-4a64-1126-f8a87f29f1dc-40] plans.AggregatePlan:54 : Query exactly
match index, skip agg, project List(F__KYLIN_SALES_PART_DT__1_625ad417__1,
F__KYLIN_SALES_TRANS_ID__1_625ad417__0,
percentile_decode(F__PERCENTILE_SELLER_ID__1_625ad417__10, 1355297296_prj3,
100) AS
`PERCENTILE_DECODE(F__PERCENTILE_SELLER_ID__1_625ad417__10_1355297296_prj3)_0_701333056`).
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> Exactly aggregation for percentile function
> -------------------------------------------
>
> Key: KYLIN-5082
> URL: https://issues.apache.org/jira/browse/KYLIN-5082
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: v4.0.0
> Reporter: Zhiyu Zeng
> Assignee: Zhiyu Zeng
> Priority: Major
> Fix For: v4.0.1
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
