-
Notifications
You must be signed in to change notification settings - Fork 2
Import Export Data From To Cassandra
There are three ways to export/import data from/to Cassandra:
-
the COPY Command This copy command is only available in cqlsh. If you don't know cqlsh, here is some explanation. It is the most commonly used method to do export/import data because it is available for free and does not require setup for other software. This method can handle CSV or TSV files. Details on how to use this command can be read here.
-
Apache Sqoop This option unfortunately only available for Datastax Enterprise Edition (DSE) and not for community edition. The sqoop in DSE is specially modified for export/import on Cassandra.
-
ETL Tools This option is also not free. It requires some softwares to do the export/import data. Some ETL tools that can do this are Jaspersoft, Talend and Pentaho.
COPY airplanes (name, mach, year, manufacturer) TO 'temp.csv'