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
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
;
>
> 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
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
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
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
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
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
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
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
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
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-
12 matches
Mail list logo