[jira] [Created] (HIVE-3941) Implement The Schema Search Path Feature

["caofangkun (JIRA)" <ji...@apache.org>]

caofangkun created HIVE-3941:
--------------------------------

             Summary: Implement The Schema Search Path Feature
                 Key: HIVE-3941
                 URL: https://issues.apache.org/jira/browse/HIVE-3941
             Project: Hive
          Issue Type: New Feature
          Components: Query Processor
    Affects Versions: 0.9.0
            Reporter: caofangkun
            Priority: Minor


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 tables;
de_src;

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


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


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira