Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-4416

Include metadata for system keyspace itself in schema_* tables

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 1.2.0 beta 2
    • None

    Description

      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:

      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> 
      

      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.

      Attachments

        1. 4416_fix.txt
          2 kB
          Sylvain Lebresne
        2. 4416.txt
          6 kB
          Jonathan Ellis

        Activity

          People

            jbellis Jonathan Ellis
            thepaul paul cannon
            Jonathan Ellis
            Sylvain Lebresne
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: