I have a doubt in using Hash Partition using multiple keys. My logic is to calculate some values based on current key previous key logic. Consider that i've 3 nodes and i want to do the following operation.
Code: Select all
A B C D E F
P1 1 2 3 1 2
P1 1 2 4 3 2
P1 1 2 5 2 3
P2 2 3 1 2 3
P2 2 3 2 3 4
1. Will the record P1 comes into a single node??
2. Or will it work when i have 2 nodes??
3. Or is it necessary that i hash partition using first 3 colums which identifies a record???
Thanks in advance.