cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aaron Morton (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-2221) 'show create' commands on the CLI to export schema
Date Tue, 26 Apr 2011 11:20:03 GMT

     [ 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

Mime
View raw message