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

Reply via email to