This statement is used to delete a created repository. Only root or superuser users can delete repositories.
grammar:
DROP REPOSITORY `repo_name`;
illustrate:
Deleting a warehouse just deletes the warehouse's mapping in Palo, not the actual warehouse data. Once deleted, it can be mapped to the repository again by specifying the same broker and LOCATION.