Re: queryResult.getAll() stuck !!
Hi Sumit, What is version of Ignite do you use? Do you observe any CPU load? Would you please share query plan? You can get it via H2 console [1]. Do you create table via "CREATE TABLE" SQL command. It is possible, simple queries by PK are broken and full scan performed instead of using index in some cases in 2.1 version. This already fixed and will be available from 2.3 that is coming soon. [1] https://apacheignite.readme.io/v2.2/docs/sql-performance-and-debugging#using-h2-debug-console On Wed, Oct 18, 2017 at 12:03 PM, Sumit Sethiawrote: > Hi Alexander, there is no suspicious log as far as I can see. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > -- Best regards, Andrey V. Mashenkov
Re: queryResult.getAll() stuck !!
Hi Alexander, there is no suspicious log as far as I can see. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: queryResult.getAll() stuck !!
I see the iterator is null. On 17 Oct 2017 3:34 pm, "Sumit Sethia"wrote: > Hi Ilya, table_1_cache contains around 16K entries and table_2_cache > contains > around 2 million entries. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: queryResult.getAll() stuck !!
Hi Ilya, table_1_cache contains around 16K entries and table_2_cache contains around 2 million entries. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: queryResult.getAll() stuck !!
Hi Sumit, Is there anything suspicious in the logs? - Alex вт, 17 окт. 2017 г. в 12:21, Ilya Kasnacheev: > 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 : > >> 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. >> >> >
Re: queryResult.getAll() stuck !!
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: > 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. > >
queryResult.getAll() stuck !!
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.