Export data to a remote system by using an INSERT statement to place data into an existing table. The table can be empty or it can contain data. If the table already contains data, the exported data is appended to the data in the existing table.
If no database is specified for the remote database, the current session database or the connector default database is used, depending on the target connector type and user mapping.
Example: Teradata to Hive INSERT
The example shows an export request initiated on Teradata using the foreign server object (new_cardata@QG_Hive1) to insert data from a Teradata table into a table on a remote Hive system.
INSERT INTO new_cardata@QG_Hive1 SELECT * FROM td_cardata;