RESTORE_LOCATION
Restores a storage location that was previously retired with RETIRE_LOCATION.
Syntax
RESTORE_LOCATION ( 'path', 'node' )
Arguments
path |
Where to mount the retired storage location. |
node |
The Vertica node on which to restore the location. To perform this operation on all nodes, use an empty string ( The operation fails if you dropped any locations. |
Privileges
Superuser
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
For information about the disk storage used on each node, query the DISK_STORAGE
system table.
Examples
Restore a retired storage location on node4
:
=> SELECT RESTORE_LOCATION ('/thirdSL/' , 'v_vmartdb_node0004');