[ https://issues.apache.org/jira/browse/CASSANDRA-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452012#comment-13452012 ]
Marcos Dione commented on CASSANDRA-4380: ----------------------------------------- what about the rest of the output? if I run «cqlsh --cqlversion=3», I expect that the output is CQLv3, but for a particular CF that was created with a CQLv2 command, I get: CREATE TABLE logs ( day timestamp PRIMARY KEY ) WITH comment='' AND comparator=text AND read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND default_validation=text 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'; which is only valid in CQLv2; with CQLv3 I get this message: <stdin>:17:Bad Request: No definition found that is not part of the PRIMARY KEY > 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