Hi, When I'm trying to update the values with null in the table via API request body attribute, it is not reflecting in Pinot DB eg:{ "xyz": null } What is the difference between mode FULL and PARTIAL? ------------------------ "upsertConfig": { "mode": "*FULL*", ------------------------ "upsertConfig": { "mode": "*PARTIAL*",

In full mode, the new row will completely overwrite the existing one. In partial, only the non-null values from the new one will overwrite the old one

Any performance difference between two? @Mayank

Nothing that you would notice. But it is more about what the use case needs.

Can we update to default values with mode: PARTIAL?

No. Partial is specifically for updating non null values

Let's say we have inserted 10 column values and we are updated 2 column values to null using full mode, Will the remaining column values(existed values) changed to null?

In full mode, all columns are overwritten always. In partial mode, only non null columns are overwritten

which means 2 columns values will get updated and remaining will set to null for full mode right?