querying by column value rather than key value

2008-05-29 Thread Shimon
Hi, What is most efficient way to retrieve a row when the value of a certain column is specified ( rather than the row key ) ? Thanks in advance

Re: querying by column value rather than key value

2008-05-29 Thread shimon golan
Thanx Bryan for the quick response ! My table is very sparse and contains 100 column families , each containing about 20 items. Also, I need to search the table by each of the columns so the solution you suggested seems somewhat complicated for this purpose. So my ensuing questions are : 1. Do

Re: querying by column value rather than key value

2008-05-29 Thread Bryan Duxbury
Right now, we don't have a plan to add indexing. It's a particularly complicated area of functionality. We'd love to get suggestions (or patches :) for how to do this the right way. Map/reduce would be the perfect way to find all records that matched on a column value, so long as you're

Re: querying by column value rather than key value

2008-05-29 Thread Jim R. Wilson
Hi Shimon, You may also want to look into a text indexing solution such as Lucene or Ferret. These systems might be able to provide the search capabilities you require. Of course, it'd be your responsibility to keep the indexes up to date. -- Jim R. Wilson (jimbojw) On Thu, May 29, 2008 at

Re: querying by column value rather than key value

2008-05-29 Thread stack
Jim R. Wilson wrote: Hi Shimon, You may also want to look into a text indexing solution such as Lucene or Ferret. These systems might be able to provide the search capabilities you require. Of course, it'd be your responsibility to keep the indexes up to date. For the initial indexing of

Re: Does HBase support single-row transaction?

2008-05-29 Thread Clint Morgan
When the application creates an entity, it can assign another entity as the parent of the new entity. Assigning a parent to a new entity puts the new entity in the same entity group as the parent entity. I think I need to sign up for app engine and use it to see if I can figure how the above

Re: querying by column value rather than key value

2008-05-29 Thread Jim R. Wilson
He's saying that if you're going to be searching for one random thing at a time, and you want it to be /fast/, then issuing a full table scan to a hadoop cluster as a map/reduce job is not a good solution. It's not really practical to send out a swarm of nodes hunting through your whole dataset

how to use new shell from trunk ?

2008-05-29 Thread cure
Hello i checkout hbase from trunk and i see that there is new version of the hbase shell. i see in comments that it base on jruby..., but how can i use it ? unfortunatelly old shell has been removed. Best regards - Antony

Re: how to use new shell from trunk ?

2008-05-29 Thread stack
Shell support is in a state of flux at the moment. Meantime, your only avenue is typing ruby at the proffered irb prompt. See this page for example code: http://wiki.apache.org/hadoop/Hbase/JRuby St.Ack [EMAIL PROTECTED] wrote: Hello i checkout hbase from trunk and i see that there is