Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 87897 invoked from network); 30 Nov 2010 06:11:54 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 30 Nov 2010 06:11:54 -0000 Received: (qmail 47640 invoked by uid 500); 30 Nov 2010 06:11:52 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 47531 invoked by uid 500); 30 Nov 2010 06:11:52 -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 47523 invoked by uid 99); 30 Nov 2010 06:11:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Nov 2010 06:11:52 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of arijit72@gmail.com designates 209.85.216.172 as permitted sender) Received: from [209.85.216.172] (HELO mail-qy0-f172.google.com) (209.85.216.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Nov 2010 06:11:44 +0000 Received: by qyk34 with SMTP id 34so818476qyk.10 for ; Mon, 29 Nov 2010 22:11:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=kHukvUoyPdyrmTwNYAgT6Tv9d798kfdxoFw34bfmFDk=; b=JyFYn597ovMktNo/RR84osZoIbnP/veR1R3T6FraGm1pkyaR2ZkrxPQQEUx8tu/I3h LI4GgheB9wiC3tcYWD/bWSaesuel3Qq83aLM2XKorlUmhV0yfTQp3SMBw/sPHGQptrIP c2SKjtMA5HijUzsjfsZC/IK1njGjCBHi/8/u8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=HRkFejiiDmHzhpLMAZwd3xxb6NkzoVKdHD9hy2OSfCgchVj5+voKtZLbBtkfDiAobj +3E4kkgMDHxDhqH9nUGbSg3rQ1FtJectcDEqZ3nP+1xA1yvVDEgI+0CE3YHArD+88KOV M12vqI7sRvoFJHxtPAXdQM1SYmvayMshoVd7U= MIME-Version: 1.0 Received: by 10.229.230.197 with SMTP id jn5mr5637274qcb.274.1291097482882; Mon, 29 Nov 2010 22:11:22 -0800 (PST) Received: by 10.229.41.147 with HTTP; Mon, 29 Nov 2010 22:11:22 -0800 (PST) Date: Tue, 30 Nov 2010 11:41:22 +0530 Message-ID: Subject: partial matching of keys From: Arijit Mukherjee To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi All I was wondering if it is possible to match keys partially while searching in Cassandra. I have a requirement where I'm storing a large number of records, the key being something like "A|B|T" where A and B are mobile numbers and T is the time-stamp (the time when A called B). Such format ensure the uniqueness of the keys. Now if I want to search for all records where A called B, I would like to do a partial match with "A|B". Is this possible? I've another small question - where can I find some complete examples of creating a cluster and communicating with it (for insertion/deletion of records) using Hector or Pelops? So far, I've been doing this via the Thrift interface, but it's becoming illegible now... Thanks in advance... Regards Arijit -- "And when the night is cloudy, There is still a light that shines on me, Shine on until tomorrow, let it be."