I decided to just replace all ":" with "^" and I can simply run:
get  a_b_indx ['AAA:BBB^CCC'];

Tamar Fraenkel 
Senior Software Engineer, TOK Media 

Inline image 1

On Mon, Mar 5, 2012 at 11:58 AM, Rishabh Agrawal <> wrote:

I faced the same issue some time back. Solution which fit my bill is as follows:



    with comparator = 'CompositeType(UTF8Type,UTF8Type)'

    and default_validation_class = 'UTF8Type'

    and key_validation_class = 'CompositeType(UTF8Type,UTF8Type,UTF8Type,)';


notice I have mentioned three datatypes or validators in key_validation_class under CompositeType.


Now if I have to insert with key aaa:bbb:ccc it will work smoothly and even if I wish to insert with just aaa:bbb it will work just fine.


Do let me know if it solves your problem.



RIshabh Agrawal



From: Tamar Fraenkel []
Sent: Monday, March 05, 2012 1:19 PM
Subject: cli question


I have CF with the following deffinition:



    with comparator = 'CompositeType(LongType,UUIDType)'

    and default_validation_class = 'UTF8Type'

    and key_validation_class = 'CompositeType(UTF8Type,UTF8Type)';


Where the key may be a composite of the following two strings: 'AAA' and 'BBB:CCC' 

Notice, that the second string has ':' in it.

I try to query for rows I know exist in the CF but can't.

I tried those and many more :)

  • get  a_b_indx ['AAA:BBB:CCC'];
  • get  a_b_indx ['AAA:BBB\:CCC'];
  • get  a_b_indx [utf8('AAA'):utf8('BBB:CCC')];


Is it possible? Does anyone know how?



Tamar Fraenkel 
Senior Software Engineer, TOK Media 




Impetus’ Head of Innovation labs, Vineet Tyagi will be presenting on ‘Big Data Big Costs?’ at the Strata Conference, CA (Feb 28 - Mar 1)

Listen to our webcast ‘Hybrid Approach to Extend Web Apps to Tablets & Smartphones’ available at

NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.