[ 
https://issues.apache.org/jira/browse/CASSANDRA-14512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

C. Scott Andreas updated CASSANDRA-14512:
-----------------------------------------
    Component/s: Observability
                 CQL

> 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
>          Components: CQL, Observability
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>            Priority: Major
>              Labels: virtual-tables
>
> 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

Reply via email to