http://www.datastax.com/support-forums/topic/unable-to-use-or-delete-existing-keyspace-with-capital-letters-in-name Software, Support, and Training for Apache Cassandra en-US Sun, 19 May 2013 11:42:52 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/unable-to-use-or-delete-existing-keyspace-with-capital-letters-in-name#post-8048 Fri, 21 Dec 2012 03:58:03 +0000 jpotter 8048@http://www.datastax.com/support-forums/ <p>Ah, that makes sense; thanks Nick.</p> <p>I've issued the drop command, but the keyspace is still listed in "select * from system.schema_keyspaces;" a few minutes later; nothing jumps out in the error logs. I'll take another pass at it tomorrow; regardless; this issue -- case sensitivity -- is definitely resolved. </p> http://www.datastax.com/support-forums/topic/unable-to-use-or-delete-existing-keyspace-with-capital-letters-in-name#post-8032 Thu, 20 Dec 2012 16:03:45 +0000 nickmbailey 8032@http://www.datastax.com/support-forums/ <p>Because cql3 is case insensitive you will need to use quotes.</p> <p>drop keyspace "OpsCenter";</p> <p>I'll also just let you know that OpsCenter is compatible with bare Apache Cassandra as well as the DataStax distributions. </p> http://www.datastax.com/support-forums/topic/unable-to-use-or-delete-existing-keyspace-with-capital-letters-in-name#post-8031 Thu, 20 Dec 2012 16:00:09 +0000 jpotter 8031@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>We're running a cluster of cassandra 1.1.4 (that was initially started as a 1.0.x cluster) that has a keyspace, OpsCode, from when we first started using DSE (but had to switch to apache cassandra for features in 1.1.x that we needed).</p> <p>In trying to track down another issue, I'm noticing that we have an old keyspace, OpsCode, that I can't access or drop.</p> <p>While it's "probably" harmless to leave around, I'd rather clean it up, but am not sure how to do this safely -- the only guess I'd venture is to shut down the cluster, remove the keyspace's directory, and restart it -- but no idea if this is sane at all.</p> <p>Suggestions?</p> <p>cqlsh&gt; select * from system.schema_keyspaces;<br /> keyspace | durable_writes | name | strategy_class | strategy_options<br /> -----------+----------------+-----------+------------------------------------------------------+----------------------------<br /> OpsCenter | True | OpsCenter | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"2"}<br /> ...</p> <p>cqlsh&gt; use OpsCenter;<br /> Bad Request: Keyspace 'opscenter' does not exist</p> <p>cqlsh&gt; drop keyspace OpsCenter;<br /> Bad Request: org.apache.cassandra.config.ConfigurationException: Cannot drop non existing keyspace 'opscenter'.</p> <p>ls -l data/OpsCenter/<br /> total 32<br /> drwxr-xr-x 3 app app 4096 2012-12-20 06:41 events<br /> drwxr-xr-x 3 app app 4096 2012-12-20 06:41 events_timeline<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 pdps<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 rollups300<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 rollups60<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 rollups7200<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 rollups86400<br /> drwxr-xr-x 2 app app 4096 2012-10-29 00:24 settings </p>