- Yes, in SQL it is possible to query cache key and value using aliases _key and _val respectively. - Aggregate functions like SUM, AVG, MIN, MAX are supported. - Nested fields are supported and they are flattened, so name collisions are prohibited.
Sergi 2016-01-25 15:26 GMT+03:00 Pavel Tupitsyn <ptupit...@gridgain.com>: > Igniters, > > In relation to .NET LINQ task [1], I'd like to know as much as possible > about Ignite-specific SQL syntax. Our docs [2] do not cover everything. > > * Is it possible to query cache keys? E.g. "key > 10", or "key.field = 1"? > * Is it possible to query scalars, like "sum()"? > * What about nested fields? From examples, I see that nested fields get > flattened, so instead of Address.Zip you can just use Zip. Are there any > limitations? What if there is field name collision? > > Where should I look to understand this better? > > Thanks. > > [1] https://issues.apache.org/jira/browse/IGNITE-1630 > [2] https://apacheignite.readme.io/docs/sql-queries > > -- > -- > Pavel Tupitsyn > GridGain Systems, Inc. > www.gridgain.com >