All Questions
Tagged with cassandra-2.0 data-modeling
17 questions
0
votes
1
answer
19
views
Replacing integer column in Cassandra table
In a table the cluster key is an int column which is a system generated number - chrg Issue is
Since its defined as int datatype it can store values only uptil 2billion.
And since the data of the ...
user6385832
2
votes
1
answer
954
views
Cassandra data model with multiple conditions
I'm new to Cassandra, so I read a dozen articles about it and thus I know the basics. All the tutorials show efficient data retrieval by 1 or 2 columns and a time range. What I could not find was how ...
0
votes
1
answer
226
views
How to model associative data in Apache Cassandra?
I decided on using Cassandra for one project and after going through a lot of documentation I still cannot picture a good way of modelling associative data.
The system is supposed to store data as ...
- 3,132
0
votes
1
answer
52
views
table definition statement for cassandra for range queries?
Here is the table data
video_id uuid
user_id timeuuid
added_year int
added_date timestamp
title text
description text
I want to construct table based on the following query
select * from ...
- 31.2k
1
vote
2
answers
407
views
Data modelling a user table with multiple addresses in Cassandra
I am just starting out in Cassandra. I am testing following data model. I was wondering how can this be modeled in Cassandra?
Users
{
"userId" : "73180" ,
"firstName" : "John" ,
"...
- 1,436
3
votes
0
answers
326
views
Web analytics customer segmentation data modeling with Cassandra?
I would like to use Cassandra for my website analytics which is geared especially towards customers segmentation.
What this analytics will do is gather Page View data for every customers/visitor which ...
- 5,351
1
vote
1
answer
143
views
Granularity level in clustering key( high unique values)
I am little new to cassandra data modelling. I am trying to understand if i can have high unique values in clustering key. for eg: we have 4 columns. Storeid, shipping_status, orderid and guestname. ...
- 41
3
votes
1
answer
355
views
Cassandra data-modelling around email-system
I need data modelling help as I haven't found a resource that tackles the same problem.
The user case is similar to an email-system. I want to store a timeline of all emails a user has received and ...
- 2,406
1
vote
3
answers
8k
views
Cassandra low read performance with high SSTable count
I am building an application which process very large data(more that 3 million).I am new to cassandra and I am using 5 node cassandra cluster to store data. I have two column families
Table 1 : ...
- 1,405
0
votes
2
answers
395
views
Cassandra column family for multiple usecases good/bad
I have a data structure to store different areas/locations, area is part of a city, city is part of a state, state is part of country.
couple of usecases to query are
U1 : Given a location get city, ...
- 964
2
votes
1
answer
136
views
Data modelling for consistent secondary keys with Cassandra
With Cassandra,
I want to represent all users objects with a unique uuid, but also contain a set of zero or more secondary user keys to map to a user. Each secondary key should map to one and only ...
- 1,735
11
votes
1
answer
5k
views
Efficient modeling of versioned hierarchies in Cassandra
Disclaimer:
This is quite a long post. I first explain the data I am dealing with, and what I want to do with it.
Then I detail three possible solutions I have considered, because I've tried to do my ...
- 1,748
0
votes
1
answer
436
views
CQL: Search a table in cassandra using '<' on a indexed column
My cassandra data model:
CREATE TABLE last_activity_tracker ( id uuid, recent_activity_time timestamp, PRIMARY KEY(id));
CREATE INDEX activity_idx ON last_activity_tracker (...
- 81
0
votes
1
answer
65
views
Modeling nested data with possible null values in cassandra
I have a situation similar to the one described in question Nested data data modelling in Cassandra?
I have a project entity for which my app needs to be able to display project specific information, ...
- 467
0
votes
0
answers
253
views
Cassandra and pdo php. Import data from csv file. How to improve performance
I'm starting to work with big data.
My input is a daily csv files with many columns and I've to import these three columns:
user_id
parent_id
grandparent_id
.....
what is my goals?
I have to count ...
- 147
0
votes
1
answer
1k
views
Nested data data modelling in Cassandra?
I am trying to create tables which can drills down to multiple level for eg
each project has multiple milestones and each milestones has mutiple tasks and each task has few subtasks along with task ...
- 11
3
votes
2
answers
1k
views
Cassandra data model with obsolete data removal possibility
I'm new to cassandra and would like to ask what would be correct model design pattern for such tasks.
I would like to model data with future removal possibility.
I have 100,000,000 records per day of ...
- 346