We want to track events in log Cf/table and should be able to query for events that occurred in range of mins or hours for given day. Multiple events can occur in a given minute. Listed 2 table designs and leaning towards table 1 to avoid large wide row. Please advice on
*Table 1*: not very widerow, still be able to query for range of minutes for given day and/or given day and range of hours Create table *log_Event* ( event_day text, event_hr int, event_time timeuuid, data text, PRIMARY KEY ( *(event_day,event_hr),*event_time) ) *Table 2: This will be very wide row* Create table *log_Event* ( event_day text, event_time timeuuid, data text, PRIMARY KEY ( *event_day,*event_time) ) *Datatiered compaction: recommended for time series data as per below doc. Our data will be kept only for 30 days. Hence thought of using this compaction strategy.* http://www.datastax.com/dev/blog/datetieredcompactionstrategy Create table 1 listed above with this compaction strategy. Added some rows and did manual flush. I do not see any sstables created yet. Is that expected? compaction={'max_sstable_age_days': '1', 'class': 'DateTieredCompactionStrategy'}