[
https://issues.apache.org/jira/browse/CALCITE-6196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-6196:
------------------------------------
Labels: pull-request-available (was: )
> Accept BigQuery PERCENTILE functions without OVER clause
> --------------------------------------------------------
>
> Key: CALCITE-6196
> URL: https://issues.apache.org/jira/browse/CALCITE-6196
> Project: Calcite
> Issue Type: Improvement
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
> Labels: pull-request-available
>
> When I added parsing/validation for PERCENTILE_CONT/DISC in CALCITE-5564, I
> required an {{OVER}} clause to be used, because this is what BigQuery
> currently allows. However I think it would be nice if Calcite extended what
> these functions are capable of by allowing them as either window functions
> *or* aggregate functions.
> The change itself would be simple enough, I have a draft commit I can put up
> after this.
> As an example, the below query is current invalid (because it is missing an
> OVER()), but would be valid after my change.
> {{SELECT PERCENTILE_CONT(age, .5) FROM users}} (this would return a single
> row instead of a row for each row in the table.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
