Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of tyler@datastax.com designates
 209.85.213.177 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABx2S-eAddOwZuSLrJPpnF9q2z4EAmNzYW=UdX5V-WWiAg-Qhw@mail.gmail.com>
References: 
 <CABx2S-eAddOwZuSLrJPpnF9q2z4EAmNzYW=UdX5V-WWiAg-Qhw@mail.gmail.com>
From: Tyler Hobbs <tyler@datastax.com>
Date: Tue, 24 Mar 2015 17:55:06 -0500
Message-ID: 
 <CAAam9ssk4qKi00g1uagNXyKcTwt-DPMLq-iesZswtFz+iWfqGw@mail.gmail.com>
Subject: Re: error in bulk loading
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7bdc0dd2b7fcf8051210adfb

--047d7bdc0dd2b7fcf8051210adfb
Content-Type: text/plain; charset=UTF-8

On Tue, Mar 24, 2015 at 5:30 AM, Rahul Bhardwaj <
rahul.bhardwaj@indiamart.com> wrote:

> I need to import a csv file to a table using copy command, but file
> contains carriage returns which causing me problem in doing so, Is there
> any way in cassandra to solve this


You can surround the field with double-quotes to handle this (or change the
quote character with the QUOTE option for COPY).

-- 
Tyler Hobbs
DataStax <http://datastax.com/>

--047d7bdc0dd2b7fcf8051210adfb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">=
On Tue, Mar 24, 2015 at 5:30 AM, Rahul Bhardwaj <span dir=3D"ltr">&lt;<a hr=
ef=3D"mailto:rahul.bhardwaj@indiamart.com" target=3D"_blank">rahul.bhardwaj=
@indiamart.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I ne=
ed to import a csv file to a table using copy command, but file contains ca=
rriage returns which causing me problem in doing so, Is there any way in ca=
ssandra to solve this</blockquote></div></div><div class=3D"gmail_extra"><b=
r></div><div class=3D"gmail_extra">You can surround the field with double-q=
uotes to handle this (or change the quote character with the QUOTE option f=
or COPY).<br clear=3D"all"></div><div class=3D"gmail_extra"><br>-- <br><div=
 class=3D"gmail_signature"><font color=3D"#888888">Tyler Hobbs<span></span>=
<br>
<a href=3D"http://datastax.com/" target=3D"_blank">DataStax</a><br></font><=
/div>
</div></div>

--047d7bdc0dd2b7fcf8051210adfb--