[ https://issues.apache.org/jira/browse/HIVE-20057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16530379#comment-16530379 ]
ASF GitHub Bot commented on HIVE-20057: --------------------------------------- GitHub user animenon opened a pull request: https://github.com/apache/hive/pull/388 HIVE-20057: Fix Hive table conversion DESCRIBE table bug Fix for #HIVE-20057 Issue: `Table Type` wrongly shown as `MANAGED_TABLE` after converting table from MANAGED to EXTERNAL using ` ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='True')` _(this is shown correctly only for `'EXTERNAL'='TRUE`)_ You can merge this pull request into a Git repository by running: $ git pull https://github.com/animenon/hive patch-1 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/hive/pull/388.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #388 ---- commit 1a9674645c3b4e3080f5278f6bea3126b1cebbac Author: Anirudh <animenon@...> Date: 2018-07-02T19:53:03Z HIVE-20057: Fix Hive table conversion DESCRIBE table bug `equals` to `equalsIgnoreCase` ---- > 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)