APACHE IGNITE : Join query on tables with different caches

Question

Apache Ignite : I have two caches which have table person in one cache and city table in another cache and i am trying to get name from person who's id is equal with id which is in city table so i want to make join query who will work for that please help....

Answer 1

Try following query for your requirement:-

List<List<?>> qry = cache.query(new SqlFieldsQuery("select * from table1 as t1, table2 t2 where t1.id = t2.foreignId")).getAll();