[CASSANDRA-2221] 'show create' commands on the CLI to export schema

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 0.8.4
• Component/s: Legacy/Tools
• Labels: cli
• Assignee: Aaron Morton Assign to me
• Reporter: Jeremy Hanna

Authors

Aaron Morton

Reviewers

Pavel Yaskevich

• Created: 22/Feb/11 20:29
• Updated: 16/Apr/19 09:33
• Resolved: 08/Aug/11 21:08

Description

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.

Issue Links

• depends upon: CASSANDRA-1263 Push replication factor down to the replication strategy