Re: Query on collections in a cache object

[vdpyatkov <vl...@gmail.com>]

Hi,

You can do it using ScanQuery[1] with specific filter, and reorder result by
your logic.

You can not find in nested collection on SQL query. For do this you should
store Person and Phone separately link them using foreign keys.
You can then join these two table in your SQL query[2].


[1]: https://apacheignite.readme.io/docs/cache-queries#scan-queries
[2]:
https://github.com/apache/ignite/blob/master/examples/src/main/java/org/apache/ignite/examples/datagrid/CacheQueryExample.java



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-on-collections-in-a-cache-object-tp11529p11543.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Query on collections in a cache object

[vdpyatkov <vl...@gmail.com>]

Hi,

Even if you use SQL query whole data set will be loaded to client side (on
reduce phase) and sorted local.
That behavior will be change only 2.0 version[1].

[1]: https://issues.apache.org/jira/browse/IGNITE-3013



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-on-collections-in-a-cache-object-tp11529p11568.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.