Re: Modeling contact list, plain table or List

2016-01-09 Thread Laing, Michael
Note that in C* 3.02 the second query is invalid: cqlsh> Select * from communication.user_contact_list where user_id = 98f50f00-b6d5-11e5-afec-6003089bf572 and is_favorite = true order by contact_name asc; *InvalidRequest: code=2200 [Invalid query] message="PRIMARY KEY column "is_favorite"

Re: Too many compactions, maybe keyspace system?

2016-01-09 Thread Shuo Chen
I don't know what exactly compaction logs is like in system.log. But I see logs like this in system.log, I think maybe this is the compaction log INFO [ScheduledTasks:1] 2016-01-09 22:51:02,664 StatusLogger.java (line 118) ColumnFamilyMemtable ops,data INFO [ScheduledTasks:1]

Re: Modeling contact list, plain table or List

2016-01-09 Thread Isaac P .
Jack/ Michael, Thanks for answering. How big?: Less then one hundred contacts by user is the normal. Update requirements: The UPDATE requirements are all around each user “favoriting/unfavoriting” the contacts . Deleting is not very frequent. Does that mean that in C* 3.02 , for this use