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 <redni...@gmail.com> wrote:
> Team,
> Please reply
>
> On Thu, Jan 13, 2022, 23:17 Surinder Mehra <redni...@gmail.com> 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 partition data by
>> company and then by deptname
>> I want to colocate all company and its dept data on single node so my
>> queries can locate data locally for a given company or deptt.
>>
>> I want a composite affinity key on companyId and depttname because
>> deptname can be same across companies so data colocation is not achieved as
>> required
>>
>>
