Skip to Content
Mastering Apache Cassandra 3.x - Third Edition
book

Mastering Apache Cassandra 3.x - Third Edition

by Aaron Ploetz, Tejaswi Malepati
October 2018
Beginner to intermediate content levelBeginner to intermediate
348 pages
10h
English
Packt Publishing
Content preview from Mastering Apache Cassandra 3.x - Third Edition

COPY

The COPY command delivered with cqlsh is a powerful tool that allows you to quickly export and import data. Let's assume that I wanted to duplicate my customer table data into another query table. I'll start by creating the new table:

CREATE TABLE customer_by_company ( last_name text,  first_name text,  addresses list<frozen<customer_address>>,  company text,  PRIMARY KEY (company,last_name,first_name));

Next, I will export the contents of my customer table using the COPY TO command:

COPY customer (company,last_name,first_name,addresses) TO '/home/aploetz/Documents/Packt/customer.txt' WITH DELIMITER= '|' AND HEADER=true;Reading options from the command line: {'header': 'true', 'delimiter': '|'}Using 3 child processesStarting copy of packt_ch3.customer ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Apache Cassandra - Second Edition

Mastering Apache Cassandra - Second Edition

Nishant Neeraj

Publisher Resources

ISBN: 9781789131499Supplemental Content