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

Siying Dong updated HIVE-1517:
------------------------------

    Attachment: HIVE-1517.10.patch

I tried some simple way to make it work. It doesn't seem to be such a simple 
task. Instead, I added this to block it:

<pre>
 // TODO: add support to referencing views in foreign databases.
 if (!tab.getDbName().equals(db.getCurrentDatabase()))  {
  throw new SemanticException(ErrorMsg.INVALID_TABLE_ALIAS.
                getMsg("Referencing view from foreign databases is not 
supported."));
 }

I'll add the view support as a follow-up patch.

> 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.10.patch, 
> 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

        

Reply via email to