We have two pipelines writing to the same table, and that table is ranged partitioned by “day” field.
Each pipeline fills some of the fields in the table with the same key. But the “day” field in these two pipelines may be different. Because range partition keys must exist in primary keys, so there will be two records in the result table. What we want is one complete record. So my question is why does partition keys have to be in the primary keys? Is there any workaround for this?
