SlicePredicate only support “N” columns. So, you need to query one facet at a
time OR you can query m columns such that it returns n revisions. You may need
intelligence to increase or decrease m columns heuristically.
From: ravi prasad
Sent: Tuesday, July 30, 2013 8:11 PM
To: cas
Hi,
I have a data modelling question. I'm modelling for an use case where, an
object can have multiple facets and each facet can have multiple revisions and
the query pattern looks like "get latest 'n' revisions for all facets for an
object (n=1,2,3)". With a table like below:
create tabl
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-
14 matches
Mail list logo
