[ 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