One more question….How is the schema change of a Table handled?

We support schema evolution as long as backward compatible. You update schema and either reload segments (populates new columns with default values), or rebootstrap

For non-backward compatible changes I suppose custom scripts to copy from old to new table with conversion might be the solution right?

It would be like new table