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 4D8464597 for ; Sat, 9 Jul 2011 19:15:30 +0000 (UTC) Received: (qmail 96770 invoked by uid 500); 9 Jul 2011 19:15:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 96747 invoked by uid 500); 9 Jul 2011 19:15:27 -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 96739 invoked by uid 99); 9 Jul 2011 19:15:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Jul 2011 19:15:27 +0000 X-ASF-Spam-Status: No, hits=1.6 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of eldad87@gmail.com designates 74.125.82.172 as permitted sender) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Jul 2011 19:15:22 +0000 Received: by wyj26 with SMTP id 26so2205701wyj.31 for ; Sat, 09 Jul 2011 12:15:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; bh=sTT7IE9rgLCH1LOi0FF53UkULQFm2S8qj3+W3RMazFQ=; b=wZjQBB3MMURL1V2TchK0UkJOBTnQuo8xTM2StjmomSE+gECZjLaV4Cv8IR56KdxKbR N9vW63dl49ied22bxA4oNEZYyP5QQ8fEkar21/CibAyfKJcymSgPWUwv46YB/03cdwq4 w2h28kH8qtz6Wzi/kfFA4v0WTGaDrosSXELGc= MIME-Version: 1.0 Received: by 10.216.169.19 with SMTP id m19mr1728521wel.31.1310238900948; Sat, 09 Jul 2011 12:15:00 -0700 (PDT) Received: by 10.216.187.11 with HTTP; Sat, 9 Jul 2011 12:15:00 -0700 (PDT) Date: Sat, 9 Jul 2011 22:15:00 +0300 Message-ID: Subject: Cassandra Secondary index/Twissandra From: Eldad Yamin To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=0016e65b5d7e430eb904a7a7c470 --0016e65b5d7e430eb904a7a7c470 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi, I have few questions: *Secondary index* 1. Is there a limit on the number of columns in a single column family that serve as secondary indexes? 2. Does performance decrease (significantly) if the uniqueness of the column=92s values is high? *Twissandra* 1. Why in the source (or any tutorial I've read): The CF for "Userline"/"Uimeline" - have comparator of "LONG_TYPE" and no= t TimeUUID? https://github.com/twissandra/twissandra/blob/master/tweets/management/c= ommands/sync_cassandra.py 2. Does performance decrease (significantly) if the uniqueness of the column=92s name is high when comparator is LONG_TYPE/TimeUUID and each r= ow has lots of columns? Thanks! Eldad --0016e65b5d7e430eb904a7a7c470 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
Hi,
I have few questions:

Secondary index
  1. Is there a limit on the number of= columns in a single column family that serve as secondary indexes?=A0
    2. =
  2. Does performance decrease (significantly) if the uniqueness of the column= =92s values is high?

Twissandra
  1. Why in the source (or any tutorial I've read):
    The = CF for "Userline"/"Uimeline" - have comparator of "= ;LONG_TYPE" and not TimeUUID?
    https://github.com/twissandra/twissandra= /blob/master/tweets/management/commands/sync_cassandra.py
  2. Does performance decrease (significantly) if the uniqueness of the column= =92s name is high when=A0comparator=A0is LONG_TYPE/TimeUUID and each row ha= s lots of columns?

Thanks!
Eld= ad
--0016e65b5d7e430eb904a7a7c470--