You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2012/10/24 19:00:13 UTC
[jira] [Resolved] (CASSANDRA-4854) Can not select the "Schema"
table
[ https://issues.apache.org/jira/browse/CASSANDRA-4854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne resolved CASSANDRA-4854.
-----------------------------------------
Resolution: Not A Problem
"Schema" is the old-style, pre-1.1 schema table so as soon as you've correctly started a 1.1 it is expected to be empty. So
{noformat}
select * from "Schema"
{noformat}
is correct and is working as expected.
The new-style schema tables are: schema_keyspaces, schema_columnfamilies and schema_columns.
> 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