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:
Complex files
Flat file (native)
Greenplum
HBase
HDFS flat file
Hive
IBM DB2
Netezza
ODBC
Oracle
Sqoop targets
Teradata
A mapping that runs with the Spark engine can have partitioned Hive target tables and 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.