hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3941) Implement The Schema Search Path Feature
Date Fri, 25 Jan 2013 05:43:12 GMT
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

Mime
View raw message