Re: Reading partition file in work/db

2022-01-17 Thread Stephen Darlington
It’s not that simple. When you write into a table it is not put directly in the partition file. Instead it goes into the write ahead log and only later, during a checkpoint, gets written to the partition file(s). There’s really no reason to look directly inside the partition files. > On 17 Jan

Re: Reading partition file in work/db

2022-01-17 Thread Surinder Mehra
Hi Stephen, I was trying to verify how data is stored in partitions. Though i verified by running local scan query on each node, i was wondering if we can open partition files like we can read kafka partitions. On Mon, Jan 17, 2022, 16:24 Stephen Darlington < stephen.darling...@gridgain.com> wrote

Re: Reading partition file in work/db

2022-01-17 Thread Stephen Darlington
What’s the use case for reading the data inside the partition files? > On 17 Jan 2022, at 10:16, Surinder Mehra wrote: > > I still havent found a way to read partition files. Not sure if we can > > 2nd: i created sample application to test it. I was able to see records > colocated as per "com

Re: Reading partition file in work/db

2022-01-17 Thread Surinder Mehra
I still havent found a way to read partition files. Not sure if we can 2nd: i created sample application to test it. I was able to see records colocated as per "companyid/dept" combination. On Fri, Jan 14, 2022, 22:54 Surinder Mehra wrote: > Team, > Please reply > > On Thu, Jan 13, 2022, 23:1

Re: Reading partition file in work/db

2022-01-14 Thread Surinder Mehra
Team, Please reply On Thu, Jan 13, 2022, 23:17 Surinder Mehra wrote: > Hi, > 1. Is it possible to read data inside partition files stored in > /work/db/nodeid/... > 2. If we have company and employee cache, employee has deptt nsme field, > can i define an affinity key on {companyId, deptname} to

Reading partition file in work/db

2022-01-13 Thread Surinder Mehra
Hi, 1. Is it possible to read data inside partition files stored in /work/db/nodeid/... 2. If we have company and employee cache, employee has deptt nsme field, can i define an affinity key on {companyId, deptname} to partition data by company and then by deptname I want to colocate all company and