Home | Forums | SDKs | SDKs

Query using "LIKE" functionality

6 replies [Last post]
Fri, 08/17/2012 - 13:00
cb
Offline
Joined: 08/10/2012
Groups: None

hi,

I'm using the Java Client API (2.0) and would like to create a query that find matching strings according to a given sub-string. It is very similar to SQL LIKE dialect.

I was hoping to do this without fetching all rows and filtering on the client side. Is there a way to do that on the server side? If so - an example would be great.

Thanks,
CB.

Top
Wed, 08/22/2012 - 00:10
ingenthr
Offline
Joined: 03/16/2010
Groups:

There isn't anything for a "like" at the moment, but do stay tuned. You can do left-handled substring matches (effectively, range queries) pretty easily with Couchbase Server 2.0.

Top
Fri, 08/24/2012 - 21:04
cb
Offline
Joined: 08/10/2012
Groups: None

I know that Cloudant (which also forked CouchDB) integrated a Lucene based search capability which is really powerful. They even claim that the Lucene index and search engine are distributed on the cluster.

Do you guys plan anything in that direction? full text searching is a killer IMHO

Finally - can you please provide a code example of what you refer to as "you can do left-handled substring matches (effectively, range queries)"

Thanks,
CB.

Top
Fri, 09/14/2012 - 11:48
adavidson
Offline
Joined: 09/11/2012
Groups: None

Yeah queries based on substring matches or a regex match would be awesome.

Top
Fri, 09/14/2012 - 12:17
ingenthr
Offline
Joined: 03/16/2010
Groups:

Check back one week from today. :)

Top
Mon, 09/24/2012 - 09:23
adavidson
Offline
Joined: 09/11/2012
Groups: None

checking back...

Top
Mon, 10/01/2012 - 13:50
john
Offline
Joined: 01/05/2012
Groups: None

http://blog.couchbase.com/couchbase-and-full-text-search-couchbase-trans...

Top