python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - cql

How can I find the maximum value from CQL aggregate?

I am new with CQL, please help! I am trying to find the " Which URL on the website has been accessed the most? How many accesses were made on it?" from a Table, I have created. The IP value...
test-img

krk

cassandra

cql

Votes: 0

Answers: 1

Latest Answer

This isn't a good thing to do in Cassandra. It won't scale as your dataset/cluster grows because it requires a full table scan. For analytics workloads, we recommend that you use Spark with the spark-...
test-img

Erick Ramirez

How do I update a tuple in Cassandra?

There are literary no tutorials on how to update tuples on Google. Can someone explain how tuples can be updated in Cassandra?
test-img

user1535147

cassandra

cql

Votes: 0

Answers: 1

Latest Answer

The CQL tuple data type is implicitly "frozen" without needing the CQL frozen keyword so you can't update individual elements of a tuple column -- you need to update the whole column. To ill...
test-img

Erick Ramirez

What is system.size_estimates in cassandra and plausible reasons behind high disk consumption

I've been using cassandra on two nodes where one of them ran out of disk space and went down. When I checked, I've observed the size of size_estimates to be ~30GB. I've removed sstable files from my d...
test-img

PKS

cassandra

cql

spark-cassandra-connector

nodetool

distributed-database

Votes: 0

Answers: 1

Latest Answer

As the name suggests, the size_estimates contains estimates of partition counts and their corresponding size. The estimates are calculated and recorded in the background every 5 minutes. You haven't p...
test-img

Erick Ramirez

How do I filter by a CQL column not in the PRIMARY KEY?

I have following table in Cassandra: create table ibc.my_table ( my_key_1 uuid, my_key_2 uuid, my_key_3 uuid, end_timestamp timestamp, locked boolean, maximum_duration_minutes ...
test-img

gstackoverflow

cassandra

cql

Votes: 0

Answers: 1

Latest Answer

In this case, I would use a Secondary Index. Typically, you would have to be careful over performance with Secondary Indexes, just as you would with using ALLOW FILTERING. But in this particular case...
test-img

Aaron

Posts

Questions

Blogs

Jobs