[ 
https://issues.apache.org/jira/browse/CASSANDRA-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13024801#comment-13024801
 ] 

Jonathan Ellis commented on CASSANDRA-2221:
-------------------------------------------

It's still valuable to support this from CLI since (a) this gives us an upgrade 
path for 0.7 to 0.8 and (b) CQL isn't going to support all the options for 
0.8.0 (notably counters).

I'd like to introduce a new command though instead of changing an existing one 
in a stable release. "show schema" maybe?

> 'show create' commands on the CLI to export schema
> --------------------------------------------------
>
>                 Key: CASSANDRA-2221
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2221
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Jeremy Hanna
>            Assignee: Aaron Morton
>            Priority: Minor
>              Labels: cli
>             Fix For: 0.8.1
>
>         Attachments: 
> 0001-change-show-keyspace-to-create-cli-script-v0.8.patch, 
> 0001-change-show-keyspace-to-create-cli-script.patch
>
>
> It would be nice to have 'show create' type of commands on the command-line 
> so that it would generate the DDL for the schema.
> A scenario that would make this useful is where a team works out a data model 
> over time with a dev cluster.  They want to use parts of that schema for new 
> clusters that they create, like a staging/prod cluster.  It would be very 
> handy in this scenario to have some sort of export mechanism.
> Another use case is for testing purposes - you want to replicate a problem.
> We currently have schematool for import/export but that is deprecated and it 
> exports into yaml.
> This new feature would just be able to 'show' - or export if they want the 
> entire keyspace - into a script or commands that could be used in a cli 
> script.  It would need to be able to regenerate everything about the keyspace 
> including indexes and metadata.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to