Convert a managed, non-transactional table to external
You can easily convert a managed table if it is not an ACID (transactional) table to external using the ALTER TABLE statement. You might have a non-transactional, managed table after an upgrade from Hive 1 or 2.
The following pseudo-code changes a table to external. The data and metadata is dropped when the table is dropped.
ALTER TABLE ... SET TBLPROPERTIES('EXTERNAL'='TRUE','external.table.purge'='true')