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 491E2D579 for ; Tue, 11 Dec 2012 22:00:21 +0000 (UTC) Received: (qmail 63561 invoked by uid 500); 11 Dec 2012 22:00:18 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 63540 invoked by uid 500); 11 Dec 2012 22:00:18 -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 63532 invoked by uid 99); 11 Dec 2012 22:00:18 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 22:00:18 +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 (nike.apache.org: local policy) Received: from [192.174.58.133] (HELO XEDGEB.nrel.gov) (192.174.58.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 11 Dec 2012 22:00:13 +0000 Received: from XHUBB.nrel.gov (10.20.4.59) by XEDGEB.nrel.gov (192.174.58.133) with Microsoft SMTP Server (TLS) id 8.3.245.1; Tue, 11 Dec 2012 14:59:49 -0700 Received: from MAILBOX2.nrel.gov ([fe80::19a0:6c19:6421:12f]) by XHUBB.nrel.gov ([::1]) with mapi; Tue, 11 Dec 2012 14:59:51 -0700 From: "Hiller, Dean" To: "user@cassandra.apache.org" Date: Tue, 11 Dec 2012 14:59:47 -0700 Subject: Re: Primary/secondary index question / best practices? Thread-Topic: Primary/secondary index question / best practices? Thread-Index: Ac3X6tgxBuRUoeFESfqVByPu1WfIrw== 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.5.121010 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 That was supposed to read "Hard to help out" oops. On 12/11/12 2:56 PM, "Hiller, Dean" wrote: >Have to help out on a design without specifics but here is some advice >based on the limited information > >Primary key : yes, must be cluster unique. TimeUUID or UUID=8A.PlayOrm ha= s >very unique TimeUUID like keys as in this one 7AL2S8Y.b1 (b1 is the >hostname and the prefix is a "unique" timestamp but generated to a >shorter string(ah, nice readable primary keys). > >There are some patterns you can look into here that may help >https://github.com/deanhiller/playorm/wiki/Patterns-Page > >If you can partition your data virtually, it may help a lot so you can >query into the partitions. > >Later, >Dean > >From:=20 >"Stephen.M.Thompson@wellsfargo.comm>"=20 >m>> >Reply-To: "user@cassandra.apache.org" >> >Date: Tuesday, December 11, 2012 2:49 PM >To: "user@cassandra.apache.org" >> >Subject: Primary/secondary index question / best practices? > >m my reading, it seems like I need a UUID column that will be my primary >index, and then I should set up secondary indexes on the 8-10 primary >search columns. Am I understanding this correctly? Any advice you can >offer on this would be tremendously helpful. I=B9m quite limited in how >specific I can be about the data, of course.