Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AED606F57 for ; Fri, 20 May 2011 23:35:44 +0000 (UTC) Received: (qmail 21887 invoked by uid 500); 20 May 2011 23:35:42 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 21860 invoked by uid 500); 20 May 2011 23:35:42 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 21852 invoked by uid 500); 20 May 2011 23:35:42 -0000 Delivered-To: apmail-incubator-cassandra-user@incubator.apache.org Received: (qmail 21849 invoked by uid 99); 20 May 2011 23:35:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 May 2011 23:35:42 +0000 X-ASF-Spam-Status: No, hits=4.8 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HK_RANDOM_ENVFROM,RFC_ABUSE_POST,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.236.26 is neither permitted nor denied by domain of teddyyyy123@gmail.com) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 May 2011 23:35:38 +0000 Received: from jim.nabble.com ([192.168.236.80]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QNZDy-0001EH-C7 for cassandra-user@incubator.apache.org; Fri, 20 May 2011 16:35:18 -0700 Date: Fri, 20 May 2011 16:35:18 -0700 (PDT) From: yangyangyyy To: cassandra-user@incubator.apache.org Message-ID: <1305934518362-6388192.post@n2.nabble.com> In-Reply-To: References: Subject: Re: RTG/MRTG/Cricket replacement using Cassandra? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hi Ryan: Thanks for the link. I read the slides, could you please provide some more details on how the temporal aggregation is implemented? do you use time+granularity as the key ? or as column names ? Thanks Yang In reply to this post by Aaron Turner We have a solution for time series data on cassandra at Twitter that we'd like to open source, but it requires 0.8/trunk so we're not going to release it until that's stable. See http://www.slideshare.net/kevinweil/rainbird-realtime-analytics-at-twitter-strata-2011 -ryan On Thu, Mar 31, 2011 at 3:56 PM, Aaron Turner <[hidden email]> wrote: > I've been looking at replacing our PostgreSQL backend for RTG (a SNMP > based polling and graphing solution for network traffic/ports) with > something using Cassandra in order to solve our scalability and > redundancy requirements. Based on a lot of what I've read, Cassandra > is an ideal data store for this time series data. In fact, Eric > Evans in his presentation on the Cassandra home page suggests that > this kind of use case is perfect for Cassandra. > > So this got me wondering if someone had already come up with a CF > model for this kind of data, including daily/weekly/monthly/yearly > rollups. Perhaps there's even an open source project or two > implementing this sorta thing? I've found flewton > (https://github.com/flewton/flewton), which is possibly relevant, but > my Java skills are pretty non-existent so I'm having a hard time > figuring it out. > > Thanks, > Aaron > > -- > Aaron Turner > http://synfin.net/ http://synfin.net/ Twitter: @synfinatic > http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & > Windows > Those who would give up essential Liberty, to purchase a little temporary > Safety, deserve neither Liberty nor Safety. > -- Benjamin Franklin > "carpe diem quam minimum credula postero" > ... [show rest of quote] -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/RTG-MRTG-Cricket-replacement-using-Cassandra-tp6229322p6388192.html Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.