Consider the following restrictions when you configure a Hive target in a mapping that runs in the Hadoop environment:
A mapping fails to run when you use Unicode characters in a Hive target definition.
The Hive target cannot reside on a remote cluster. A remote cluster is a cluster that is remote from the machine that the Hadoop connection references in the mapping.
When you set up a dynamic target for a partitioned Hive table, the value used for the partition is the final column in the table. If the table has a dynamic partition column, the final column of the table is the dynamic partition column. To use a different column for the partition, move it to the last column of the table. If the table has multiple partition columns, the dynamic partition values are selected from the last columns of the upstream transformation.
You can use an Expression transformation to reorder the columns if necessary.