[ https://issues.apache.org/jira/browse/HIVE-26837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ramesh Kumar Thangarajan updated HIVE-26837: -------------------------------------------- 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 table test_mm(empno int, name string) partitioned by(dept string) stored as orc tblproperties('transactional'='true', 'transactional_properties'='default'); desc formatted test_mm; set hive.create.as.external.legacy=true; create table test_external like test_mm; desc formatted test_external; was: When CTLT is used with the config hive.create.as.external.legacy=true, it still creates managed table by default create table test_mm(empno int, name string) partitioned by(dept string) stored as orc tblproperties('transactional'='true', 'transactional_properties'='default'); desc formatted test_mm; set hive.create.as.external.legacy=true; create table test_external like test_mm; desc formatted test_external; > 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 > Reporter: Ramesh Kumar Thangarajan > Assignee: Ramesh Kumar Thangarajan > Priority: Major > > 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 table test_mm(empno int, name string) partitioned by(dept string) > stored as orc tblproperties('transactional'='true', > 'transactional_properties'='default'); > desc formatted test_mm; > set hive.create.as.external.legacy=true; > create table test_external like test_mm; > desc formatted test_external; -- This message was sent by Atlassian Jira (v8.20.10#820010)