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 mohitanchlia@gmail.com
 designates 209.85.223.177 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAMVC6ROcdTkS2CTT8DZ4XNAhgiE22KMr=ErMLzH5XrjUKUt5vA@mail.gmail.com>
References: <1357380684848-4036184.post@n3.nabble.com>
	<CADK=YxvUiBaGZzjhX8yV3P+xfcJZAn8wF7=_J1zqtguFRDDjHw@mail.gmail.com>
	<CADSMiU_QPEyY9W7e7Qa+qOCza3XMSQxepMh9TDEA8AgFPVPq+g@mail.gmail.com>
	<CA+RK=_Bto1neL3nS89k5Ecz58kaQC7sqmr5po0CZeMChwp0xrw@mail.gmail.com>
	<3702994083872207037@unknownmsgid>
	<CA+RK=_BDWMQYLhZSOGhsKmbydz=Xk5j+2uY0HSv0ED37bUtcjA@mail.gmail.com>
	<CA+RK=_DUqn41hCnbkZqRpxJ6Wwtnxoxx4Jy3Oas_cFG_oJxFpA@mail.gmail.com>
	<CAOT3TWqT4QL+kveZHT70g-78EAQvWT+-y_c==+XmDsPg4Ky7oQ@mail.gmail.com>
	<CAHyy+G-mcPDavxn3MgL2dEjJKLPBY171Y6Jz-mqsnr1opJWtEg@mail.gmail.com>
	<1357876263.21531.YahooMailNeo@web140603.mail.bf1.yahoo.com>
	<CAAXmExWrU+WZsiq7U=mzAcBzBwEh0HSw-apboHV_N1fbVqPfYg@mail.gmail.com>
	<BLU0-SMTP216C10683D4CA80FC39BBE58F290@phx.gbl>
	<CAMVC6ROcdTkS2CTT8DZ4XNAhgiE22KMr=ErMLzH5XrjUKUt5vA@mail.gmail.com>
Date: Fri, 11 Jan 2013 09:40:38 -0800
Message-ID: 
 <CAOT3TWpxkLEh2y3PQvdZjBRuro3-4xdSQ3MGeiqHM_t7Z_9cLQ@mail.gmail.com>
Subject: Re: Storing images in Hbase
From: Mohit Anchlia <mohitanchlia@gmail.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=e89a8f234d6d2ca39f04d306cbcb

--e89a8f234d6d2ca39f04d306cbcb
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I think it really depends on volume of the traffic, data distribution per
region, how and when files compaction occurs, number of nodes in the
cluster. In my experience when it comes to blob data where you are serving
10s of thousand+ requests/sec writes and reads then it's very difficult to
manage HBase without very hard operations and maintenance in play. Jack
earlier mentioned they have 1 billion images, It would be interesting to
know what they see in terms of compaction, no of requests per sec. I'd be
surprised that in high volume site it can be done without any Caching layer
on the top to alleviate IO spikes that occurs because of GC and compactions=
.

On Fri, Jan 11, 2013 at 7:27 AM, Mohammad Tariq <dontariq@gmail.com> wrote:

> IMHO, if the image files are not too huge, Hbase can efficiently serve th=
e
> purpose. You can store some additional info along with the file depending
> upon your search criteria to make the search faster. Say if you want to
> fetch images by the type, you can store images in one column and its
> extension in another column(jpg, tiff etc).
>
> BTW, what exactly is the problem which you are facing. You have written
> "But I still cant do it"?
>
> Warm Regards,
> Tariq
> https://mtariq.jux.com/
>
>
> On Fri, Jan 11, 2013 at 8:30 PM, Michael Segel <michael_segel@hotmail.com
> >wrote:
>
> > That's a viable option.
> > HDFS reads are faster than HBase, but it would require first hitting th=
e
> > index in HBase which points to the file and then fetching the file.
> > It could be faster... we found storing binary data in a sequence file a=
nd
> > indexed on HBase to be faster than HBase, however, YMMV and HBase has
> been
> > improved since we did that project....
> >
> >
> > On Jan 10, 2013, at 10:56 PM, shashwat shriparv <
> dwivedishashwat@gmail.com>
> > wrote:
> >
> > > Hi Kavish,
> > >
> > > i have a better idea for you copy your image files to a single file o=
n
> > > hdfs, and if new image comes append it to the existing image, and kee=
p
> > and
> > > update the metadata and the offset to the HBase. Because if you put
> > bigger
> > > image in hbase it wil lead to some issue.
> > >
> > >
> > >
> > > =E2=88=9E
> > > Shashwat Shriparv
> > >
> > >
> > >
> > > On Fri, Jan 11, 2013 at 9:21 AM, lars hofhansl <larsh@apache.org>
> wrote:
> > >
> > >> Interesting. That's close to a PB if my math is correct.
> > >> Is there a write up about this somewhere? Something that we could li=
nk
> > >> from the HBase homepage?
> > >>
> > >> -- Lars
> > >>
> > >>
> > >> ----- Original Message -----
> > >> From: Jack Levin <magnito@gmail.com>
> > >> To: user@hbase.apache.org
> > >> Cc: Andrew Purtell <apurtell@apache.org>
> > >> Sent: Thursday, January 10, 2013 9:24 AM
> > >> Subject: Re: Storing images in Hbase
> > >>
> > >> We stored about 1 billion images into hbase with file size up to 10M=
B.
> > >> Its been running for close to 2 years without issues and serves
> > >> delivery of images for Yfrog and ImageShack.  If you have any
> > >> questions about the setup, I would be glad to answer them.
> > >>
> > >> -Jack
> > >>
> > >> On Sun, Jan 6, 2013 at 1:09 PM, Mohit Anchlia <mohitanchlia@gmail.co=
m
> >
> > >> wrote:
> > >>> I have done extensive testing and have found that blobs don't belon=
g
> in
> > >> the
> > >>> databases but are rather best left out on the file system. Andrew
> > >> outlined
> > >>> issues that you'll face and not to mention IO issues when compactio=
n
> > >> occurs
> > >>> over large files.
> > >>>
> > >>> On Sun, Jan 6, 2013 at 12:52 PM, Andrew Purtell <apurtell@apache.or=
g
> >
> > >> wrote:
> > >>>
> > >>>> I meant this to say "a few really large values"
> > >>>>
> > >>>> On Sun, Jan 6, 2013 at 12:49 PM, Andrew Purtell <
> apurtell@apache.org>
> > >>>> wrote:
> > >>>>
> > >>>>> Consider if the split threshold is 2 GB but your one row contains
> 10
> > >> GB
> > >>>> as
> > >>>>> really large value.
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>> --
> > >>>> Best regards,
> > >>>>
> > >>>>   - Andy
> > >>>>
> > >>>> Problems worthy of attack prove their worth by hitting back. - Pie=
t
> > Hein
> > >>>> (via Tom White)
> > >>>>
> > >>
> > >>
> >
> >
>

--e89a8f234d6d2ca39f04d306cbcb--