Best way to store and index time series items with multiple other dimensions?

2012-02-16 Thread Nate Sammons
uot;short" rows that can't be time sliced as easily, and I don't know that have a bunch of secondary indexes will scale very well (or support range queries). Any ideas on a way to structure data for easy queries like this? Thanks, -nate Nate Sammons | Sr. Technical Specialist

RE: Secondary index issue, unable to query for records that should be there

2011-11-08 Thread Nate Sammons
, validation_class:UTF8Type} ]; And change the hector code to use setString(...) instead of setInteger(...). Then everything works fine. Is there a CQL bug with respect to non-string columns? Thanks, -nate From: Nate Sammons [mailto:nsamm...@ften.com] Sent: Tuesday, November 08, 2011 11:14 AM

RE: Secondary index issue, unable to query for records that should be there

2011-11-08 Thread Nate Sammons
Note that I had identical behavior using a fresh download of Cassandra 1.0.2 as of today. Thanks, -nate From: Nate Sammons [mailto:nsamm...@ften.com] Sent: Tuesday, November 08, 2011 10:20 AM To: user@cassandra.apache.org Subject: RE: Secondary index issue, unable to query for records that

RE: Secondary index issue, unable to query for records that should be there

2011-11-08 Thread Nate Sammons
127.0.1.1 Thanks, -nate From: Jake Luciani [mailto:jak...@gmail.com] Sent: Tuesday, November 08, 2011 8:56 AM To: user@cassandra.apache.org Subject: Re: Secondary index issue, unable to query for records that should be there Hi Nate, Could you try running it with debug enabled on t

RE: Secondary index issue, unable to query for records that should be there

2011-11-08 Thread Nate Sammons
Could you try running it with debug enabled on the logs? it will give more insite into what's going on. -Jake On Tue, Nov 8, 2011 at 3:45 PM, Nate Sammons mailto:nsamm...@ften.com>> wrote: This is against a single server, not a cluster. Replication factor for the keyspace is set to 1

RE: Secondary index issue, unable to query for records that should be there

2011-11-08 Thread Nate Sammons
ave a ring setup, what is your replicationfactor set to? Also what ConsistencyLevel are you writing with when storing the values? -R On Mon, Nov 7, 2011 at 2:43 PM, Nate Sammons mailto:nsamm...@ften.com>> wrote: Hello, I'm experimenting with Cassandra (DataStax Enterprise 1.0.3), and I&#

Secondary index issue, unable to query for records that should be there

2011-11-07 Thread Nate Sammons
Hello, I'm experimenting with Cassandra (DataStax Enterprise 1.0.3), and I've got a CF with several secondary indexes to try out some options. Right now I have the following to create my CF using the CLI: create column family MyTest with key_validation_class = UTF8Type and comparator = UTF