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')
Hi Valentine,
Hive has been enhanced to include a MANAGEDLOCATION clause to specify the
location of managed tables as shown in the following syntax:
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
[LOCATION external_table_path]
[MANAGEDLOCATION managed_table_directory_path]
[WITH D
Hi Valentine,
I think your issue is related to
https://issues.apache.org/jira/browse/HIVE-28198 .
IMO, some other upstrem engine(Trino/Spark) will also encounter
this issue. You can try the workaround by setting the property
metastore.metadata.transformer.class t
