@Xiang Fu @Jackie Followed below steps still newl added column is populating with default value which I have added in updated schema file. Kindly suggest.
added pinot.server.instance.reload.consumingSegment=true in server.conf file
# create a kafka topic
bin/kafka-topics.sh --create --topic test_schema_hybrid --bootstrap-server localhost:9092
# Push some Events (original data)
bin/kafka-console-producer.sh --topic test_schema_hybrid --bootstrap-server localhost:9092
{"id":1, "name":"A1","mtime":1610841000000}
{"id":2, "name":"A2", "mtime":1610841000000}
{"id":3, "name":"A3", "mtime":1610841000000}
# create hybrid table with original schema
bin/pinot-admin.sh AddTable \
-schemaFile /Users/dev/apps/apache-pinot-incubating-0.7.1-bin/original_Schema.json \
-tableConfigFile /Users/dev/apps/apache-pinot-incubating-0.7.1-bin/relatime_config.json \
-exec
bin/pinot-admin.sh AddTable \
-schemaFile /Users/rahul1.patidar/apps/apache-pinot-incubating-0.7.1-bin/original_Schema.json \
-tableConfigFile /Users/rahul1.patidar/apps/apache-pinot-incubating-0.7.1-bin/offline_config.json \
-exec
# Update Schema in Pinot
bin/pinot-admin.sh AddSchema -schemaFile Updated_schema.json -exec
# Reload the SEGMENT
able to see the new Column value with default value(defaultNullValue in updated_schema.json)
# now pushed some more events in same kafka topic with new fields.
{"id":4, "name":"A4", "city":"noida", "mtime":1610841000000}
{"id":5, "name":"A5", "city":"mumbai", "mtime":1610841000000}
#Reload the SEGMENT
But still in all the rows values are showing (defaultNullValue='Bangalore') for city column(newly added).
Kindly suggest what i am missing here.how can i Update reltime values in pinot hybrid table.?