Partition by reference is based on the primary constraint of parent table and foreign key constraint of child table. The partition key should be primary key column. In your example you are portioning by date column which does not have primary key.