why do you have 'timestamp_resolution': 'MILLISECONDS'? It should be left as default (MICROSECONDS) unless you do "USING TIMESTAMP <milliseconds>"-inserts, see https://issues.apache.org/jira/browse/CASSANDRA-11041
On Mon, Feb 29, 2016 at 2:36 PM, Noorul Islam K M <noo...@noorul.com> wrote: > > Hi all, > > We are using below compaction settings for a table > > compaction = {'timestamp_resolution': 'MILLISECONDS', > 'max_sstable_age_days': '365', 'base_time_seconds': '60', 'class': > 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy'} > > But it is creating too many sstables. Currently number of sstables > is 40000. We have been injecting data for the last three days. > > We have set the compactionthroughput to 128 MB/s > > $ nodetool getcompactionthroughput > > Current compaction throughput: 128 MB/s > > But this is not helping. > > How can we control the number of sstables in this case? > > Thanks and Regards > Noorul >