Can we define PARTITION PRIMARY INDEX (PPI) on a Primary Index column in Table? Explain Why?
Ans:
PPI cannot be defined on PI column in Table. Since PI is used to locate an AMP and store the data based on HASH value (ROW ID ) it cannot be used as PPI column.In case of PPI , The data stored in AMP's are Partitioned based on PPI column after they are row hashed (ROW KEY = ROW ID +PPI value )
P.S: If you want to create UPI on table, then PPI column can be added as part of PI .
No comments:
Post a Comment