You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ramesh Kumar Thangarajan (Jira)" <ji...@apache.org> on 2023/01/05 19:06:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-26837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Kumar Thangarajan resolved HIVE-26837.
---------------------------------------------
    Resolution: Fixed

> CTLT with hive.create.as.external.legacy as true creates managed table instead of external table
> ------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-26837
>                 URL: https://issues.apache.org/jira/browse/HIVE-26837
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>            Reporter: Ramesh Kumar Thangarajan
>            Assignee: Ramesh Kumar Thangarajan
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 2h 20m
>  Remaining Estimate: 0h
>
> 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;



--
This message was sent by Atlassian Jira
(v8.20.10#820010)