[ https://issues.apache.org/jira/browse/HIVE-20057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16530380#comment-16530380 ]
Anirudh commented on HIVE-20057: -------------------------------- Fix: https://github.com/apache/hive/pull/388 > For ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='TRUE'); `TBL_TYPE` attribute > change not reflecting for non-CAPS > ---------------------------------------------------------------------------------------------------------------- > > Key: HIVE-20057 > URL: https://issues.apache.org/jira/browse/HIVE-20057 > Project: Hive > Issue Type: Bug > Components: Standalone Metastore > Affects Versions: All Versions > Reporter: Anirudh > Assignee: Anirudh > Priority: Minor > Labels: pull-request-available > > Hive EXTERNAL table shown as MANAGED after conversion using > > ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='True') > > The DESCRIBE FORMATTED shows: > Table Type: MANAGED_TABLE > Table Parameters: > EXTERNAL True > > This is actually a External table but shown wrongly as 'True' was used in > place of 'TRUE' in the ALTER statement. > Issue explained here: > [StakOverflow - Hive Table is MANAGED or > EXTERNAL|https://stackoverflow.com/questions/51103317/hive-table-is-managed-or-external/51142873#51142873] > -- This message was sent by Atlassian JIRA (v7.6.3#76005)