Re: Design Query Optimization for Cassandra Table with Date-based Filtering

2023-12-14 Thread Sebastian Marsching
Hi Arjun, this is strange. You should be able to use a range query on a column that is part of the clustering key, as long as all columns in the clustering key left to this column are set to fixed values. So, given the table definition that you specified, your query should work (I just tested

Design Query Optimization for Cassandra Table with Date-based Filtering

2023-12-13 Thread arjun s
Hello team, I'm new to Cassandra and I've created a table using the following command: CREATE TABLE instant_cdr ( rowid int, msisdn varchar, id bigint, date_id int, channel varchar, usage_type varchar, ac_type varchar, voice_amt int, sms_amt int, data_amt int, field1 varchar,

Re: Design Query

2010-05-04 Thread Dorin Dragutoiu
2. I have used the same configuration (3 machines with 4GB RAM) and I got an Out of memory error on compactation each time trying to compact 4 x 128MB sstables. Tried different configuration incl Java Opts, same result. When I have used 16GB ram machine everything worked like a charm. Pe 04.05

Re: Design Query

2010-05-04 Thread vineet daniel
As you havent specified all the details pertaining to filters and your data layout (structure) at a very high level what i can suggest is that you need to create a seperate CF for each filter. On Sat, May 1, 2010 at 5:04 PM, Rakesh Rajan wrote: > I am evaluating cassandra to implement activity

Re: Design Query

2010-05-03 Thread Jonathan Ellis
On Sat, May 1, 2010 at 6:34 AM, Rakesh Rajan wrote: > I am evaluating cassandra to implement activity streams. We currently have > over 100 feeds with total entries exceeding 32000 implemented using > redis ( ~320 entries / feed). Would like hear from the community on how to > use cassandr

Design Query

2010-05-01 Thread Rakesh Rajan
I am evaluating cassandra to implement activity streams. We currently have over 100 feeds with total entries exceeding 32000 implemented using redis ( ~320 entries / feed). Would like hear from the community on how to use cassandra to solve the following cases: 1. Ability to fetch entri