Re: IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

SQL. Two usecases - Big, Data, visualizations with databases, and sheets that shows large tables, where is sure wants to get some quick metric Variance and STDDev is should be good... ML side Dataset class already exposes these right ?... We are okay there for now. -- Sent from: http://a

Re: IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

Are you ready to use them as a part of Ignite ML functions (part of stat or math package?) or you need in SQL only? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

Hello! As far as my understanding goes, it's a very non-trivial thing to calculate median across nodes. You end up needing to pull all the data in one place or use some complicated iterative approach. Same thing probably applies to std, though there might be shortcuts. Still it's not as easy as j

Re: IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

The simple usecase is as follows In big data visualization, for drawing graphs, one needs to know the standard characteristics of a measure column (numeric column) to draw and plan out graphs. ideally, we need to this support in Ignite itself so that client code does not pull large columns (run

Re: IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

The weird thing about this is that the documentation says they do exist: https://apacheignite-sql.readme.io/docs/aggregate-functions (They don’t.) At the very least we need to update the documentation. Regards, Stephen > On 30 Jan

IGNITE-3180 : please add support for median, stddev, var in Ignite SQL

Looks like these are not supported currently, please add them in Ignite 2.8 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/