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

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