Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of anilgupta84@gmail.com
 designates 209.85.212.41 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPQV63UB4r0Bph2O-cwqPXF-LcRu1u2Z845BEXLpbg6g2Tqcqw@mail.gmail.com>
References: 
 <CAH-_ydjNrWs+mJS+XZQBsKfcj7KSTzMMshqP+YnKkDMuORHi+g@mail.gmail.com>
 <CAPQV63UB4r0Bph2O-cwqPXF-LcRu1u2Z845BEXLpbg6g2Tqcqw@mail.gmail.com>
From: anil gupta <anilgupta84@gmail.com>
Date: Tue, 20 Nov 2012 23:44:47 -0800
Message-ID: 
 <CAF1+Vs_v9jmCt0fr5ji+5fWS+zUhCs-25rWwqvgp3geq9o4QBg@mail.gmail.com>
Subject: Re: Problem with xml data in hbase bulk loading
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=20cf307abe09805e8104cefc87a1

--20cf307abe09805e8104cefc87a1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

There are two option:
1. Fix the input file so that one line contains an entire record.
2. Write a custom input format to read record which spans multiple lines.
If you do this then you will need to write a custom Mapper also. For
reference implementation of custom mapper you can have a look at ImportTsv
class in HBase.

HTH,
Anil Gupta


On Tue, Nov 20, 2012 at 3:59 AM, Jean-Marc Spaggiari <
jean-marc@spaggiari.org> wrote:

> Hi
>
> In csv files, new line =3D new entry :(
>
> So I think your only option is to fix your input file by removing your
> extra lines.
>
> JM
> Le 20 nov. 2012 02:55, "iwannaplay games" <funnlearnforkids@gmail.com> a
> =E9crit :
>
> > Hi All,
> >
> > I have a csv file ( separated by |) where data is like
> >
> > id               data
> >                                date
> > 1            apple
> >                          24-nov-2011
> > 2            mango
> >                        26-nov-2011
> > 3            <?xml version=3D"1.0" encoding=3D"utf-8"?>
> >                  <a>fruits</a>
> >                        28-nov-2011
> > 4             papaya
> >                         30-nov-2011
> >
> >
> > Since id=3D3 has new line in data field hbase importtsv takes only firs=
t
> > line and treats second line as different row.I want my full xml field
> > to be taken inside data in hbase table .
> >
> > ./hadoop jar /usr/local/hbase/hbase-0.92.1.jar importtsv
> > -Dimporttsv.bulk.output=3Deve
> > -Dimporttsv.columns=3DHBASE_ROW_KEY,el:data,el:Date
> > '-Dimporttsv.separator=3D|'  fruits /fruits/fr
> >
> > How to treat xml data in hbase while doing bulk load
> >
> > Thanks & Regards
> > Prabhjot
> >
>


--=20
Thanks & Regards,
Anil Gupta

--20cf307abe09805e8104cefc87a1--