1

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

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

1
  • 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, 2013 at 16:15

2 Answers 2

1

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.

3
  • Where is the "SQL Reference guide"? I cant find that term in Google or the Vertica manual.
    – davidjhp
    Jun 6, 2013 at 14:29
  • How do you know that namespace is a synonym for schema? Do you have a citation for this?
    – davidjhp
    Jun 6, 2013 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"
    – user1822
    Jun 11, 2013 at 22:46
0

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;
SET
vertica_user1=> select * from bla;;
 *
-------
 xxx

Hope this helped!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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