incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabbar Azam <aja...@gmail.com>
Subject Re: Is there anyone who implemented time range partitions with column families?
Date Wed, 29 May 2013 16:13:56 GMT
Hello Cem,

You can get a similar effect by specifying a TTL value for data you save to
a table. If the data becomes older than the TTL value then it will
automatically be deleted by  C*

Thanks

Jabbar Azam


On 29 May 2013 17:01, cem <cayiroglu@gmail.com> wrote:

> Thank you very much for the fast answer.
>
> Does playORM use different column families for each partition in
> Cassandra?
>
> Cem
>
>
> On Wed, May 29, 2013 at 5:30 PM, Jeremy Powell <jeremym.powell@gmail.com>wrote:
>
>> Cem, yes, you can do this with C*, though you have to handle the logic
>> yourself (other libraries might do this for you, seen the dev of playORM
>> discuss some things which might be similar).  We use Astyanax
>> and programmatically create CFs based on a time period of our choosing that
>> makes sense for our system, programmatically drop CFs if/when they are
>> outside a certain time period (rather than using C*'s TTL), and write data
>> to the different CFs as needed.
>>
>> ~Jeremy
>>
>> On Wed, May 29, 2013 at 8:36 AM, cem <cayiroglu@gmail.com> wrote:
>>
>>> Hi All,
>>>
>>> I used time range partitions 5 years ago with MySQL to clean up data
>>> much faster.
>>>
>>> I had a big FACT table with time range partitions and it was very is to
>>> drop old partitions (with archiving) and do some saving on disk.
>>>
>>> Has anyone implemented such a thing in Cassandra? It would be great if
>>> we have that in Cassandra.
>>>
>>> Best Regards,
>>> Cem.
>>>
>>
>>
>

Mime
View raw message