Note: Legacy Managed tables should be converted to External: The following pseudo-code changes a managed table, if it is not transactional, to external. The data and metadata is dropped when the table is dropped.
ALTER TABLE ... SET
TBLPROPERTIES('EXTERNAL'='TRUE','external.table.purge'='true')
Also if you'd like to stick to the old behavior with the newly created tables
after the Hive upgrade, you should enable the "legacy" mode
set hive.create.as.external.legacy=true
