/plushcap/analysis/datastax/datastax-new-options-and-better-performance-cqlsh-copy

New options and better performance in cqlsh copy

What's this blog post about?

The text discusses enhancements made to CQLSH commands, COPY FROM and COPY TO, for importing and exporting data in Cassandra using CSV files. These improvements were introduced in version 1.1.3 and are available in releases 2.1.13, 2.2.5, 3.0.3, and 3.2. The new features include the ability to change the maximum number of worker processes with NUMPROCESSES option, improved parallel export via token ranges for random and murmur3 partitioners, and batching rows with common partition keys during import. A benchmark shows a significant improvement in data import and export times after these enhancements were implemented. The text also lists various options that can be used with both COPY TO and COPY FROM commands.

Company
DataStax

Date published
Jan. 17, 2016

Author(s)
Stefania Alborghetti

Word count
644

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.