incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhijit Chanda <abhijit.chan...@gmail.com>
Subject Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra
Date Tue, 15 May 2012 09:49:03 GMT
Tamar,

Can you please illustrate little bit with some sample code. It highly
appreciable.

Thanks,

On Tue, May 15, 2012 at 10:48 AM, Tamar Fraenkel <tamar@tok-media.com>wrote:

> I don't think this is possible, the best you can do is prefix, if your
> order is alphabetical. For example I have a CF with comparator UTF8Type,
> and then I can do slice query and bring all columns that start with the
> prefix, and end with the prefix where you replace the last char with the
> next one in order (i.e. "aaa"-"aab").
>
> Hope that helps.
>
> *Tamar Fraenkel *
> Senior Software Engineer, TOK Media
>
> [image: Inline image 1]
>
> tamar@tok-media.com
> Tel:   +972 2 6409736
> Mob:  +972 54 8356490
> Fax:   +972 2 5612956
>
>
>
>
>
> On Tue, May 15, 2012 at 7:56 AM, Abhijit Chanda <abhijit.chanda0@gmail.com
> > wrote:
>
>> I don't know the exact value on a column, but I want to do a partial
>> matching to know all available values that matches.
>> I want to do similar kind of operation that LIKE operator in SQL do.
>> Any help is highly appreciated.
>>
>> --
>> Abhijit Chanda
>> Software Developer
>> VeHere Interactive Pvt. Ltd.
>> +91-9748888395
>>
>>
>


-- 
Abhijit Chanda
Software Developer
VeHere Interactive Pvt. Ltd.
+91-9748888395

Mime
View raw message