Hi Team, We are working in upsert and nullHandlingEnabled parameter by to update null value with new value it is working perfectly with string datatype but how can we do same for integer value because we can not push null value to integer, we have to push some fix value like -1 but it will not handle by nullHandlingEnabled. is there anyway around this to fix it?

I wonder if the partial upsert with max would apply here? https://docs.pinot.apache.org/basics/data-import/upsert

Although it will show the default values for numeric columns, the

IS NOT NULL

clause should filter those records.Presumably that isn’t working for you? Or if not, what isn’t working?