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"
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]
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