On 01/06/2012 01:48 PM, investtr wrote:
Please help me understand this.
I am not sure if this is the right place to ask such question.
I read that it is not safe to use Super Column Family.
And the alternative, I found was to use Composite Column Names.
Many managers will have many employees.
*<<SCF>>Manager_Employee
<<SuperColumnName>>#managerID
<<RowKey>>#employeeID*
So with Composite Column
Should it look like this ?
<<CF>>Manager_Employee
<<RowKey>>#managerID:employeeID
And is this the right approach to deal with not using SCF. Also will
it not create a bigger row size , in case
I have many thousands of messages associated to each user and millions
of users ?
regards,
Ramesh
I found the answer to my question in this example.
HotelByCity (CF) Key: city:state {
key: Phoenix:AZ {AZC_053: -, AZC_011: -}
key: San Francisco:CA {CAS_021: -}
key: New York:NY {NYN_042: -}
}
and this slide
http://www.slideshare.net/edanuff/indexing-in-cassandra
Thanks
Ramesh
