hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1517) ability to select across a database
Date Mon, 09 Aug 2010 21:39:19 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896703#action_12896703
] 

John Sichi commented on HIVE-1517:
----------------------------------

This case needs to work:

{noformat}
use db1;
create table t(...);

create view v as select * from t;

use db2;
select * from db1.v;
{noformat}

What this means is that when we store the definition of v, we need to store a fully-qualified
db1.t reference.  Otherwise, when we expand the view in the later query, we'll look for t
in db2 (incorrect) rather than db1 (correct).


> ability to select across a database
> -----------------------------------
>
>                 Key: HIVE-1517
>                 URL: https://issues.apache.org/jira/browse/HIVE-1517
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Carl Steinbach
>
> 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.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message