[ 
https://issues.apache.org/jira/browse/CASSANDRA-14512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16509711#comment-16509711
 ] 

Chris Lohfink commented on CASSANDRA-14512:
-------------------------------------------

After [https://datastax-oss.atlassian.net/browse/PYTHON-992] we can update 
cqlsh, but I think we should wait to see how the drivers are going to expose 
the virtual tables before we get too far into the cqlsh usage. The shim there 
now can be removed and the behavior can match more expected values.

> 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
>            Priority: Major
>
> 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