Search code examples
cassandradatastaxcqldatastax-enterprisecqlsh

New DSE Cassandra cluster system.hints missing


I recently installed DSE through LCM . Was just looking at internal keyspace and saw system.hints is missing in the list.

Is it created internally in case of first node failure ?

select table_name from system_schema.tables where keyspace_name = 'system';

               IndexInfo
        available_ranges
                 batches
             built_views
      compaction_history
                   local
                   paxos
             peer_events
                   peers
     prepared_statements
             range_xfers
                 repairs
          size_estimates
        sstable_activity
      transferred_ranges
 view_builds_in_progress

Thanks!


Solution

  • In version Apache Cassandra 3.0+, hints bypass the storage engine altoghether. Instead of storing the hints in a table, the files are stored locally on flat hint files much like commit logs.

    More information on how this works can be found here.