[HIVE-19753] Strict managed tables mode in Hive

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.0, 4.0.0-alpha-1
• Target Version/s: 3.1.0
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 31/May/18 20:05
• Updated: 21/Oct/22 06:59
• Resolved: 24/Jun/18 17:56

Description

Create a mode in Hive which enforces that all managed tables are transactional (both full or insert-only tables allowed). Non-transactional tables, as well as non-native tables, must be created as external tables when this mode is enabled.
The idea would be that in strict managed tables mode all of the data written to managed tables would have been done through Hive.
The mode would be enabled using config setting hive.strict.managed.tables.

Issue Links

• relates to: PHOENIX-4806 make PhoenixStorageHander using only unmanaged tables
• relates to: HIVE-21663 Hive Metastore Translation Layer
• links to: https://reviews.apache.org/r/67417/

Sub-Tasks

• Utility to convert tables to conform to Hive strict managed tables mode: Closed
• Managed tables converted to external tables by the HiveStrictManagedMigration utility should be set to delete data when the table is dropped: Closed
• HiveStrictManagedMigration utility should update DB/Table location as last migration steps: Closed