If the mass ingestion specification ingests data to a Hive target, configure the Hive target to specify how you want to ingest data to the target tables.
Select the target connection.
Enter the target schema.
Optionally, enter the prefix and suffix to add to the target tables.
Choose one of the following options:
Select
Hive Options
.
Select the storage format. Default is Text.
If the target is an external Hive target, select
External Table
and enter the external location.
Select
DDL Query
and enter a custom DDL query.
If you enabled incremental load in the definition of the mass ingestion specification, configure the following incremental load options:
Mode. Select
Append
or
Overwrite
. Default is Append.
Propagate schema changes on the source. Select this option if you expect to update the columns in the source tables or add new columns to the source tables.