HI Druid filks, I am using streaming Kafka and in source i have MS SQL server, if in case any changes in source system like adding new column then how that column we can use in current running Datasource in Apache Druid.

Hi Neeraj, With Druid you can add columns to an existing datasource just by changing the ingestion spec and adding in the column. The same concept applies to removing a column ... however if you keep the older data with that column you removed, the schema will still show the column, it will just query back as NULLs for the new data. Changing existing column datatype may be a bit trickier, I am not sure how a schema change is interpreted exactly if you change the datatype in your supervisor spec without reindexing the existing data. Ref: https://druid.apache.org/docs/latest/data-management/schema-changes/

Thanks John :)