[HIVE-1707] bug when different partitions are present in different dfs

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: He Yongqiang
• Reporter: Namit Jain
• Created: 13/Oct/10 15:54
• Updated: 16/Dec/11 23:59
• Resolved: 16/Oct/10 05:02

Description

The following does not work:

create table T -> default location dfs1
insert overwrite T partition (ds='1') select * from src;

alter table T location 'dfs2';
insert overwrite T partition (ds='1') select * from src;

It tries to insert back in dfs1 - due to which the move task fails.
It would be cleaner to keep the same semantics as fileformat - whenever a partition is being inserted into, it
inherits the properties from the table. So, after the insert, the partition should belong to dfs1.
It does not matter whether the partition exists before or not,.

Issue Links

• relates to: HIVE-2117 insert overwrite ignoring partition location