paul cannon created CASSANDRA-4416:
--------------------------------------
Summary: Include metadata for system keyspace itself in schema_*
tables
Key: CASSANDRA-4416
URL: https://issues.apache.org/jira/browse/CASSANDRA-4416
Project: Cassandra
Issue Type: Improvement
Components: Core
Affects Versions: 1.0.5
Reporter: paul cannon
Priority: Minor
Fix For: 1.1.3
The `system.schema_keyspaces`, `system.schema_columnfamilies`, and
`system.schema_columns` virtual tables allow clients to query schema and layout
information through CQL. This will be invaluable when users start to make more
use of the CQL-only protocol (CASSANDRA-2478), since there will be no other way
to determine certain information about available columnfamilies, keyspaces, or
show metadata about them.
However, the system keyspace itself, and all the columnfamilies in it, are not
represented in the schema_* tables:
{noformat}
cqlsh> select * from system.schema_keyspaces where "keyspace" = 'system';
cqlsh>
cqlsh> select * from system.schema_columnfamilies where "keyspace" = 'system';
cqlsh>
cqlsh> select * from system.schema_columns where "keyspace" = 'system';
cqlsh>
{noformat}
It would be greatly helpful to clients which do more introspection than the
minimum (say, for example, cqlsh) to be able to get information on the
structure and availability of schema-definition tables.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
