When you configure a session for a Hadoop target, you select the HDFS Flat File writer file type and a Hadoop HDFS application connection object.

When you configure the session to load data to HDFS, you can configure partitioning, file header, and output options. When you configure the session to load data to a Hive table, you can configure partitioning and output options.

When the Integration Service loads data to a Hive table, it generates a relational table in the Hive database. You can overwite the Hive table data when you run the session again.