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 A4B84D58F for ; Tue, 18 Sep 2012 20:31:37 +0000 (UTC) Received: (qmail 13394 invoked by uid 500); 18 Sep 2012 20:31:35 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 13378 invoked by uid 500); 18 Sep 2012 20:31:35 -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 13366 invoked by uid 99); 18 Sep 2012 20:31:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 20:31:35 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [192.174.58.134] (HELO XEDGEA.nrel.gov) (192.174.58.134) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Sep 2012 20:31:28 +0000 Received: from XHUBB.nrel.gov (10.20.4.59) by XEDGEA.nrel.gov (192.174.58.134) with Microsoft SMTP Server (TLS) id 8.3.245.1; Tue, 18 Sep 2012 14:30:57 -0600 Received: from MAILBOX2.nrel.gov ([fe80::19a0:6c19:6421:12f]) by XHUBB.nrel.gov ([::1]) with mapi; Tue, 18 Sep 2012 14:31:07 -0600 From: "Hiller, Dean" To: "user@cassandra.apache.org" Date: Tue, 18 Sep 2012 14:31:05 -0600 Subject: Re: Is Cassandra right for me? Thread-Topic: Is Cassandra right for me? Thread-Index: Ac2V3IeWVMq8J+vNQEmCfz7rXFKvaw== Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.3.120616 acceptlanguage: en-US Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org Cassandra is fully aware of all tables created with playOrm and you can sti= ll use DataStax enterprise features to get real time analytics. Playroom i= s a layer on top of cassandra and with any layer it makes a developer more = productive at a slight cost of performance just like hibernate on top of JD= BC. In some cases though, we find because someone uses the S-SQL instead o= f reading in full rows themselves, it has actually sped up their applicatio= n in certain use cases=85this is kind of unusual when putting a layer on to= p of the interface to cassandra. Also, playOrm is working on a ad-hoc query tool to view all indexes created= by playOrm as well as query into all rows in partitions so you can ad-hoc = inspect your data much easier. CQL can also be used as a complement to S-S= QL(playOrm's SQL with partitions) in that you could analyze a full table bu= t CQL doesn't do joins and you have to use equality operator and other limi= tations. S-SQL is limited by only viewing into partitions which is okay fo= r many OLTP applications. For analytics, usually one needs to break out of= the partitions and look at the more global data set=85ie. Map/reduce and C= QL help there. Later, Dean From: Marcelo Elias Del Valle > Reply-To: "user@cassandra.apache.org" > Date: Tuesday, September 18, 2012 10:50 AM To: "user@cassandra.apache.org" > Subject: Re: Is Cassandra right for me? I also saw that if I plan to use Data Stax enterprise to get real time anal= ytics, my data would need to be stored in Cassandra's usual format. It woul= d harder for me use PlayOrm if I am planning to use advanced data stax feat= ures, like Solr indexing data on Cassandra without copying columns, realtim= e, wouldn't it? I don't know much of this Solr feature yet, but my understa= nding today is it wouldn't be aware of the tables I create with playOrm, ju= st of the column families this framework uses to store the data, right?