[
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
