Append / Incremental-append



May I ask, when you have added new rows to a SQL table and you wish to update the same table on hdfs, what is the difference of using --append and --incremental-append ?

I have seen example when both are used and only 1 are used - can someone explain the logic of choosing one over the other or both please?

Many thanks,