We have a partitioned table (daily partitioned) with tb's of data , we would like to add a column to the table , as it huge data in the table , I am assuming column addition using alter table would take a long time , can you advise what would be the best approach .
Is it row table or column storage table. If its column storage it should be fast to add it, if its row storage it will take time to re-write all the data internally