[
https://issues.apache.org/jira/browse/CASSANDRA-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aaron Morton updated CASSANDRA-2221:
------------------------------------
Attachment: 0001-add-show-schema-statement-8.patch
0001-add-show-schema-statement.patch
Updated patches for 07 and 08.
- show keyspaces returned to normal
- added show schema <keyspace>?;
Sample from 0.8
{noformat}
[default@Keyspace1] show schema Keyspace1;
create keyspace Keyspace1
with placement_strategy = 'SimpleStrategy'
and strategy_options = [{replication_factor : 1}];
use Keyspace1;
create column family Counter1
with column_type = 'Standard'
and comparator = 'BytesType'
and default_validation_class = 'CounterColumnType'
and key_validation_class = 'BytesType'
and memtable_operations = 0.29062499999999997
and memtable_throughput = 62
and memtable_flush_after = 1440
and rows_cached = 0.0
and row_cache_save_period = 0
and keys_cached = 200000.0
and key_cache_save_period = 14400
and read_repair_chance = 1.0
and gc_grace = 864000
and min_compaction_threshold = 4
and max_compaction_threshold = 32
and replicate_on_write = false
and row_cache_provider = 'ConcurrentLinkedHashCacheProvider';
{noformat}
> '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-add-show-schema-statement-8.patch,
> 0001-add-show-schema-statement.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
