Re: timeuuid and cql3 query

2013-06-21 Thread Ryan, Brent
21, 2013 8:38 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: timeuuid and cql3 query It's my understanding that if cardinality of the first part of the primary key has low cardinality, you will struggle wit

Re: timeuuid and cql3 query

2013-06-21 Thread Eric Stevens
with > the latest version of DSE community edition which I believe is Cassandra > 1.2.3. > > > Thanks, > Brent > > > From: Tyler Hobbs > Reply-To: "user@cassandra.apache.org" > Date: Wednesday, June 19, 2013 11:00 AM > To: "user@cassandra.apache.org

Re: timeuuid and cql3 query

2013-06-19 Thread Francisco Andrades Grassi
; > > Thanks, > Brent > > > From: Tyler Hobbs > Reply-To: "user@cassandra.apache.org" > Date: Wednesday, June 19, 2013 11:00 AM > To: "user@cassandra.apache.org" > Subject: Re: timeuuid and cql3 query > > > On Wed, Jun 19, 2013

Re: timeuuid and cql3 query

2013-06-19 Thread Sylvain Lebresne
test | 2013-06-18 22:44:02-0400 |1 | 1 > test | 2013-06-18 22:44:03-0400 |1 | 1 > test | 2013-06-18 22:44:04-0400 |1 | 1 > test | 2013-06-18 22:44:05-0400 |1 | 1 > test | 2013-06-18 22:44:06-0400 |1 | 1 > > > From: , B

Re: timeuuid and cql3 query

2013-06-19 Thread Ryan, Brent
1 test | 2013-06-18 22:44:06-0400 |1 | 1 From: , Brent Ryan mailto:br...@cvent.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Wednesday, June 19, 2013 12:56 PM To: "user@cassand

Re: timeuuid and cql3 query

2013-06-19 Thread Ryan, Brent
sandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Wednesday, June 19, 2013 12:47 PM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: timeuuid and cql3 q

Re: timeuuid and cql3 query

2013-06-19 Thread Ryan, Brent
dra.apache.org>> Date: Wednesday, June 19, 2013 11:00 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Subject: Re: timeuuid and cql3 query On Wed, Jun 19, 2013 at 8:08 AM, Ryan, Brent mailto:br...@cvent.com

Re: timeuuid and cql3 query

2013-06-19 Thread Ryan, Brent
I'm using the byte ordered partitioner. Sent from my iPhone On Jun 19, 2013, at 11:26 AM, "Sylvain Lebresne" mailto:sylv...@datastax.com>> wrote: You're using the ordered partitioner, right? On Wed, Jun 19, 2013 at 5:06 PM, Davide Anastasia mailto:davide.anasta...@gmail.com>> wrote: Hi Tyle

Re: timeuuid and cql3 query

2013-06-19 Thread Sylvain Lebresne
You're using the ordered partitioner, right? On Wed, Jun 19, 2013 at 5:06 PM, Davide Anastasia < davide.anasta...@gmail.com> wrote: > Hi Tyler, > I am interested in this scenario as well: could you please elaborate > further your answer? > > Thanks a lot, > Davide > On 19 Jun 2013 16:01, "Tyler

Re: timeuuid and cql3 query

2013-06-19 Thread Davide Anastasia
Hi Tyler, I am interested in this scenario as well: could you please elaborate further your answer? Thanks a lot, Davide On 19 Jun 2013 16:01, "Tyler Hobbs" wrote: > > On Wed, Jun 19, 2013 at 8:08 AM, Ryan, Brent wrote: > >> >> CREATE TABLE count3 ( >> counter text, >> ts timeuuid, >> ke

Re: timeuuid and cql3 query

2013-06-19 Thread Tyler Hobbs
On Wed, Jun 19, 2013 at 8:08 AM, Ryan, Brent wrote: > > CREATE TABLE count3 ( > counter text, > ts timeuuid, > key1 text, > value int, > PRIMARY KEY ((counter, ts)) > ) > Instead of doing a composite partition key, remove a set of parens and let ts be your clustering key. That will c

timeuuid and cql3 query

2013-06-19 Thread Ryan, Brent
I'm experimenting with a data model that will need to ingest a lot of data that will need to be query able by time. In the example below, I want to be able to run a query like "select * from count3 where counter = 'test' and ts > minTimeuuid('2013-06-18 16:23:00') and ts < minTimeuuid('2013-06-