[
https://issues.apache.org/jira/browse/KYLIN-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17440203#comment-17440203
]
ASF GitHub Bot commented on KYLIN-5117:
---------------------------------------
zhangayqian commented on pull request #1760:
URL: https://github.com/apache/kylin/pull/1760#issuecomment-962864445
LGTM
--
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]
> Support percentile function after aggregate sub query
> -----------------------------------------------------
>
> Key: KYLIN-5117
> URL: https://issues.apache.org/jira/browse/KYLIN-5117
> Project: Kylin
> Issue Type: New Feature
> Affects Versions: v4.0.0
> Reporter: hujiahua
> Priority: Major
>
> The following query execution will report an error：
> {quote}
> select percentile(t.gmv, 0.5) from ( select buyer_id,sum(price) as gmv from
> kylin_sales group by buyer_id ) t
> java.lang.IllegalArgumentException: Unsupported function name
> PERCENTILE_APPROX while executing SQL: "select percentile(t.gmv, 0.5) from (
> select buyer_id,sum(price) as gmv from kylin_sales group by buyer_id ) t"
> {quote}
> So it's better to support `percentile` function after aggregate sub query.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
