Configuring legacy CREATE TABLE behavior
After you upgrade to CDP Private Cloud Base and migrate old tables, the legacy CREATE TABLE behavior of Hive is no longer available by default and you might want to switch to the legacy behavior. Legacy behavior might solve compatibility problems with your scripts during data migration, for example, when running ETL.
external.table.purge = 'true'
). Therefore, when
the table is dropped, data is also deleted from the file system.You can configure legacy CREATE TABLE behavior at the site level by configuring properties in Cloudera Manager. When configured at the site level, the behavior persists from session to session.
external.table.purge
table
property set to true.