When we alter a table in hive like changing the partition. what happens to the table. Does it reformat the table or it creates a new data for new partition?
only the metadata is changed, hive doesn't change data i.e underlying files in any way. if you added a new partition you need to ensure that the data is already under the mapped partition directories.