cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Lohfink (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-14512) DESCRIBE behavior is broken for Virtual Keyspaces/Tables (CQLSH)
Date Tue, 12 Jun 2018 14:51:00 GMT

    [ 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message