Originally from the User Slack
@KishoreKishore**:** Hi, We recently added a new User-Defined Type (UDT) column to one of our tables, but subsequently dropped it. Upon attempting to re-add the same column, we encountered the following error:
ALTER TABLE abc ADD (label_policies list<frozen<policy>>);
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot add a collection with the name label_policies because a collection with the same name and a different type has already been used in the past"
Please advise on the root cause and suggest a solution?
@Botond_Dénes: The solution is to use a different name for the recreated column.
@Kishore**:** okay, thanks.