[HIVE-20057] For ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='TRUE'); `TBL_TYPE` attribute change not reflecting for non-CAPS

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: All Versions
• Fix Version/s: 3.1.2
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Target Version/s: 3.1.2
• Assignee: Anirudh
• Reporter: Anirudh
• Created: 02/Jul/18 19:48
• Updated: 26/Aug/19 21:21
• Resolved: 13/Aug/19 22:34

Description

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 is shown wrongly, as 'True' was used in place of 'TRUE' in the ALTER statement.

Issue explained here: 

StakOverflow - Hive Table is MANAGED or EXTERNAL

 

Issue Links

• is related to: HIVE-1329 for ALTER TABLE t SET TBLPROPERTIES ('EXTERNAL'='TRUE'), change TBL_TYPE attribute from MANAGED_TABLE to EXTERNAL_TABLE
• links to: GitHub Pull Request #388
• links to: GitHub Pull Request #388