When you alter a Hive table by adding a new column to a Hive partition table, the mapping fails with the following validation error:

"You cannot add column {columnname} as table {tablename} is partitioned"

When you change the table metadata in the Developer Tool by modifying the existing data type in a Hive mapping that reads data from a Hive source and do not synchronize the Physical Data Object (PDO), the mapping fails with the following error:

FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different

Workaround: Synchronize the Physical Data Object and run the mapping again.

When you synchronize a Hive object that contains complex datatypes in the Developer tool, the links between the hive objects in the mapping are not retained.