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 > >