[HIVE-1517] ability to select across a database

• Type: Improvement
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Query Processor
• Assignee: Siying Dong
• Reporter: Namit Jain
• Created: 06/Aug/10 21:21
• Updated: 30/Aug/12 01:27
• Resolved: 23/Feb/11 07:19

Description

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

Issue Links

• duplicates: HIVE-849 <database_name>.<table_name>.<column_name> not supported
• is related to: HIVE-1977 DESCRIBE TABLE syntax doesn't support specifying a database qualified table name
• relates to: HIVE-2228 Can't use DB qualified column names in WHERE or GROUP BY clauses
• requires: HIVE-675 Add Database/Schema support to Hive QL