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 ayache.khettar@googlemail.com
 designates 209.85.215.50 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAJwfZdo5hWoULzhoVGm3rqiTtDMx9bL_G5JirQUfyJJR3Bu-XQ@mail.gmail.com>
References: 
 <CAFY8jic+4JFjoHW5Sp0Pmj82eHX0y2-ShgSsMPE+K7nxCs_Uxg@mail.gmail.com>
	<CAJwfZdo5hWoULzhoVGm3rqiTtDMx9bL_G5JirQUfyJJR3Bu-XQ@mail.gmail.com>
Date: Sun, 4 Jan 2015 10:48:33 +0000
Message-ID: 
 <CAJtRc-acgaM9xjMZfDY-+qyLoxUNjDX+YVVN5o6VJ0WLgaRVdg@mail.gmail.com>
Subject: Re: Storing Json format in Hbase
From: Ayache Khettar <ayache.khettar@googlemail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=047d7b3a8ec0b1effe050bd15006

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

Hi

You could perfectly store XML into Hbase without any issue. All depends
what do with the XML. To query back the XML, you will have to store its
 metadata with it using the same row ID. This way you could query back the
XML. I would go for JSON transformation only if the down stream flow needs
the payload in JSON format.

Ayache
On 4 January 2015 at 10:07, Chandrashekhar Kotekar <
shekhar.kotekar@gmail.com> wrote:

> You can convert xml to json using map-reduce program and then store json
> into HBase but you need to decide what should be your row key.
>
> Another point you have to take into account is that if you want to search
> anything inside json or not. If you want to search inside json then HBase
> won't be best option for you. Probably you can switch to MongoDB or some
> other document store.
>
> Hope it helps...
>
> Regards,
> Chandrashekhar
> On 04-Jan-2015 3:32 PM, "Shashidhar Rao" <raoshashidhar123@gmail.com>
> wrote:
>
> > Hi,
> >
> > Can someone guide me if the solution I am proposing is a feasible option
> or
> > not
> >
> > 1. Large xml data is delivered through external system.
> > 2. Convert these into json format.
> > 3. Store it into HBASE ,even though there will be hardly any updates ,
> only
> > retrieval. I have looked at Hive but finally had to decide against it as
> > retrieval would be slow.
> > 4. Need to use Hadoop Nosql as other components are all using Hadoop
> > ecosystem.
> >
> > Can xml data be directly stored into Hbase without any
> > transformation.(second question)
> >
> > Any suggestions on storing xml data on Nosql. (only open source and no
> > commercial nosql)
> >
> > Thanks in advance
> >
> > Shashi
> >
>

--047d7b3a8ec0b1effe050bd15006--