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] [Created] (CASSANDRA-4854) Can not select the "Schema" table
Date Wed, 24 Oct 2012 16:20:12 GMT
Edward Capriolo created CASSANDRA-4854:
------------------------------------------

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

Mime
View raw message