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.
- In Cloudera Manager, click Clusters and select the Hive on Tez service.
From the Hive on Tez service, go to the
Configuration tab and search for
If the following properties are selected, clear the selection to enable legacy
CREATE TABLE behavior.
- Default Table Format - Create Tables as ACID Insert Only
- Default Table Format - Create Tables as Full ACID
- Default Table Format - Create Tables as ACID Insert Only (
external.table.purgetable property set to true.