Laurent Hatier 2011-08-10, 17:02
Chris Tarnas 2011-08-10, 17:09
Laurent Hatier 2011-08-10, 20:15
Li Pi 2011-08-10, 20:26
Edward Capriolo 2011-08-11, 00:44
Ryan Rawson 2011-08-11, 00:57
Blake Lemoine 2011-08-11, 03:07
Li Pi 2011-08-11, 03:18
Fuad Efendi 2011-08-11, 03:12
Jason Rutherglen 2011-08-11, 05:48
Laurent Hatier 2011-08-11, 08:13
Sorry for off topic, but just as a sample to understand fundamental
1. "SELECT COUNT" will take few hours on MySQL InnoDB in most typical
cases, and _it_is_ implemented.
2. Same with HBase: full table scan. However, with MapReduce it might take
less time. Or, we can query Solr (Lily-way) to get number of records, but
data won't be absolutely correct.
Just as a sample
Of course, we can "transactionally" store number of records somewhere and
Another solution is to use fixed-width records (similar to MyISAM) - but
data will be sparse etc.
Lily provides Hbase -based "Write Ahead Log", Hbase-based "Message Queue",
and Hbase -based "Secondary Index" (separate library); and it also
provides framework support to subscribe to a queue of messages.
On 11-08-11 4:13 AM, "Laurent Hatier" <[EMAIL PROTECTED]> wrote:
>i've seen that there is no limit with HBase. I mean the following
>: "SELECT ... FROM ... LIMIT 1". (Because there is this method with
>Is it implemented ?
>2011/8/11 Jason Rutherglen <[EMAIL PROTECTED]>
>> This could be implemented with Lucene, eg, HBASE-3529. Contact me
>> offline if you are interested in pursuing that angle.
>> On Wed, Aug 10, 2011 at 10:02 AM, Laurent Hatier
>> <[EMAIL PROTECTED]> wrote:
>> > Hi all,
>> > I would like to know why MongoDB is faster than HBase to select items.
>> > I explain my case :
>> > I've inserted 4'000'000 lines into HBase and MongoDB and i must
>> > the geolocation with the IP. I calculate a Long number with the IP
>> > to find it into the 4'000'000 lines.
>> > it's take 5 ms to select the right row with Mongo instead of HBase
>> > seconds.
>> > I think that the reason is the method : cur.limit(1) with MongoDB but
>> > there no function like this with HBase ?
>> > --
>> > Laurent HATIER
>> > Étudiant en 2e année du Cycle Ingénieur à l'EISTI
>Étudiant en 2e année du Cycle Ingénieur à l'EISTI