How to list all materialized view tables in Cassandra CQL

Question

How to list all

materialized view tables

in Cassandra CQL

[cqlsh 5.0.1 | Cassandra 3.0.7.1158 | DSE 5.0.0 | CQL spec 3.4.0 | Native protocol v4]

score 17 · Answer 1 · answered Jul 01 '16 at 10:30

17

Probably the easiest way is from the views schema table with:

SELECT * FROM system_schema.views;

answered Jul 01 '16 at 10:30

mikea

It shows all keyspace views, how can we view just in one keyspace? – Julie Sep 05 '17 at 21:40
3

SELECT view_name FROM system_schema.views where keyspace_name='myKeyspace'; – thomas Jan 22 '18 at 14:29

1 Answers1