In the Vertica database, what does the term "namespace" mean?

I have reviewed the entire Vertica documentation and cannot find what this means.

  • 1
    Can you tell us where you use "namespace", because it is used in many places with diferent scopes. Can be used in Driver conf, java pkg , in the set path(vsql)... – Up_One Jun 11 '13 at 16:15

The namespace refers to a schema (select * from [schema].[tablename]). If you search the "SQL Reference guide" you will find the term used interchangeably, although, schema is used a lot more since its standard SQL.

  • Where is the "SQL Reference guide"? I cant find that term in Google or the Vertica manual. – davidjhp Jun 6 '13 at 14:29
  • How do you know that namespace is a synonym for schema? Do you have a citation for this? – davidjhp Jun 6 '13 at 14:30
  • @davidjhp: quote from here: my.vertica.com/docs/6.1.x/HTML/index.htm#1243.htm "In SQL statements, a schema refers to named namespace for a logical schema" – a_horse_with_no_name Jun 11 '13 at 22:46

I don't think it has to do with the schema synonym - and schemas don't have synonyms, they use search_path that lists in order the schemas Vertica will try to resolve the full path to the object.

For example :

vertica=> select * from bla;
ERROR:  relation "bla" does not exist
vertica_user1=> show search_path;
    name     |                      setting
 search_path | "$user", public, v_catalog, v_monitor, v_internal
(1 row)

vertica_user1=> set search_path = main_wh, "$user", public, v_catalog, v_monitor, v_internal;
vertica_user1=> select * from bla;;

Hope this helped!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.