drop data location

Roman_1

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.

Prasanta_Pal

Please see the below link
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.

Roman_1

Prasanta Pal,
thank you a lot for help