I have added a couple of new columns to my existing table schema. Offline tables seem fine but querying the REALTIME tables with select * .., I end up with an error

MergeResponseError: responses for table: myTable from servers [d123-1_R] got dropped due to data schema inconsistency

What is the correct way to fix this. I tried reloading all segments in the realtime table also restarted all processes but it didn't seem to fix the issue.

You can refer to this: https://docs.pinot.apache.org/users/tutorials/schema-evolution