This article explains why a join between dc_depot_fetches and storage_containers may not return expected results and provides the correct join path to retrieve projection and subcluster information. It also outlines how to trace historical ROS activity when metadata is no longer present in storage_containers.
Environment
- Vertica Database
- Depot fetch activity
- ROS container lifecycle
- System tables:
dc_depot_fetches,storage_containers,projection_storage,nodes,dc_roses_created,dc_roses_destroyed
Situation
A query joining dc_depot_fetches with storage_containers did not return results as expected. The goal was to retrieve projection names and subcluster information for completed ROS fetches.
