If this is possible in Cassandra. Data import from remote CSV using cqlsh COPY .
copy transc from 'https://s3-us-west-2.amazonaws.com/abc/abc/abc.csv' with header=true;
Asked
Active
Viewed 1,084 times
1
curiousguy
- 3,212
- 8
- 39
- 71
1 Answers
0
No, you can't import data from remote csv directly
But if you are using linux you can do this with curl+cqlsh
curl 'csv_url' | cqlsh node_ip -u username -p username -k keyspace_name -e "copy views from stdin with header = true"
Example :
curl 'https://pastebin.com/raw/Re6JPaX4' | cqlsh 192.168.65.199 -u cassandra -p cassandra -k test -e "copy views from stdin with header = true"
Ashraful Islam
- 12,470
- 3
- 32
- 53
-
It worked for csv that we do have access. But for s3 security reason its not working . I am using boto3 for that. – curiousguy Apr 10 '17 at 13:29
-
You can add authorization on curl check that http://stackoverflow.com/a/3044340/2320144 – Ashraful Islam Apr 10 '17 at 13:32