Well, if you want the partition key to be part of the joins, you will have to use a composite primary key anyway, so that’s the way to go. Sorry for the inconvenience.