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 F12FD6BA5 for ; Fri, 20 May 2011 13:56:42 +0000 (UTC) Received: (qmail 48296 invoked by uid 500); 20 May 2011 13:56:41 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 48264 invoked by uid 500); 20 May 2011 13:56:41 -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 48256 invoked by uid 99); 20 May 2011 13:56:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 May 2011 13:56:40 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_FRT_FOLLOW1,T_FRT_FOLLOW2,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of monkey1024.public@gmail.com designates 209.85.210.44 as permitted sender) Received: from [209.85.210.44] (HELO mail-pz0-f44.google.com) (209.85.210.44) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 May 2011 13:56:33 +0000 Received: by pzk5 with SMTP id 5so2292973pzk.31 for ; Fri, 20 May 2011 06:56:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=Afe+ao5Rt37NI0qxY7gZQI4D2PvxDe7ODiXz8K0l7ow=; b=YBStQlAjJ1j9SvaODtCQ/uy4JLu9ijwZtirKkJTQ7Q5TUBMuAQUOk9wgsHQ6YEl57a lYHSKRCuqGCDYPz5PA5Alr4/JP7EJyq19rNYDH1ktdsYH6n6e9I77uiUnVWBdUT3B8mb rvVD6s+UAMAmHWzj/ARumvWuD0mzU2uedYBmg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=x1AvBCoGnml7/QaN5IBdSohA+cpppVMkpvFwmYgtfpGThP7IR58lAKYl+rmol8l4i/ GHFZF/L3yWw7eWDtIrQIj0x8Yj8bSRK+1X/Gpwp2UB46F8cJ5rHqpuUM9H1mkbjoq3LD UiYjhNCWXfGWXhbYZoNhamQ4YYFa4M60E7SWM= MIME-Version: 1.0 Received: by 10.143.25.22 with SMTP id c22mr2598921wfj.267.1305899771748; Fri, 20 May 2011 06:56:11 -0700 (PDT) Received: by 10.143.164.11 with HTTP; Fri, 20 May 2011 06:56:11 -0700 (PDT) Date: Fri, 20 May 2011 21:56:11 +0800 Message-ID: Subject: how to use indexed column for this case From: Monkey me To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001636e0b63401e34104a3b57c62 X-Virus-Checked: Checked by ClamAV on apache.org --001636e0b63401e34104a3b57c62 Content-Type: text/plain; charset=ISO-8859-1 Hi, I have a SCF, Key is string, super column is TimeUUID, and several columns with one column named "type", I create secondary index on this column. I want to have the foliowing query to fetch all super columns along with all columns. 1. given a specific key 2. given a range of super column (start time to end time) 3. given specific "type" value. Is such query possible? I could not figure out how to use getIndexedSlice to achieve this. Any idea? Thanks. Hou --001636e0b63401e34104a3b57c62 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,
=A0 =A0 =A0I have a SCF, Key is string, super column is TimeUUID, a= nd several columns with one column named "type", I create seconda= ry index on this column. =A0I want to have the foliowing query to fetch all= super columns along with all columns.
=A0 =A0 =A01. given a specific key
=A0 =A0 =A02. given a ran= ge of super column (start time to end time)
=A0 =A0 =A03. given s= pecific "type" value.
=A0 =A0 =A0
=A0 =A0 =A0= Is such query possible? I could not figure out how to use getIndexedSlice t= o achieve this. Any idea? Thanks.


Hou
--001636e0b63401e34104a3b57c62--