cassandra

cassandra  referances:

//just for my self
create column family User with comparator = UTF8Type;

update column family User with
        column_metadata =
        [
        {column_name: first, validation_class: UTF8Type},
        {column_name: last, validation_class: UTF8Type},
        {column_name: age, validation_class: UTF8Type, index_type: KEYS}
        ];

assume User keys as utf8;

set User['jsmith']['first'] = 'John';
set User['jsmith']['last'] = 'Smith';
set User['jsmith']['age'] = '38';

get User['jsmith'];

get User where age = '12';

update column family address with column_type = 'Super', column_metadata =
[
{column_name: city, validation_class: UTF8Type},
{column_name: zip, validation_class: UTF8Type}
];


create column family address
with column_type = 'Super'
and comparator = UTF8Type
and default_validation_class = UTF8Type
and column_metadata = [
         {column_name : city, validation_class : UTF8Type}
         {column_name : zip, validation_class : LongType}
];

create column family address with column_type='Super';

set address['users']['parts']['engine']='v8';


[default@testkeyspace] assume address comparator as ascii;
[default@testkeyspace] assume address sub_comparator as ascii;
[default@testkeyspace] assume address validator as ascii;

get address['key1'];

http://my.safaribooksonline.com/9781849515122/ch02