Map gt file to projection/table

bmurrellbmurrell Community Edition User

Hi, I'm running Vertica v12.0.4.
I'm trying to find which gt file maps to a projection, and therefore a table.
I'm looking in storage_containers.sal_storage_id but that value doesn't match the file.

Tagged:

Answers

  • SruthiASruthiA Administrator

    Please try to query vs_ros.

  • bmurrellbmurrell Community Edition User

    I get the following error : -

    => select * from vs_ros;
    select * from vs_ros;
    ERROR 2624: Column "vs_ros_containers.creatingsession" does not exist
    =>

  • SruthiASruthiA Administrator

    Please create a support case.. it is a system table... you should not get error.

This discussion has been closed.