You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "B. Todd Burruss (JIRA)" <ji...@apache.org> on 2012/11/30 05:49:58 UTC
[jira] [Created] (CASSANDRA-5006) Cannot create keyspaces using CQL
3
B. Todd Burruss created CASSANDRA-5006:
------------------------------------------
Summary: Cannot create keyspaces using CQL 3
Key: CASSANDRA-5006
URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.2.0 beta 2
Environment: cqlsh 2.3.0
cassandra server 1.2.0-beta2
also tried from tip of cassandra-1.2 branch
Reporter: B. Todd Burruss
following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
Connected to Test Cluster at localhost:9160.
[cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
Use HELP for help.
cqlsh> CREATE KEYSPACE Excelsior
... WITH strategy_class = SimpleStrategy
... AND strategy_options:replication_factor = 1;
Bad Request: line 3:32 mismatched input ':' expecting '='
cqlsh> CREATE KEYSPACE Excalibur
... WITH strategy_class = NetworkTopologyStrategy
... AND strategy_options:DC1 = 1
... AND strategy_options:DC2 = 3;
Bad Request: line 4:32 mismatched input ':' expecting '='
cqlsh>
same CQL statements work fine if use "-2" option to force CQL 2
tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
Connected to Test Cluster at localhost:9160.
[cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
Use HELP for help.
cqlsh> CREATE KEYSPACE Excelsior
... WITH strategy_class = SimpleStrategy
... AND strategy_options:replication_factor = 1;
cqlsh> CREATE KEYSPACE Excalibur
... WITH strategy_class = NetworkTopologyStrategy
... AND strategy_options:DC1 = 1
... AND strategy_options:DC2 = 3;
cqlsh>
--
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
[jira] [Commented] (CASSANDRA-5006) Cannot create keyspaces using
CQL 3
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13507182#comment-13507182 ]
Jonathan Ellis commented on CASSANDRA-5006:
-------------------------------------------
(I note for the record that the examples in 1.2 CQL.textile have been updated for this.)
> Cannot create keyspaces using CQL 3
> -----------------------------------
>
> Key: CASSANDRA-5006
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
> Project: Cassandra
> Issue Type: Bug
> Components: Documentation & website
> Affects Versions: 1.2.0 beta 2
> Environment: cqlsh 2.3.0
> cassandra server 1.2.0-beta2
> also tried from tip of cassandra-1.2 branch
> Reporter: B. Todd Burruss
> Priority: Trivial
>
> following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> Bad Request: line 3:32 mismatched input ':' expecting '='
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> Bad Request: line 4:32 mismatched input ':' expecting '='
> cqlsh>
> same CQL statements work fine if use "-2" option to force CQL 2
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> cqlsh>
--
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
[jira] [Commented] (CASSANDRA-5006) Cannot create keyspaces using
CQL 3
Posted by "B. Todd Burruss (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13508043#comment-13508043 ]
B. Todd Burruss commented on CASSANDRA-5006:
--------------------------------------------
ok, thx - missed the note at the top of the page. but seems that the
spec version should have changed if the syntax changed
> Cannot create keyspaces using CQL 3
> -----------------------------------
>
> Key: CASSANDRA-5006
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
> Project: Cassandra
> Issue Type: Bug
> Components: Documentation & website
> Affects Versions: 1.2.0 beta 2
> Environment: cqlsh 2.3.0
> cassandra server 1.2.0-beta2
> also tried from tip of cassandra-1.2 branch
> Reporter: B. Todd Burruss
> Priority: Trivial
>
> following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> Bad Request: line 3:32 mismatched input ':' expecting '='
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> Bad Request: line 4:32 mismatched input ':' expecting '='
> cqlsh>
> same CQL statements work fine if use "-2" option to force CQL 2
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> cqlsh>
--
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
[jira] [Commented] (CASSANDRA-5006) Cannot create keyspaces using
CQL 3
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13507103#comment-13507103 ]
Dave Brosius commented on CASSANDRA-5006:
-----------------------------------------
try the format found with
help create_keyspace
from within cqlsh
CREATE KEYSPACE <ksname>
WITH replication = {'class':'SimpleStrategy', 'replication_factor':3};
CREATE KEYSPACE <ksname>
WITH replication = {'class':'NetworkTopologyStrategy', 'DC1':1, 'DC2':2};
---
looks like that link needs to be updated.
> Cannot create keyspaces using CQL 3
> -----------------------------------
>
> Key: CASSANDRA-5006
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0 beta 2
> Environment: cqlsh 2.3.0
> cassandra server 1.2.0-beta2
> also tried from tip of cassandra-1.2 branch
> Reporter: B. Todd Burruss
>
> following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> Bad Request: line 3:32 mismatched input ':' expecting '='
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> Bad Request: line 4:32 mismatched input ':' expecting '='
> cqlsh>
> same CQL statements work fine if use "-2" option to force CQL 2
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> cqlsh>
--
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
[jira] [Resolved] (CASSANDRA-5006) Cannot create keyspaces using
CQL 3
Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brandon Williams resolved CASSANDRA-5006.
-----------------------------------------
Resolution: Not A Problem
The link is correct for beta cql3 in 1.1, which is states it is at the top. This is one of the things that changed for the final release in 1.2.
> Cannot create keyspaces using CQL 3
> -----------------------------------
>
> Key: CASSANDRA-5006
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
> Project: Cassandra
> Issue Type: Bug
> Components: Documentation & website
> Affects Versions: 1.2.0 beta 2
> Environment: cqlsh 2.3.0
> cassandra server 1.2.0-beta2
> also tried from tip of cassandra-1.2 branch
> Reporter: B. Todd Burruss
> Priority: Trivial
>
> following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> Bad Request: line 3:32 mismatched input ':' expecting '='
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> Bad Request: line 4:32 mismatched input ':' expecting '='
> cqlsh>
> same CQL statements work fine if use "-2" option to force CQL 2
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> cqlsh>
--
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
[jira] [Updated] (CASSANDRA-5006) Cannot create keyspaces using CQL
3
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-5006:
------------------------------------
Component/s: Documentation & website
Priority: Trivial (was: Major)
> Cannot create keyspaces using CQL 3
> -----------------------------------
>
> Key: CASSANDRA-5006
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5006
> Project: Cassandra
> Issue Type: Bug
> Components: Documentation & website
> Affects Versions: 1.2.0 beta 2
> Environment: cqlsh 2.3.0
> cassandra server 1.2.0-beta2
> also tried from tip of cassandra-1.2 branch
> Reporter: B. Todd Burruss
> Priority: Trivial
>
> following examples shown here: http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 1.2.0-beta2 | CQL spec 3.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> Bad Request: line 3:32 mismatched input ':' expecting '='
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> Bad Request: line 4:32 mismatched input ':' expecting '='
> cqlsh>
> same CQL statements work fine if use "-2" option to force CQL 2
> tburruss@tburruss-mint-13 ~ $ /btoddb/apache-cassandra-1.2.0-beta2/bin/cqlsh -2
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.3.0 | Cassandra 0.0.0 | CQL spec 2.0.0 | Thrift protocol 19.35.0]
> Use HELP for help.
> cqlsh> CREATE KEYSPACE Excelsior
> ... WITH strategy_class = SimpleStrategy
> ... AND strategy_options:replication_factor = 1;
> cqlsh> CREATE KEYSPACE Excalibur
> ... WITH strategy_class = NetworkTopologyStrategy
> ... AND strategy_options:DC1 = 1
> ... AND strategy_options:DC2 = 3;
> cqlsh>
--
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