-a, --append

Appends data to an existing table with the same name in the same directory.




By default, Data Hauler does not overwrite or append tables. If Data Hauler attempts to load a table that already exists, the upload is logged as a failure and Data Hauler moves on to the next table. Using --append causes Data Hauler to append data to any tables that already exist in the same 1010data Insights Platform directory when uploading.
Note: The --append switch appends the full table to the existing table.


The salesdetail table in 1010data Insights Platform contains 800 rows. The same table in the source database now contains 900 rows. If the --append switch is included in the command, the salesdetail table in 1010data Insights Platform will contain 1700 rows.