Ignite SQL engine built on top of H2 engine and supports aggregation functions like cnt, max, etc.
Also Ignite supports user defined function. See QuerySqlFunction annotation documentation and its usages in Ignite tests (e.g. https://github.com/apache/ignite/blob/68891e89dd0e0f19321d6a4d45ae7372279b8b08/modules/indexing/src/test/java/org/apache/ignite/internal/processors/cache/IgniteCacheAbstractQuerySelfTest.java#L1877 ) In order to define functions you should create class with some set of functions where each function represented as method annotated by QuerySqlFunction and configure cache using CacheConfiguration.setSqlFunctionClasses() method. On Mon, Jul 25, 2016 at 7:41 PM, M Singh <[email protected]> wrote: > Hi: > > I wanted to find out if ignite sql/other queries support aggregation or > udf functions (like count, etc). > > Thanks > -- Andrey Gura GridGain Systems, Inc. www.gridgain.com
