Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cql]

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables. Its syntax is similar to SQL. For the Cypher graph query language, use the cypher tag.

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables. Its syntax is similar to SQL. Despite their similarities, in many cases CQL behaves very differently from SQL, so it is important to read the documentation before going too far.

Some of the more useful links to documentation on CQL:

3 questions
2
votes
1 answer

Does updating a frozen column generate a tombstone?

I was planning to change my column from nonfrozen to frozen. I would like to know if there are any guidelines for updating the frozen column with respect to tombstone generation. In some blogs it is written that updating a frozen column generates…
Prateek Sharma
  • 21
  • 2
2
votes
2 answers

Why do batch updates to a CQL list merge the data?

I have created the following table CONSISTENCY LOCAL_QUORUM; drop keyspace if exists cycling; CREATE KEYSPACE IF NOT EXISTS cycling WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 } and durable_writes =…
gudge
  • 133
  • 4
1
vote
1 answer

How do I manage Cassandra/Scylla snapshots?

I am new to Scylla, and I'm looking to setup a proper Backup & Restore solution. I've just tested running nodetool snapshot -t my_backup, and see that what it does is create a snapshot folder caled my_backup, inside each keyspace & table…
Nuno
  • 829
  • 1
  • 12
  • 24