[ 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