Restores a storage location that was previously retired with
RESTORE_LOCATION ( 'location‑path', 'node' )
Specifies where to mount the retired storage location.
The Vertica node where the retired location is available. An empty string specifies to perform this operation on all nodes. The operation fails if you dropped any locations.
Effects of Restoring a Previously Retired Location
After restoring a storage location, Vertica re-ranks all of the cluster storage locations. It uses the newly restored location to process queries as determined by its rank.
Monitoring Storage Locations
To obtain disk storage information that the database uses on each node, query system table
Restore the retired storage location on
=> SELECT RESTORE_LOCATION ('/thirdVerticaStorageLocation/' , 'v_vmartdb_node0004');