Short summary: Replication factor describes how many copies of your data exist. Consistency level describes the behavior seen by the client. Perhaps there’s a better way to categorize these. As an example, you can have a replication factor of 2. When you write, two copies will always be stored, assuming enough nodes are up. When … Read more
Dbeaver in its free enterprise version (not open source) is good GUI client for Cassandra. No need of installation. Its portable. Also this client supports more than 20 databases. Community Edition of Dbeaver doesn’t have support for Cassandra, but we can use third party drivers for like Cdata to connect. Try the following GUI client … Read more
If you take a look at the Readme file at Apache Cassandra git repo, it says that, Cassandra is a partitioned row store. Rows are organized into tables with a required primary key. Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are … Read more
To remove all rows from a CQL Table, you can use the TRUNCATE command: TRUNCATE keyspace_name.table_name; Or if you are already using the keyspace that contains your target table: TRUNCATE table_name; Important to note, but by default Cassandra creates a snapshot of the table just prior to TRUNCATE. Be sure to clean up old snapshots, … Read more
[cqlsh 4.1.0 | Cassandra 2.0.4 | CQL spec 3.1.1 | Thrift protocol 19.39.0] Currently, the command to use is: DESC[RIBE] keyspaces;