hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3941) Implement The Schema Search Path Feature
Date Tue, 29 Jan 2013 02:39:13 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

caofangkun updated HIVE-3941:
-----------------------------

    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.

  was:
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


    
> 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 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.

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