Re: Apache Cassandra - Question about data model

2015-12-31 Thread Lior Menashe
Hi Matthias, Thanks for your answer. According to what you've wrote, if i will select the first 30 lines from the feed table to a user i'll need to perform up to 30 more queries to the user table in order to get the users data. Isn't it better to use Cassandra for the feed and Some Sql Server to

Re: Apache Cassandra - Question about data model

2015-12-31 Thread Jack Krupansky
It's best to ask usage and data modeling questions on the user email list - this list is the dev list, for development of Cassandra itself, not for development of applications. See: http://cassandra.apache.org/ -- Jack Krupansky On Thu, Dec 31, 2015 at 8:36 AM, Lior Menashe wrote: > Hi, > > J

Re: Apache Cassandra - Question about data model

2015-12-31 Thread Matthias Eichstaedt
Hi Lior, how about something like this where you separate the user fields into a separate USER_TABLE: FEED_TABLE userID UDID (partition key) datetimeadded timestamp (clustering column DESC) userID_From UDID (this is userB from the example) USER_TABLE userID UDID (partition key) userID_Name text u

Apache Cassandra - Question about data model

2015-12-31 Thread Lior Menashe
Hi, Just got your mail from the #cassandra channel on the web chat because i couldn't get an answer... I have a question that i'll be glad if you can help me or give me a direction. I have an activity feed like the activity feed on Instagram. When user (lets say UserA) enters his page he can see