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

DESCRIBE behavior is broken for Virtual Keyspaces/Tables (CQLSH)

Agile BoardAttach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Severity:
      Normal

      Description

      The DESCRIBE command in CQLSH does not work properly for virtual keyspaces/tables.

      1. For the DESCRIBE KEYSPACES the virtual keyspaces are correctly added to the list but for DESCRIBE TABLES only the non virtual tables are displayed.
      2. DESCRIBE system_views return the error: 'system_views' not found in keyspaces. Similar error for DESCRIBE system_virtual_schema.
      3. DESCRIBE KEYSPACE system_views or DESCRIBE KEYSPACE system_virtual_schema return the error: 'NoneType' object has no attribute 'export_for_schema'

      The DESCRIBE TABLE command works fine but the output might be confusing as it is a CREATE statement.

      cqlsh> DESCRIBE TABLE system_virtual_schema.tables;
      
      CREATE TABLE system_virtual_schema.tables (
          comment text,
          keyspace_name text,
          table_name text,
          PRIMARY KEY (keyspace_name, table_name)
      ) WITH CLUSTERING ORDER BY (table_name ASC)
          AND compaction = {'class': 'None'}
          AND compression = {};
      

      I would be in favor or replacing the CREATE TABLE by a VIRTUAL TABLE. Chris Lohfink, [~iamaleksey] What do you think?

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              blerer Benjamin Lerer Assign to me
              Reporter:
              blerer Benjamin Lerer
              Authors:
              Benjamin Lerer

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment