Create a relational data object with a Hive connection to write to Hive tables.
When you create a relational data object, you can add read and write operations. To use the relational data object as a target in streaming mappings, configure the relational data object write operation properties. You can select the mapping environment and run the mappings on the Spark engine of the Hadoop environment.
If you enable the
Truncate target table
property in the Advanced properties while writing to the Hive table, the data in the table is overwritten. If you do not select this property, data is appended.
For more information about relational data objects and Hive connections, see the