In short, the answer is Yes, sub-queries are supported. The only thing you need to know is that in case of Partitioned caches the join keys need to be colocated. So, in your example, a.orgId and b.id have to be collocated.
More information on collocation can be found here: http://apacheignite.gridgain.org/docs/affinity-collocation D. On Tue, Oct 27, 2015 at 2:00 AM, iceguo <[email protected]> wrote: > I want to know whether Ignite can do nested SQL Queries such as following: > > "select a.orgid, b.name from (select orgid from person group by orgid) a > LEFT JOIN organization b on a.orgid = b.id order by b.name". > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Does-Ignite-support-nested-SQL-Queries-tp1714.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
