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

Siying Dong commented on HIVE-1517:
-----------------------------------

I notice that Carl's patch added cross database support for 'create table', 
'load', etc, but now 'drop table' and 'analyze table', which are very hard 
since they currently support dots as other meaning and would cause the 
ambiguity that we are not ready to handle. Also, it's hard for 'drop table' or 
'analyze table' to give accurate error message if people try to use db.table. 
Do you think we want to keep it or we should remove all supports for DDL 
queries?

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