Importing data from a CSV file
Inserting data with the cqlsh command COPY from a CSV file is common for testing queries.
In a production database, inserting columns and column values programmatically is
more practical than using cqlsh, but often, testing queries using the cqlsh SQL-like
shell is very convenient. A comma-delimited file, or CSV file, is useful if several
records need inserting. While not strictly an INSERT
command, it is
a common method for inserting data.
Procedure
-
Locate your CSV file and check options to
use.
category|points|id|lastname GC|1269|220844bf-4860-49d6-9a4b-6b5d3a79cbae|SMITH One-day-races|367|220844bf-4860-49d6-9a4b-6b5d3a79cbbd|ALBERT GC|1324|220844bf-4860-49d6-9a4b-6b5d3a79cbab|DOE
-
To insert the data in the CSV file, use the
COPY
command:COPY cycling.cyclist_category FROM 'cyclist_category.csv' WITH DELIMITER = '|' AND HEADER = TRUE;