> I have cleaned up my code that imports CSV into Cassandra and I have
put it open on https://github.com/nehalmehta/CSV2Cassandra. Have a look
if it is useful to you.
Hello,
I will remake this tool into something which is like Oracle
SQL*Loader. Basically, you will pass controlfile as command line
argument. I need conversion from DATE to milliseconds based date, header
less CSV and better CSV escaping.
example of control file
options (rows=1000)
LOAD DATA
INFILE 'c:\tmp\searches.csv'
BADFILE 'c:\tmp\searches.bad'
REPLACE
INTO TABLE SEARCHES2
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
( query,
day date 'YYYY-MM-DD',
results,
ip
)
or maybe i will start project from 0
