Skip to main content
Question

Map gt file to projection/table

  • October 25, 2024
  • 3 replies
  • 6 views

bmurrell
Forum|alt.badge.img+2

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.

3 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • October 28, 2024

Please try to query vs_ros.


bmurrell
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • October 28, 2024

I get the following error : -

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


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • October 28, 2024

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