where some-cassandra is the name you want to assign to your container and tag is the tag specifying the Cassandra version you want. centosip-10-0-0-137 scylla-tools-java cqlsh -k test -e COPY datapointshistorytest FROM tabtest.csv with DELIMITERt -debug Using CQL driver: <. cqlsh utilizes the Python native protocol driver, and connects to the single node specified on the command line. It is shipped with every Cassandra package, and can be found in the bin/ directory alongside the cassandra executable. SWG',NIL,Dhandhuka,1,'Potato, Bajra, Cotton,Д¤,Dholera,72.1934421,22.2498636,NIL,NIL,Dhandhuka,27,'Potato, Bajra, Cotton,ДҐ,Dholka,72.551564,22.946007,NIL,PRC,Dholka,1,'Cotton, Wheat, Paddy, Bajra',NIL,Д¦,Dholka (Veg.),72.551564,22. Starting a Cassandra instance is simple: docker run -name some-cassandra -network some-network -d cassandra:tag. cqlsh is a command line shell for interacting with Cassandra through CQL (the Cassandra Query Language). A subset of columns to copy may be specified by adding a comma-separated. My sample csv csv$ cat -v APMC_market_final.csv |moreДЎ,Barvala,71.895672,22.1542889,NIL,NIL,Bhimnath,10,'Wheat, Jowar, Rai, Bajra',NIДЈ,Dhandhuka,71.9816261,22.3796555,'MCG,CSC, If no columns are specified, all columns from the CSV file will be copied to the table. CREATE KEYSPACE project1 WITH replication = Д¬REATE TABLE markets_by_id (id TEXT, district TEXT, latitude DOUBLE, longitude DOUBLE, godown TEXT, cold_storage TEXT, nrs TEXT, distance DOUBLE, commodity SET, contact TEXT, address TEXT, PRIMARY KEY (id))

Cqlsh copy