This actually came up last year but it seems that we neither updated the documentation nor implemented the missing functions.
https://lists.apache.org/thread.html/f717f17cf9852fe77274df8187c9b82148537dfc829772aba810e613%40%3Cuser.ignite.apache.org%3E https://issues.apache.org/jira/browse/IGNITE-3180 Regards, Stephen > On 22 Jun 2020, at 10:16, Courtney Robinson <[email protected]> wrote: > > Hi, > The STDDEV* and VAR* SQL functions are documented on both Ignite and GridGain > websites but are not implemented. > https://www.gridgain.com/docs/latest/sql-reference/aggregate-functions#stddev_pop > > <https://www.gridgain.com/docs/latest/sql-reference/aggregate-functions#stddev_pop> > https://apacheignite-sql.readme.io/docs/aggregate-functions > <https://apacheignite-sql.readme.io/docs/aggregate-functions> > > The enums were commented out 6 years ago in > https://github.com/apache/ignite/commit/63ec158e8dcfa9294c0727b8b778c87477416e10 > > <https://github.com/apache/ignite/commit/63ec158e8dcfa9294c0727b8b778c87477416e10> > So these do not work STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, BOOL_OR, > BOOL_AND, SELECTIVITY, HISTOGRAM. > > What's the story here? Shouldn't they be removed from the docs until/if they > are ever implemented? > > Using Ignite 2.8. > > Regards, > Courtney Robinson > Founder and CEO, Hypi > Tel: ++44 208 123 2413 (GMT+0) <https://hypi.io/> > > <https://hypi.io/>https://hypi.io <https://hypi.io/>
