I am new to Cassandra, so please bear with me if this is a trivial question. I learn Cassandra from this book http://shop.oreilly.com/product/0636920010852.do?cmp=il-orm-ans-learnmore-0636920010852 Although this seems like a pretty old book, I got an approximate idea of a data model that does not contain Cassandra schemas, however, in a relatively new documentation I found a schemathe nature of Cassandra. As I understand it, the main strength of Cassandra lies in its horizontal scalability and distributed memory. Its advantage over MySQL and other relevant DBMSs is that it saves us from the problems created by hundreds of external connections in big data. My question is when we decided to create a schema and use regular tables, rows and column structure and a CQL query, how is it different from MySQL? What are the main differences between the MySQL schema and the Cassandra schema. According to datastax documentation
For example, CQL is adapted to the Cassandra data model and architecture, so that SQL-like operations such as JOINs or a range of row queries on clusters that use a random delimiter are still not taken into account. This link describes CQL 2.0.0.
So, in cases where we use a similar scheme in Cassandra, how do we handle the need for JOINS? Since I never worked with Cassandra, before I do not know how to process data in a distributed way.
source
share