I don't think PERCENTILE_CONT is implemented. It appears in reference.html because it is a keyword recognized by the parser, but we have not fully implemented it. See https://issues.apache.org/jira/browse/CALCITE-1473.
On Fri, Sep 13, 2019 at 4:18 PM Scott Reynolds <sdrreyno...@gmail.com> wrote: > > Sorry for such a super lame message, spent way to much time trying to get > it to work. This query throws a parse error: > > select dataset, > percentile_cont (0.25) WITHIN GROUP (order by rpc_time DESC) > OVER(PARTITION BY dataset) as percentile_25 from QueryLogs; > > Fails with: > Encountered "percentile_cont" at line 1, column 17. > > What am I missing? https://calcite.apache.org/docs/reference.html lists the > function as hypothetical ? It is a listed in the parser template: > https://github.com/apache/calcite/blob/705be2771f284533a998e941c9dc3b285f1d7351/core/src/main/codegen/templates/Parser.jj#L6839 > > Thanks!