Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 43979 invoked from network); 22 Jun 2010 15:00:06 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Jun 2010 15:00:06 -0000 Received: (qmail 1939 invoked by uid 500); 22 Jun 2010 15:00:05 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 1866 invoked by uid 500); 22 Jun 2010 15:00:04 -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 1858 invoked by uid 99); 22 Jun 2010 15:00:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jun 2010 15:00:04 +0000 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.160.172] (HELO mail-gy0-f172.google.com) (209.85.160.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jun 2010 14:59:55 +0000 Received: by gyh4 with SMTP id 4so3223717gyh.31 for ; Tue, 22 Jun 2010 07:59:34 -0700 (PDT) MIME-Version: 1.0 Received: by 10.150.132.7 with SMTP id f7mr6332456ybd.350.1277218774327; Tue, 22 Jun 2010 07:59:34 -0700 (PDT) Received: by 10.151.40.7 with HTTP; Tue, 22 Jun 2010 07:59:34 -0700 (PDT) X-Originating-IP: [80.179.102.198] Date: Tue, 22 Jun 2010 17:59:34 +0300 Message-ID: Subject: Finding new Cassandra data From: David Boxenhorn To: Cassandra Mailing List Content-Type: multipart/alternative; boundary=000e0cd4884a58231c04899fab21 X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd4884a58231c04899fab21 Content-Type: text/plain; charset=ISO-8859-1 In my system, I have a Cassandra front end, and an Oracle back end. Some information is created in the back end, and pushed out to the front end, and some information is created in the front end and pulled into the back end. Question: How do I locate new rows that have been crated in Cassandra, for import into Oracle? I'm thinking of having a special column family "newRows" that contains only the keys of the new rows. The offline process would look there to see what's new, then delete those rows. The "newRows" CF would have no data! (The data would be in the "real" CF.) Is this a good solution? It seems weird to have a CF with rows but no data. But I can't think of a better way. Any thoughts? --000e0cd4884a58231c04899fab21 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
In my system, I have a Cassandra front end, and an Oracle = back end. Some information is created in the back end, and pushed out to th= e front end, and some information is created in the front end and pulled in= to the back end.

Question: How do I locate new rows that have been crated in Cassandra, = for import into Oracle?

I'm thinking of having a special column= family "newRows" that contains only the keys of the new rows. Th= e offline process would look there to see what's new, then delete those= rows. The "newRows" CF would have no data! (The data would be in= the "real" CF.)

Is this a good solution? It seems weird to have a CF with rows but no d= ata. But I can't think of a better way.

Any thoughts?
--000e0cd4884a58231c04899fab21--