[HIVE-19981] Managed tables converted to external tables by the HiveStrictManagedMigration utility should be set to delete data when the table is dropped

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Target Version/s: 3.2.0
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 25/Jun/18 18:22
• Updated: 17/Nov/22 08:55
• Resolved: 28/Jun/18 18:09

Description

Using the HiveStrictManagedMigration utility, tables can be converted to conform to the Hive strict managed tables mode.
For managed tables that are converted to external tables by the utility, these tables should keep the "drop data on delete" semantics they had when they were managed tables.

One way to do this is to introduce a table property "external.table.purge", which if true (and if the table is an external table), will let Hive know to delete the table data when the table is dropped. This property will be set by the HiveStrictManagedMigration utility when managed tables are converted to external tables.

Issue Links

• links to: https://reviews.apache.org/r/67735/