[
https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12996641#comment-12996641
]
John Sichi commented on HIVE-1517:
----------------------------------
Hey Siying,
This case from my original comment way at the top of this JIRA issue is not
handled by your patch.
{noformat}
create database db1;
use db1;
create table t(i int);
create view v as select * from t;
create database db2;
use db2;
select * from db1.v;
{noformat}
This will take some work in the unparse when we store the view definition.
> ability to select across a database
> -----------------------------------
>
> Key: HIVE-1517
> URL: https://issues.apache.org/jira/browse/HIVE-1517
> Project: Hive
> Issue Type: Improvement
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Siying Dong
> Priority: Blocker
> Fix For: 0.7.0
>
> Attachments: HIVE-1517.1.patch.txt, HIVE-1517.2.patch.txt,
> HIVE-1517.3.patch, HIVE-1517.4.patch, HIVE-1517.5.patch, HIVE-1517.6.patch,
> HIVE-1517.7.patch, HIVE-1517.8.patch, HIVE-1517.9.patch
>
>
> After https://issues.apache.org/jira/browse/HIVE-675, we need a way to be
> able to select across a database for this feature to be useful.
> For eg:
> use db1
> create table foo(....);
> use db2
> select .. from db1.foo.....
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
