[HIVE-4064] Handle db qualified names consistently across all HiveQL statements

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.14.0
• Component/s: SQL
• Labels: TODOC14
• Assignee: Navis Ryu
• Reporter: Shreepadma Venugopalan
• Created: 22/Feb/13 18:41
• Updated: 24/Feb/16 02:49
• Resolved: 11/Aug/14 17:23

Description

Hive doesn't consistently handle db qualified names across all HiveQL statements. While some HiveQL statements such as SELECT support DB qualified names, other such as CREATE INDEX doesn't.

Issue Links

• contains: HIVE-5912 Show partition command doesn't support db.table
• contains: HIVE-3589 describe/show partition/show tblproperties command should accept database name
• contains: HIVE-7238 show partitions when using schema does not work
• contains: HIVE-2584 Alter table should accept database name
• contains: HIVE-4086 Cross Database Support for Indexes and Partitions (or all DDL statements)
• contains: HIVE-5956 SHOW TBLPROPERTIES doesn't take db name
• is duplicated by: HIVE-3589 describe/show partition/show tblproperties command should accept database name
• is duplicated by: HIVE-7238 show partitions when using schema does not work
• is duplicated by: HIVE-8712 Cross schema query fails when table has index
• is duplicated by: HIVE-8538 Fully qualified table error when adding partition
• is duplicated by: HIVE-5956 SHOW TBLPROPERTIES doesn't take db name
• is duplicated by: HIVE-6933 "alter table add partition" should support db_name.table_name as table name.
• is related to: HIVE-7678 add more test cases for tables qualified with database/schema name
• relates to: HIVE-1977 DESCRIBE TABLE syntax doesn't support specifying a database qualified table name
• relates to: HIVE-7681 qualified tablenames usage does not work with several alter-table commands
• links to: review board