[HIVE-3941] Implement The Schema Search Path Feature

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: caofangkun
• Created: 25/Jan/13 05:43
• Updated: 29/Jan/13 02:37

Description

The Schema Search Path
http://www.postgresql.org/docs/current/static/ddl-schemas.html

hive(myschema)> SET search_path TO myschema,default; – set Schema Search Path
hive(myschema)> SHOW search_path;
myschema
default

hive(default)>show search_path in myschema;
myschema
default

hive(default)> show tables;
de_src;

hive(myschema)> show tables; – in myschema database there is no table named de_src
src;
src1;

hive(myschema)>select * from de_src; --this queuery is equivalent to query: select * from default.de_src

the default search_path is : current_db,default
" SET search_path TO ..." statement is Session level command , when the session is over ,fall back to "current_db,default" search path.