We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Map gt file to projection/table — Vertica Forum

Map gt file to projection/table

bmurrellbmurrell Community Edition User ✭
in General Discussion

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.