Actually woman ;-) *Tamar Fraenkel * Senior Software Engineer, TOK Media
[image: Inline image 1]
ta...@tok-media.com
Tel: +972 2 6409736
Mob: +972 54 8356490
Fax: +972 2 5612956
On Tue, May 15, 2012 at 3:45 PM, Abhijit Chanda
<abhijit.chan...@gmail.com>wrote:
> Thanks so much Guys, specially Tamar, thank you so much man.
>
> Regards,
> Abhijit
>
>
> On Tue, May 15, 2012 at 4:26 PM, Tamar Fraenkel <ta...@tok-media.com>wrote:
>
>> Do you still need the sample code? I use Hector, well here is an example:
>> *This is the Column Family definition:*
>> (I have a composite, but if you like you can have only the UTF8Type).
>>
>> CREATE COLUMN FAMILY title_indx
>> with comparator = 'CompositeType(UTF8Type,UUIDType)'
>> and default_validation_class = 'UTF8Type'
>> and key_validation_class = 'LongType';
>>
>> *The Query:*
>> SliceQuery<Long, Composite, String> query =
>> HFactory.createSliceQuery(CassandraHectorConn.getKeyspace(),
>> LongSerializer.get(),
>> CompositeSerializer.get(),
>> StringSerializer.get());
>> query.setColumnFamily("title_indx");
>> query.setKey(...)
>>
>> Composite start = new Composite();
>> start.add(prefix);
>> char c = lowerCasePrefix.charAt(lastCharIndex);
>> String prefixEnd = prefix.substring(0, lastCharIndex) + ++c;
>> Composite end = new Composite();
>> end.add(prefixEnd);
>>
>> ColumnSliceIterator<Long, Composite, String> iterator =
>> new ColumnSliceIterator<Long, Composite, String>(
>> query, start, end, false)
>> while (iterator.hasNext()) {
>> ...
>> }
>>
>> Cheers,
>>
>> *Tamar Fraenkel *
>> Senior Software Engineer, TOK Media
>>
>> [image: Inline image 1]
>>
>> ta...@tok-media.com
>> Tel: +972 2 6409736
>> Mob: +972 54 8356490
>> Fax: +972 2 5612956
>>
>>
>>
>>
>>
>> On Tue, May 15, 2012 at 1:19 PM, samal <samalgo...@gmail.com> wrote:
>>
>>> You cannot extract via relative column value.
>>> It can only extract via value if it has secondary index but exact column
>>> value need to match.
>>>
>>> as tamar suggested you can put value as column "name" , UTF8 comparator.
>>>
>>> {
>>> 'name_abhijit'=>'abhijit'
>>> 'name_abhishek'=>'abhiskek'
>>> 'name_atul'=>'atul'
>>> }
>>>
>>> here you can do slice query on column name and get desired result.
>>>
>>> /samal
>>>
>>> On Tue, May 15, 2012 at 3:29 PM, selam <selam...@gmail.com> wrote:
>>>
>>>> Mapreduce jobs may solve your problem for batch processing
>>>>
>>>>
>>>> On Tue, May 15, 2012 at 12:49 PM, Abhijit Chanda <
>>>> abhijit.chan...@gmail.com> wrote:
>>>>
>>>>> 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
>>>>> <ta...@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]
>>>>>>
>>>>>> ta...@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.chan...@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
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Saygılar && İyi Çalışmalar
>>>> Timu EREN ( a.k.a selam )
>>>>
>>>
>>>
>>
>
>
> --
> Abhijit Chanda
> Software Developer
> VeHere Interactive Pvt. Ltd.
> +91-9748888395
>
>
<<tokLogo.png>>
<<tokLogo.png>>
