Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4E81DEAC.9010103@sendmail.cz>
Date: Tue, 27 Sep 2011 16:33:16 +0200
From: Radim Kolar <hsn@sendmail.cz>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
 rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: Tool for SQL -> Cassandra data movement
References: <4E7AFA5B.4080507@sendmail.cz>
 <CA+MDaqYeqSW138got_D90yLnkhUgTXee_nYGiVj26hjf=C120A@mail.gmail.com>
 <4E7B75E7.6050901@sendmail.cz>
 <CA+MDaqYpu+i5rEFZ1CpoobbXbu-20pq8hCKn9NjEzDcrnNbEeQ@mail.gmail.com>
In-Reply-To: 
 <CA+MDaqYpu+i5rEFZ1CpoobbXbu-20pq8hCKn9NjEzDcrnNbEeQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 > 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