[HIVE-2721] ability to select a view qualified by the database / schema name

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.7.0, 0.7.1, 0.8.0, 0.9.0
• Fix Version/s: 0.10.0
• Component/s: Database/Schema, Query Processor
• Hadoop Flags: Reviewed
• Assignee: Martin Traverso
• Reporter: Robert Morton
• Created: 17/Jan/12 01:31
• Updated: 10/Jan/13 19:53
• Resolved: 27/Apr/12 00:50

Description

HIVE-1517 added support for selecting tables from different databases (aka schemas) by qualifying the tables with the database name. The feature work did not however extend this support to views. Note that this point came up in the earlier JIRA, but was not addressed. See the following two comments:

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

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