Skip to main content
Question

What is v_internal in my search path?

  • August 22, 2022
  • 4 replies
  • 10 views

Natasha_2

I see my search path but it show v_internal. I not know what this does. I find nothing in documentation on v_internal. Is it schema like v_catalog and v_monitor and if so what it for?

4 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • August 22, 2022

v_internal is one of the vertica schemas which contains the system tables such as vs_nodes, vs_tables etc.


Natasha_2
  • Author
  • Participating Frequently
  • August 23, 2022

thank you sruthiA. Is it not in documentation? I not find it.


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • August 23, 2022

most of the system tables are present in v_internal schema. It is present in the documentation. Please find the link below

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/QueryingDataCollectorTables.htm


Natasha_2
  • Author
  • Participating Frequently
  • August 23, 2022

thank you