Apache Cassandra - Tutorial 13 - CQL - Materialized Views

[@edsonr.4844]

Thanks for the video! It was very helpful 😄

[@jumpstartCS]

Really glad you found it helpful! Thanks for watching!

[@golfclash9071]

Does materialised view copy original table and consumes the disk/memory space or does it only create view with pointers to data without consuming disk space?

[@nikola4628]

How would you approach solving problem on sorting? Like, for example, you can sort on all columns?

[@zichuantian4032]

Shouldn’t the primary key be unique?

[@jumpstartCS]

Thanks for the comment. Apologies I may have screwed up my terminology in this video. You are correct in saying the primary key is unique. The primary key is the unique combination of the partition key and all clustering columns for that row in the table. The partition key does not need to be unique.

[@zichuantian4032]

jumpstartCS Thank you for the reply. Great video tutorial. Thank you for the content!

[@n.s.karthik5628]

is there any advantage for materialized views over secondary indexes?

[@chodaop]

Better performance

[@tobiowolawi5044]

with secondary indexes, cassandra scans around all the node involved to prepare the result. with materialized view, the data is populated internally upon writes

[@mritunjay3723]

Can you provide us with the python driver connection to datastax astra database?

[@jumpstartCS]

As far as I know the Datastax astra database is just a cloud native database as a service offering from Datastax. The connection code should be similar to any Cassandra deployment, there may however be some additional security steps to take (SSL certs etc.)