cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4844) CQL3 Create keyspace statement not compatible with older versions.
Date Mon, 22 Oct 2012 14:18:12 GMT

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

Edward Capriolo commented on CASSANDRA-4844:
--------------------------------------------

{noformat}
[edward@tablitha apache-cassandra-1.2.0-beta1]$ bin/cqlsh
Connected to Test Cluster at localhost:9160.
[cqlsh 2.2.0 | Cassandra 1.2.0-beta1 | CQL spec 3.0.0 | Thrift protocol 19.34.0]
Use HELP for help.
cqlsh> help ;

Documented commands (type help <topic>):
========================================
ASSUME  CAPTURE  COPY  DESC  DESCRIBE  EXIT  HELP  SELECT  SHOW  SOURCE  USE

Miscellaneous help topics:
==========================
DROP_INDEX                 BOOLEAN_INPUT                SELECT_LIMIT       
ALTER_DROP                 CREATE                       DELETE_WHERE       
SELECT_EXPR                TIMESTAMP_OUTPUT             UPDATE_USING       
UUID_INPUT                 CREATE_TABLE_OPTIONS         UPDATE_WHERE       
DELETE_COLUMNS             ALTER_ALTER                  SELECT_WHERE       
DROP_TABLE                 CREATE_TABLE                 CONSISTENCYLEVEL   
CREATE_TABLE_TYPES         SELECT_COLUMNFAMILY          CREATE_INDEX       
ALTER_WITH                 SELECT_TABLE                 CREATE_KEYSPACE    
TYPES                      CREATE_COLUMNFAMILY_OPTIONS  ASCII_OUTPUT       
APPLY                      BEGIN                        DROP               
DELETE_USING               UPDATE_SET                   TIMESTAMP_INPUT    
CREATE_COLUMNFAMILY_TYPES  UPDATE_COUNTERS              ALTER              
DROP_COLUMNFAMILY          TRUNCATE                     CREATE_COLUMNFAMILY
BLOB_INPUT                 INSERT                       DELETE             
ALTER_ADD                  TEXT_OUTPUT                
DROP_KEYSPACE              UPDATE                     

Undocumented commands:
======================
DEBUG  IMPORT_INSERT

cqlsh> help CREATE_KEYSPACE;

        CREATE KEYSPACE <ksname> WITH strategy_class = '<strategy>'
                                 [AND strategy_options:<option> = <val>];

        The CREATE KEYSPACE statement creates a new top-level namespace (aka
        "keyspace"). Valid names are any string constructed of alphanumeric
        characters and underscores. Names which do not work as valid
        identifiers or integers should be quoted as string literals. Properties
        such as replication strategy and count are specified during creation
        using the following accepted keyword arguments:

          strategy_class [required]: The name of the replication strategy class
          which should be used for the new keyspace. Some often-used classes
          are SimpleStrategy and NetworkTopologyStrategy.

          strategy_options: Most strategies require additional arguments which
          can be supplied by appending the option name to "strategy_options",
          separated by a colon (:). For example, a strategy option of "DC1"
          with a value of "1" would be specified as "strategy_options:DC1 = 1".
          The replication factor option for SimpleStrategy could be
          "strategy_options:replication_factor=3".
        
cqlsh>  
{noformat}
                
> CQL3 Create keyspace statement not compatible with older versions.
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-4844
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4844
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.2.0 beta 1
>            Reporter: Edward Capriolo
>
> Following the advice here.
> http://www.datastax.com/docs/1.1/dml/using_cql
> {noformat}
> [edward@tablitha apache-cassandra-1.2.0-beta1]$ bin/cqlsh -3
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.2.0-beta1 | CQL spec 3.0.0 | Thrift protocol 19.34.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE demodb          WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy'
         AND strategy_options:replication_factor='1' ;
> Bad Request: line 1:129 mismatched input ':' expecting '='
> Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh.
> {noformat}
> http://www.datastax.com/docs/1.1/references/cql/CREATE_KEYSPACE
> {noformat}
> cqlsh> CREATE KEYSPACE Excelsior WITH strategy_class = 'SimpleStrategy'
>    ...   AND strategy_options:replication_factor = 1;
> Bad Request: line 2:22 mismatched input ':' expecting '='
> {noformat}
> It seems that in Cassandra 1.2 I am no longer able to create a keyspace.

--
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

Mime
View raw message