Re: Data Isolation during Ignite Cache load

2020-03-23 Thread Evgenii Zhuravlev
Hi, > ignite should display the data prior to data load instead of displaying the data that isloaded till that point *What do you mean? How it will help with a problem that you describing after that? * > he might get an empty response in case if the requested data is notyet loaded when the cache

Re: Data Isolation during Ignite Cache load

2020-03-23 Thread nithin91
Hi , But it is not behaving that way. I have tested it using the following scenario. Scenario: Initially loading 1000 rows from oracle table with the following filter where rownum<=1000 into ignite cache. During the cache load process, i checked the count using sql fields query i got the

Re: Data Isolation during Ignite Cache load

2020-03-18 Thread Evgenii Zhuravlev
Yes, SQL queries use data that was already preloaded only. Evgenii ср, 18 мар. 2020 г. в 01:23, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi , > > Filter in the sense, SQL Fields Query with where clause is executed. I > hope > the following example helps you understand

Re: Data Isolation during Ignite Cache load

2020-03-18 Thread nithin91
Hi , Filter in the sense, SQL Fields Query with where clause is executed. I hope the following example helps you understand my query. *Scenario:* For example there is a cache named Products which has 1 million records with two distinct product categories(i.e. Furniture,Electronics) among these

Re: Data Isolation during Ignite Cache load

2020-03-17 Thread Evgenii Zhuravlev
Hi, > will the filters be applied What kind of filters? Do you mean SQL queries? Evgenii вт, 17 мар. 2020 г. в 07:47, nithin91 < nithinbharadwaj.govindar...@franklintempleton.com>: > Hi , > > We have Created a cache in Ignite that gets loaded with Data from > Oracle.Cache is getting loaded

Data Isolation during Ignite Cache load

2020-03-17 Thread nithin91
Hi , We have Created a cache in Ignite that gets loaded with Data from Oracle.Cache is getting loaded using JDBC POJO Store method Ignite.Cache("Cache Name").loadCache(null).Can anyone explain how will ignite handle the below scenario when loading data using the method Ignite.Cache("Cache