How do data model a recursive message in Cassandra

[shyla deshpande]

Hi All,

The protobuf message 'sessionproto'  that I receive has a field that is
recursive. How do I define a data model in Cassandra to store this
data. itemrelationproto
references itemgroupproto and itemgroupproto references itemrelationproto .
Thanks.

message itemrelationproto {

    optional string id = 1;

    optional itemgroupproto itemgroup = 2;

}



message itemgroupproto {

    optional string id = 1;

    optional string displayname = 2;

    repeated itemrelationproto itemrelations = 3;

}



message sessionproto {

    optional string sessionid = 1;

    optional string displayname = 3;

    repeated itemrelationproto itemrelations = 4;

}


create type itemrelationproto (

 id text,

 itemgroup frozen<itemgroupproto>

);



create type itemgroupproto (

 id text,

 displayname text,

 itemrelations set<frozen<itemrelationproto>>

);



create table sessionproto (

 sessionid text,

 displayname text,

 itemrelations set<frozen<itemrelationproto>,

 primary key (sessionid)

);