Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Wed, 24 Oct 2012 21:00:12 +0000 (UTC)
From: "Jonathan Ellis (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <1022095540.24149.1351112412617.JavaMail.jiratomcat@arcas>
In-Reply-To: <1435586483.22451.1351095612549.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (CASSANDRA-4854) Can not select the "Schema"
 table
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Jonathan Ellis commented on CASSANDRA-4854:
-------------------------------------------

Not sure if that's the problem, it works for me on current trunk:

{noformat}
...
CREATE KEYSPACE empty WITH replication = {
  'class': 'NetworkTopologyStrategy',
  'datacenter1': '1'
};
...
{noformat}

                
> Can not select the "Schema" table
> ---------------------------------
>
>                 Key: CASSANDRA-4854
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4854
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Edward Capriolo
>            Priority: Minor
>
> Some system tables can be selected with data. Some return 0 rows. Schema seems impossible to select because it's name is "Schema"
> {noformat}
> cqlsh:system> select * from schema_keyspaces;
>  keyspace_name | durable_writes | strategy_class                                       | strategy_options
> ---------------+----------------+------------------------------------------------------+----------------------------
>   testkeyspace |           True |          org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"1"}
>         testks |           True | org.apache.cassandra.locator.NetworkTopologyStrategy |        {"datacenter1":"1"}
> cqlsh:system> select * from Schema;
> Bad Request: line 1:14 no viable alternative at input 'Schema'
> cqlsh:system> select * from "Schema";
> cqlsh:system> select * from `"Schema`";
> Invalid syntax at line 1, char 15
>   select * from `"Schema`";
>                 ^
> cqlsh:system> select * from `Schema`;
> Invalid syntax at line 1, char 15
>   select * from `Schema`;
>                 ^
> cqlsh:system> select * from '"Schema"';
> Bad Request: line 1:14 no viable alternative at input '"Schema"'
> Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh.
> {noformat}

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