Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

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

share|improve this question
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

2 Answers 2

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.

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

Hope this helped!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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