ALTER_LOCATION_USE

Alters the type of files that can be stored at the specified storage location.

Syntax

ALTER_LOCATION_USE ( 'path' , 'node' , 'usage' )

Parameters

path

Specifies where the storage location is mounted.

 
node

[Optional] The Vertica node with the storage location. Specifying the node parameter as an empty string ('') alters the location across all cluster nodes in a single transaction. 

usage

Is one of the following:

  • DATA: The storage location stores only data files. This is the supported use for both a USER storage location, and a labeled storage location.
  • TEMP: The location stores only temporary files that are created during loads or queries.
  • DATA,TEMP: The location can store both types of files.

Privileges

Superuser

USER Storage Location Restrictions

You cannot change a storage location from a USER usage type if you created the location that way, or to a USER type if you did not. You can change a USER storage location to specify DATA (storing TEMP files is not supported). However, doing so does not affect the primary objective of a USER storage location, to be accessible by non-dbadmin users with assigned privileges.

Monitoring Storage Locations

To obtain disk storage information that the database uses on each node, query system table DISK_STORAGE.

Example

The following example alters the storage location across all cluster nodes to store only data:

=> SELECT ALTER_LOCATION_USE ('/thirdVerticaStorageLocation/' , '' , 'DATA');

See Also