I have control table and a working table. The working table schema changes (add,remove,alter) columns need to be applied to control table. I am using orc. Any quick and easy way to do this nightly?
One way to do this is to have external tables. Then you can just drop your control table and recreate it based on your working table.
@Shishir Saxena The control table is a hive managed table for ORC.
Did you get any solution for this. I need to implement exactly the same thing for my piece of work.