Menu
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]
264
Go to data tab > there you will see all keyspcaces created by you and some system keyspaces. You can see all tables under individual keyspaces and also replicator factor for keyspace.
Materialized view is work like a base table and it is defined as CQL query which can queried like a base table. Materialized view is very important for de-normalization of data in Cassandra Query Language is also good for high cardinality and high performance. Let’s understand with an example.
How to List All Tables in Cassandra Something so simple can be so difficult to find. Cassandra’s documentation isn’t the best or easiest to find specific commands. How do you list all the tables in Cassandra? Make sure that cassandra’s binary is running in a terminal. cassandra Start cqlsh in another terminal. cqlsh Shell cqlsh>use <key_space>; 1
In materialized view there are following restriction that must follow. In materialized view whatever the primary column in base table must contain in materialized view table that ensure every row of MV (materialized view) is correspond to the base table.
In materialized view whatever the primary column in base table must contain in materialized view table that ensure every row of MV (materialized view) is correspond to the base table. In materialized view only we can add one more column that is not a primary column in base table.
Probably the easiest way is from the views schema table with:
SELECT * FROM system_schema.views;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
