Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 11 Sep 2012 03:02:07 +1100 (NCT)
From: "paul cannon (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <423397789.58318.1347292927953.JavaMail.jiratomcat@arcas>
In-Reply-To: <1767778638.57961.1340738502833.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Commented] (CASSANDRA-4380) CQLSH: describe command doesn't
 output valid CQL command.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452102#comment-13452102 ] 

paul cannon commented on CASSANDRA-4380:
----------------------------------------

Marcos- there isn't any way to recreate some CQL 2 tables in CQL 3. CQL 3 can model the same data, but the structure of the table needs to be different. Cqlsh does the best that it can here, but if you want a better guarantee of valid reconstruction of CQL 2 tables, use cqlsh in CQL 2 mode.
                
> 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