drop data location
Hello, I accidently added data location for node :SELECT ADD_LOCATION('/secondverticaStorageLocation/'); Then I SELECT RETIRE_LOCATION('/secondHP VerticaStorageLocation/' , 'v_vmartdb_node0001'); What actions do I need to commit additionaly? Vertica creates temp files in this directory and changes existing subdirectories. Please help.
Please see the below link
https://my.vertica.com/docs/6.1.x/HTML/index.htm#11760.htm
https://my.vertica.com/docs/6.1.x/HTML/index.htm#11760.htm
When you retire a storage location:
- No new data is stored at the retired location, unless you first restore it with the RESTORE_LOCATION() function.
- If the storage location being retired contains stored data, the data is not moved, so you cannot drop the storage location. Instead, HP Vertica removes the stored data through one or more mergeouts.
- If the storage location being retired was used only for temp files, you can drop the location. See Dropping Storage Locations in the Administrators Guide and the DROP_LOCATION() function.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
