Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase, mail # user - Miserable Performance of gets


+
kiran 2013-03-06, 04:36
Copy link to this message
-
Re: Miserable Performance of gets
Ted Yu 2013-03-06, 04:57
Which HBase version are you using ?

bq. But even for 20 gets
These were issued against the second table ?

Thanks

On Tue, Mar 5, 2013 at 8:36 PM, kiran <[EMAIL PROTECTED]> wrote:

> Dear All,
>
> I had some miserable experience with gets (batch gets) in hbase. I have two
> tables with different rowkeys, columns are distributed across the two
> tables.
>
> Currently what I am doing is scan over one table and get all the rowkeys in
> the first table matching my filter. Then issue a batch get on another table
> to retrieve some columns. But even for 20 gets, the performance is like
> miserable (almost a second or two for 20 gets which is not acceptable).
> But, scanning even on few thousands of rows is getting completed in
> milliseconds.
>
> My concern is for about 20 gets if it takes second or two,
> How can it scale ??
> Will the performance be the same even if I issue 1000 gets ??
> Is it advisable in hbase to avoid gets ??
>
> I can include all columns in only one table and do a scan also, but before
> doing that I need to really understand the issue...
>
> Is scanning a better solution for scalability and performance ???
>
> Is it advisable not to do joins or normalizations in NOSQL databases,
> include all the data in only table and not do joins with another table ??
>
>
> --
> Thank you
> Kiran Sarvabhotla
>
> -----Even a correct decision is wrong when it is taken late
>
+
kiran 2013-03-06, 05:06
+
lars hofhansl 2013-03-06, 05:13
+
kiran 2013-03-06, 05:24
+
lars hofhansl 2013-03-06, 05:29
+
kiran 2013-03-06, 06:38
+
kiran 2013-03-06, 06:42
+
lars hofhansl 2013-03-06, 07:05
+
kiran 2013-03-06, 05:26
+
Anoop Sam John 2013-03-06, 05:12
+
Stack 2013-03-06, 06:51
+
kiran 2013-03-06, 07:00
+
Stack 2013-03-06, 07:02
+
kiran 2013-03-06, 07:01