Hello Sumit! How many entries do you have in campaign_cache? You might be running out of memory in toString() before println if not in Ignite.
Regards, -- Ilya Kasnacheev 2017-10-17 11:23 GMT+03:00 Sumit Sethia <[email protected]>: > Hi, I am trying to execute two step cache query but it stucks at getAll() > method. I have binary caches stored. Here is my query: > > IgniteCache igniteCache = Ignition.ignite().cache(campaign_cache). > withKeepBinary(); > > String query = "select x.name from \"table_1_cache\".`table_1` as x where > x.id = (select z.id from \"table_2_cache\".`table_2` as z where z.id='xyz');"; > > SqlFieldsQuery sqlFieldsQuery = new SqlFieldsQuery(query); > > FieldsQueryCursor queryResult = igniteCache.query(sqlFieldsQuery); > > //System.out.println(queryResult.getAll()); > > When I print queryResult.getAll(), it get stuck and doesn't proceed. > > But when I execute single select queries, it works fine. > > How will it work ? > > > Thanks, > > Sumit. > >
