[HIVE-2617] Insert overwrite table db.tname fails if partition already exists

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Database/Schema, Metastore
• Hadoop Flags: Reviewed
• Assignee: Chinna Rao Lalam
• Reporter: Aniket Namadeo Mokashi
• Created: 30/Nov/11 18:03
• Updated: 30/Apr/12 21:11
• Resolved: 15/Dec/11 02:05

Description

Insert Overwrite table db.tname fails if partition already exists.
For example-
insert overwrite table db.tname PARTITION(part='p') select .. from t2 where part='p'; fails if partition 'p' already exists. Workaround is - use db; and the fire the command.
From the source code-
alterPartition(tbl.getTableName(), new Partition(tbl, tpart)); takes String tablename as argument and loses db information. Table table = newTable(tablename) is called to retrieve table from name. But, it relies on currentDatabase value (hence the workaround).