DROP-REPOSITORY

DROP-REPOSITORY

Name

DROP REPOSITORY

Description

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.

Example

1. Delete the repository named bos_repo:

DROP REPOSITORY `bos_repo`;

Keywords

 DROP, REPOSITORY

Best Practice