[HIVE-24920] TRANSLATED_TO_EXTERNAL tables may write to the same location

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: metastore_translator pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 22/Mar/21 14:17
• Updated: 17/Nov/22 08:48
• Resolved: 01/Jun/21 13:50

Description

create table t (a integer);
insert into t values(1);
alter table t rename to t2;
create table t (a integer); -- I expected an exception from this command (location already exists) but because its an external table no exception
insert into t values(2);
select * from t;  -- shows 1 and 2
drop table t2;    -- wipes out data location
select * from t;  -- empty resultset

Issue Links

• relates to: HIVE-4567 RuntimeException when two external tables have the same location
• links to: GitHub Pull Request #2191