title: cleaning up remains of Datastax Enterprise Hadoop install
body: <p>We have removed the analytics datacenter, but I am seeing lots of stuff hanging around.  For instance keyspaces</p>
  
  <pre><code>select * from schema_keyspaces;
  
  HiveMetaStore |           True |          org.apache.cassandra.locator.SimpleStrategy |        {"replication_factor":"1"}
  </code></pre>
  
  <p>Also I have references to CFSCompactionStrategy left in the log files.  I want to cleanup our ring completely.  No weird keyspaces ... remove CFSCompactionStrategy Ideas?</p>
  
  <p>Edited with some more info from the recommended solution:</p>
  
  <pre><code>UPDATE schema_keyspaces set strategy_options =  '{"Cassandra":"2"}' where keyspace_name in ('keyspace1', 'keyspace2');
  drop keyspace cfs_archive;
  drop keyspace dse_security;
  drop keyspace cfs;
  DROP KEYSPACE "HiveMetaStore";
  </code></pre>
  
  <p>Then clean out the folders...</p>
  
  <p>This may be needed as well:</p>
  
  <pre><code>DELETE from system.schema_columnfamilies where keyspace_name = 'cfs';
  delete from system.schema_columns where keyspace_name in ('cfs', 'cfs_archive');
  </code></pre>