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

Reply via email to