Per-partition storage
In this link: https://www.youtube.com/watch?v=j-xo0CyGk7Q
in Feature 6#: Per-partition storage -store old parts of the data in a cheaper store.
how can I do that? I can store part of the data in Vertica and part (the old parts) in the S3 store in the same table?
Best Answer
-
Bryan_H Vertica Employee Administrator
In an EE mode database, you can set storage locations for data on local disk and S3, then set a storage policy directing old partitions onto S3 location and a policy for current data on local disk. Please see:
https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/StorageLocations/CreatingAndConfiguringStorageLocations.htm
The most relevant sections are on "Creating Storage Locations" to create the storage locations on local disk and S3 and "Creating Storage Policies for Low-Priority Data" to assign partitions to the storage locations.1