[
https://issues.apache.org/jira/browse/CASSANDRA-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452147#comment-13452147
]
Sylvain Lebresne commented on CASSANDRA-4380:
---------------------------------------------
bq. It doesn't for the cases where there are multiple columns with metadata in
addition to undefined/wide-row columns
That's true on 1.1 but I'll note that for 1.2, provided you use the
system.schema_columnfamilies table, it should (almost) always be possible to
create a valid CQL3 definition from an existing CF (potentially, and almost
always in the case of CF created from thrift/CQL2, with COMPACT STORAGE). The
only thing that comes in mind that makes me say "almost" is the case where
people have created on the thrift side a column_metadata on a CompositeType. In
that last case we can create a CQL3 query to recreate the CF, but not the
column_metadata. I think it's safe to say that we can ignore that.
bq. some made-up default column names
The Cassandra already does that (so that you can always access thrift CF from
CQL3), see CFDefinition.java. It could be worth using the same made-up names
here.
> CQLSH: describe command doesn't output valid CQL command.
> ---------------------------------------------------------
>
> Key: CASSANDRA-4380
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4380
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.0
> Reporter: Nick Bailey
> Assignee: paul cannon
> Labels: cqlsh
> Fix For: 1.1.3
>
>
> {noformat}
> cqlsh:test> describe columnfamily stats;
> CREATE TABLE stats (
> gid blob PRIMARY KEY
> ) WITH
> comment='' AND
>
> comparator='CompositeType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.BytesType,org.apache.cassandra.db.marshal.UTF8Type)'
> AND
> read_repair_chance=0.100000 AND
> gc_grace_seconds=864000 AND
> default_validation=blob AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> replicate_on_write='true' AND
> compaction_strategy_class='SizeTieredCompactionStrategy' AND
> compression_parameters:sstable_compression='SnappyCompressor';
> {noformat}
> I can create a cf in cql3 and then use describe cf to get the above output.
> However trying to run that create statement says that all of the following
> are invalid options:
> * default_validation
> * min_compaction_threshold
> * max_compaction_threshold
> * comparator
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
