[
https://issues.apache.org/jira/browse/CASSANDRA-14512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Lerer updated CASSANDRA-14512:
---------------------------------------
Resolution: Duplicate
Status: Resolved (was: Open)
> 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: Legacy/CQL, Legacy/Observability
> Reporter: Benjamin Lerer
> Assignee: Benjamin Lerer
> Priority: Normal
> Labels: virtual-tables
> Fix For: 4.0-alpha
>
>
> 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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
