What is v_internal in my search path?

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?

SruthiA

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

SruthiA

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

Natasha_2

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

Natasha_2

thank you