Hi Shravya, The best practice is to have a cache (and SQL table) per a business entity of your applications. So, my suggestion is not to mix different business entities in a single cache. Create your data schema as you would do for a relational database.
The CREATE TABLE creates a new Ignite cache and defines an SQL table on top of it. The cache stores the data in the form of key-value pairs while the table allows processing this data with SQL queries. So the table is just a logic thing on top of the cache. Hope this helps. — Denis > On Jan 15, 2018, at 10:43 PM, Shravya Nethula > <shravya.neth...@aline-consulting.com> wrote: > > Hi Andrey, > > Thank you for the information. > > I want to create some tables using cache.query(Create Table ...) statement. > Is there any way in which I can group some of my tables in one cache? Is > there any hierarchy in organizing the caches like a super cache holding some > sub caches? > > Regards, > Shravya Nethula. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
