[KUDU-3468] Support {INSERT,UPSERT}_IGNORE in the 'kudu table copy' CLI tool

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.17.0
• Component/s: CLI
• Labels: supportability usability
• Code Review: http://gerrit.cloudera.org:8080/19595
• Assignee: Alexey Serbin
• Reporter: Alexey Serbin
• Created: 06/Apr/23 18:26
• Updated: 06/Apr/23 18:28
• Resolved: 06/Apr/23 18:28

Description

It would be great to make kudu table copy CLI tool supporting INSERT_IGNORE and UPSERT_IGNORE operations. Having that is necessary to make copying tables from one cluster to another re-entrant, i.e. make it possible to restart the script/command (without preliminary resetting/cleaning the destination table) if copying failed in the middle due to some transient error.

Another approach might be starting a multi-row transaction in the destination Kudu cluster, so in case of a failure all the inserted rows rolled back, but that should be handled as a separate issue.