[CASSANDRA-11474] cqlsh: COPY FROM should use regular inserts for single statement batches

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.2.7, 3.0.6, 3.6
• Component/s: Legacy/Tools
• Labels: lhf
• Severity: Low
• Assignee: Stefania Alborghetti
• Reporter: Stefania Alborghetti

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 01/Apr/16 00:38
• Updated: 16/Apr/19 09:30
• Resolved: 21/Apr/16 01:56

Description

I haven't reproduced it with a test yet but, from code inspection, if CQL rows are larger than batch_size_fail_threshold_in_kb and this parameter cannot be changed, then data import will fail.

Users can control the batch size by setting MAXBATCHSIZE.

If a batch contains a single statement, there is no need to use a batch and we should use normal inserts instead or, alternatively, we should skip the batch size check for unlogged batches with only one statement.