[HIVE-26837] CTLT with hive.create.as.external.legacy as true creates managed table instead of external table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: HiveServer2
• Labels: pull-request-available
• Assignee: Ramesh Kumar Thangarajan
• Reporter: Ramesh Kumar Thangarajan
• Created: 12/Dec/22 22:50
• Updated: 29/Mar/24 17:49
• Resolved: 05/Jan/23 19:05

Description

When CTLT is used with the config hive.create.as.external.legacy=true, it still creates managed table by default. Use below to reproduce.

create external table test_ext(empno int, name string) partitioned by(dept string) stored as orc;
desc formatted test_ext;

set hive.create.as.external.legacy=true;

create table test_external like test_ext;
desc formatted test_external;

Issue Links

• links to: GitHub Pull Request #3854