Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Cassandra Column TTL Support in DSE Search

DZone's Guide to

Cassandra Column TTL Support in DSE Search

· Database Zone ·
Free Resource

Built by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.  

Alex Liu, of the Datastax Cassandra Developer Center, recently blogged about Cassandra's ability to support column TTL (time to live). He describes how Column TTL works, as well as how DSE search supports column TTL.  Here's what he has to say about the future - you can read the original post  here:

Good Practice to Set TTL Index Rebuilding Parameters

TTL index rebuilding does consume resources, e.g. cpu, memory and read Cassandra column families. You can make the re-indexing frequency to a longer time if there’s not much TTL data in Cassandra column families. For common use case, you need check the frequency of your compaction, and assign the re-indexing frequency to short than compaction frequency and match the re-indexing frequency to your business requirement.

Future Work

We may make TTL re-indexing per column family, and expose it to the administration page, so we can tune it for each column family. We may have a per index TTL which can be set through solr restful API. I believe those enhancement will be available in the feature.

We may also make Cassandra to support PUSH, so it can automatically re-index the data when column expired. Another thought is to have a row base TTL.

Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.  

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}