Benjamin Lerer created CASSANDRA-14512: ------------------------------------------
Summary: DESCRIBE behavior is broken for Virtual Keyspaces/Tables (CQLSH) Key: CASSANDRA-14512 URL: https://issues.apache.org/jira/browse/CASSANDRA-14512 Project: Cassandra Issue Type: Bug Reporter: Benjamin Lerer Assignee: Benjamin Lerer The {{DESCRIBE}} command in CQLSH does not work properly for virtual keyspaces/tables. # For the {{DESCRIBE KEYSPACES}} the virtual keyspaces are correctly added to the list but for {{DESCRIBE TABLES}} only the non virtual tables are displayed. # {{DESCRIBE system_views}} return the error: {{'system_views' not found in keyspaces}}. Similar error for {{DESCRIBE system_virtual_schema}}. # {{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. {code} 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 = {}; {code} I would be in favor or replacing the {{CREATE TABLE}} by a {{VIRTUAL TABLE}}. [~cnlwsu], [~iamaleksey] What do you think? -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org