You can push a mapping to the Hadoop environment that includes a target from the native environment or from the Hadoop environment. Some sources have limitations when you reference them in the Hadoop environment.
You can run mappings with the following targets in a Hadoop environment:
Flat file (native)
HDFS flat file
A mapping that runs with the Spark engine can have partitioned Hive target tables but it cannot have bucketed targets.
When a mapping runs in the Hadoop environment, an HDFS target or a 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.