incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Radim Kolar <...@sendmail.cz>
Subject Re: Tool for SQL -> Cassandra data movement
Date Tue, 27 Sep 2011 14:33:16 GMT
 > 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

Mime
View raw message