All Questions
Tagged with database-partitioning cassandra
21 questions
1
vote
1
answer
213
views
What is the overhead of querying multiple partition keys in the same token range via IN operator in Cassandra?
Usually querying multiple rows with different partition keys isn't recommended in Cassandra because those queries might affect multiple nodes.
However, it's not clear about querying multiple ...
- 3,764
0
votes
1
answer
136
views
How to read 200 million partition keys in cassandra table without request being timed out
I have a table with huge no of unique partition keys , say a table having Unique Id of all the citizens of a country
Now what i need is full table scan and read only keys . Do i need to read segment ...
- 73
-1
votes
2
answers
234
views
nodetool tablehistograms command returned "No SSTables exists, unable to calculate 'Partition Size' and 'Cell Count' percentiles"
command I ran was
nodetool tablehistograms <keyspace> <table>
The bug was
No SSTables exists, unable to calculate 'Partition Size' and 'Cell Count' percentiles
I tried to calculate ...
- 1
1
vote
1
answer
681
views
How the hash function by partitioner in Cassandra is decided for a particular data set to ensure even distribution of data across multiple cluster?
As we know from Cassandra's documentation[Link to doc] that partitioner should be such that the data is distributed evenly across multiple nodes to avoid read hotspots. Cassandra offers various ...
- 2,819
0
votes
2
answers
226
views
How to structure the particion key in a cassandra table for user following
I want to make a table, where users follow other users. In this table I need an userID for the following user and an userID for the followed user. In the case that there are some users, that get ...
- 31
3
votes
2
answers
1k
views
Is a unique column good as partition key in Cassandra?
I have a table user with multiple columns, every user has a unique userid.
Because it is unique, I dont have to specify a clustering key unless I want to use the column in queries. Is this bad, ...
- 31
0
votes
1
answer
76
views
Suggestion required to design partitioning in cassandra
I have to design the database for customers having prices for millions of materials they acquire through multiple suppliers for the next 24 months. So the database will store prices on a daily basis ...
0
votes
1
answer
75
views
How do I fetch sorted logs in Cassandra?
In my application we store logs in Cassandra. User can see the logs after giving a start and an end date for the logs. We fetch the data on the basis of these dates and have implemented pagination as ...
1
vote
1
answer
1k
views
Recommended number of partitions in Cassandra
Although Cassandra allows -2^63 to +2^63-1 number of paritions, is there a recommended max number of partitions beyond which performance might suffer?
- 11
2
votes
1
answer
165
views
Cassandra changing Primary Key vs Firing multiple select queries
I have a table that stores list products that a user has. The table looks like this.
create table my_keyspace.userproducts{
userid,
username,
productid,
productname,
producttype,
Primary ...
- 752
1
vote
2
answers
420
views
Cassandra partitioning strategy for systems with skewed traffic
Please bear with me for slightly longer problem description.
I am a newbie to Cassandra world and I am trying to migrate my current product from oracle based data layer to Cassandra.
In order to ...
- 515
0
votes
1
answer
759
views
Cassandra performance of first Clustering Key
I am using Cassandra 3.x and have the following table:
CREATE TABLE sp_db.prod_tag
(
year int,
name text,
group int,
sn text,
factory_id bigint,
PRIMARY KEY ((year), name, ...
- 117
0
votes
2
answers
94
views
Partition keys update
using cassandra 2.2.8
my challenge is as follows. In my database we've bunch of tables with millions of rows. Unfortunately, due to loose design partition keys on few tables have grown in Gigabytes in ...
- 35
0
votes
1
answer
93
views
apache cassandra limit and in clausel
i have the following time series in my Cassandra cluster:
CREATE TABLE consumptions (
meter_id int,
date date,
meter_date_time timestamp,
data text,
PRIMARY KEY ((meter_id, date), ...
- 1,168
1
vote
2
answers
234
views
How do partition keys work?
I am new to Cassandra and I read that the primary key is the same thing as the partition key.
My question is simple, in this case:
CREATE TABLE users (
user_name varchar PRIMARY KEY,
password ...
- 10.4k