[HIVE-26911] Renaming a translated external table with a specified location fails with 'location already exists' exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Sai Hemanth Gantasala
• Reporter: Sai Hemanth Gantasala
• Created: 06/Jan/23 03:52
• Updated: 17/Jan/23 03:56
• Resolved: 17/Jan/23 03:56

Description

Renaming a translated external table with a specified location fails with 'location already exists' exception.
Below are steps for repro

create database tmp;
use tmp;
create table b(s string) stored as parquet location 'hdfs://localhost:20500/test-warehouse/tmp.db/some_location';
alter table b rename to bb;
ERROR: InvalidOperationException: New location for this table hive.tmp.bb already exists : hdfs://localhost:20500/test-warehouse/tmp.db/some_location 

Issue Links

• links to: GitHub Pull Request #3920