On Wed, Jan 9, 2013 at 3:37 PM, wrote:
> OK … I think I understand these. So the idea is that you would use the
> time as the column key?
>
> ** **
>
> So when I might have something like this:
>
> ** **
>
> | time=2013/01/03 08:19:01 | user=john | site=Chicago
>
> | time=2013/01/
that right?
This seems like an impossible solution for my requirements.
Steve
From: Tyler Hobbs [mailto:ty...@datastax.com]
Sent: Wednesday, January 09, 2013 2:21 PM
To: user@cassandra.apache.org
Subject: Re: Date Index?
If you're going to be looking data up by date ranges frequent
t show me much.
>
> ** **
>
> Steve
>
> ** **
>
> *From:* aaron morton [mailto:aa...@thelastpickle.com]
>
> *Sent:* Tuesday, January 08, 2013 9:35 PM
> *To:* user@cassandra.apache.org
> *Subject:* Re: Date Index?
>
> ** **
>
> There has t
e much.
Steve
From: aaron morton [mailto:aa...@thelastpickle.com]
Sent: Tuesday, January 08, 2013 9:35 PM
To: user@cassandra.apache.org<mailto:user@cassandra.apache.org>
Subject: Re: Date Index?
There has to be one equality clause in there, and thats the thing to cassandra
uses to select
]
Sent: Tuesday, January 08, 2013 9:35 PM
To: user@cassandra.apache.org
Subject: Re: Date Index?
There has to be one equality clause in there, and thats the thing to cassandra
uses to select of disk. The others are in memory filters.
So if you have one on the year+month you can have a simple se
There has to be one equality clause in there, and thats the thing to cassandra
uses to select of disk. The others are in memory filters.
So if you have one on the year+month you can have a simple select clause and it
limits the amount of data that has to be read.
If you have like many 10's to
Hi folks -
Question about secondary indexes. How are people doing date indexes?I have
a date column in my tables in RDBMS that we use frequently, such as look at all
records recorded in the last month. What is the best practice for being able
to do such a query? It seems like there could
