Hi Michael, In this case , I always need to include partition key(date) in primary key ( if I have a primary key defined on non partition key
column e.g id (in my case), to make it a composite primary key (id, date). This would allow duplicate id with different date,which is not desirable .
Thanks, Shatamjeev From: Michael Lewis <mlewis@xxxxxxxxxxx>
No, what you want is not possible and probably won't ever be I would expect. Scanning every partition to validate the primary key isn't scalable. |