[
https://issues.apache.org/jira/browse/HIVE-20057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anirudh updated HIVE-20057:
---------------------------
Description:
Hive EXTERNAL table shown as MANAGED after conversion using
{code}
ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='True')
{code}
The DESCRIBE FORMATTED shows:
{code}
Table Type: MANAGED_TABLE
Table Parameters:
EXTERNAL True
{code}
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]
was:
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]
> 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
> {code}
> ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='True')
> {code}
>
> The DESCRIBE FORMATTED shows:
> {code}
> Table Type: MANAGED_TABLE
> Table Parameters:
> EXTERNAL True
> {code}
>
> 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)
