Recovering slices from deep supercolumn families

(3 posts) (2 voices)

• Started 11 months ago by
• Latest reply from
• This topic is not a support question

Tags:

• supercolumns

1. 

   Anonymous
   Unregistered

   We have a supercolumn family of user data that is starting to get rather large, one column in particular is starting to time out when recovering it.

   So we have PlayrUserData[UserKey]StateHistory[TimeStamp]Data where Data is getting too large to return in a single range slice.

   Now I would like to walk through that column retrieving ranges at a time. Is there a way to do this?

   get_slice will retrieve a subset of the columns but each one is returned in full.

   This is particularly annoying when you want to just get the list of columns under a supercolumn - without retrieving all of the data.

   Posted 11 months ago #
2. 

   nickmbailey
   Key Master

   Unfortunately there is no way to slice/stream the data within an single column. You may want to look into using composite columns as that will allow you to add additional nesting to your data which could allow you to split up that large column into a more structured set of columns.

   Additionally, this is a perfect example of why it is generally a bad idea to use super columns. I would recommend migrating your data model away from them.

   http://www.quora.com/Cassandra-database/Why-is-it-bad-to-use-supercolumns-in-Cassandra

   In your case reading any set of columns from within that super column is going to require deserializing the entire contents of the super column in memory.

   Posted 11 months ago #
3. 

   Anonymous
   Unregistered

   OK thanks - our data model is a couple of years old when SuperColumns were still young and fresh and smelled great. How times change.. back to the remodelling board..

   Posted 11 months ago #

RSS feed for this topic

Reply

You must log in to post.