Migrating Hive Data to CDP
After migrating Hive data to CDP using WXM or Replication Manager, there are additional tasks you might need to perform. You need to know the semantic differences between Hive 3.x and earlier versions. Some of these differences require you to change your Hive scripts or workflow. Also, you need to convert scripts that use Hive CLI, which CDP does not support, to Beeline.
You need to know where your tables are located and the property changes that the upgrade process makes. You need to perform some post-migration tasks before using Hive tables. Understanding Apache Hive 3 major design features, such as default ACID transaction processing, can help you use Hive to address the growing needs of enterprise data warehouse systems. For more information, see Apache Hive 3 Architectural Changes and Apache Hive Key Features.