On Tue, 13 Apr 2010 10:19:23 -0500 Ted Zlatanov <t...@lifelogs.com> wrote:
TZ> I think everyone agrees loadSchemaFromXML can go away after 0.7 but just TZ> to be clear, you don't think Cassandra after 0.7 should come bundled TZ> with a tool that can dump, clear, and restore the schema? It's trivial TZ> to implement some very basic support for that without trying to provide TZ> a full management tool. TZ> I think it would be a big help for new users, troubleshooting (because TZ> you don't depend on tollkit X or language Y to know the true schema from TZ> the server's POV), those who want to share schema definitions and tests TZ> without external dependencies, and sysadmins who don't want to install TZ> another language to do a schema backup. I have had no reply to this so I'll just do it from the Perl side; I opened https://issues.apache.org/jira/browse/CASSANDRA-979 which is necessary to implement this tool from the client side. cassidy.pl, which is bundled with Net::Cassandra::Easy, already supports keyspace and family define/rename/delete operations so if this ticket is done then it (and other Thrift clients) can do schema introspection. At least in cassidy.pl I've implemented these commands: (with active keyspace "system") kdefine testks org.apache.cassandra.locator.RackUnawareStrategy 1 org.apache.cassandra.locator.EndPointSnitch' krename testks testks2 kdelete testks2 (with active keyspace "testks") fdefine testcf Super LongType BytesType comment=statuschanges,row_cache_size=0,key_cache_size=20000' frename testcf testcf2 fdelete testcf2 but as I said, it would be nice if there was a neutral format to express this schema. YAML would be best. Ted