current community

your communities

more stack exchange communities

Stack Exchange
tour help
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.
up vote 1 down vote favorite

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
add comment

2 Answers

up vote 1 down vote

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
add comment
up vote 0 down vote

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
add comment

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.