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 A48D1D819 for ; Mon, 5 Nov 2012 15:13:04 +0000 (UTC) Received: (qmail 94153 invoked by uid 500); 5 Nov 2012 15:13:02 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 93932 invoked by uid 500); 5 Nov 2012 15:12:56 -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 93905 invoked by uid 99); 5 Nov 2012 15:12:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Nov 2012 15:12:56 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com designates 209.85.223.172 as permitted sender) Received: from [209.85.223.172] (HELO mail-ie0-f172.google.com) (209.85.223.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Nov 2012 15:12:51 +0000 Received: by mail-ie0-f172.google.com with SMTP id 9so9159611iec.31 for ; Mon, 05 Nov 2012 07:12:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=gY605eASSiJBnjCxBqRCCfTn/RRerdseP4uDO/+T09E=; b=fef3JGSUR/EI4BrdIRGNQA0eRw23gEzRU2uQ2waobWRQ0QNzKKQC/rC9Fzk9OqkcjT d0HA4Ac3EyfLM0sH4gmlQA8xOIRv8p+umuigZUqb5cF0W6FNkVRgPywyXZQQZVmpBqDX UY+X9fAN3HWxH3yzR2Cak2ZknUkDsIbhuraFMMQjP7YdFaWfmmw7VsedYOyspy6td8bX SlwGMvOa24bdnvkxqmRXyc9jj+KzEQe8s5ATYel2N39qpNXeWIFl+QdzGizEubEj/uEz tdUVE/P/pgRLzHwqqxeTbkWr1kR6cFqjuVyOaAYEzvUhy/Rn1xQ6YkWicEpqhfYqVz24 nPuQ== MIME-Version: 1.0 Received: by 10.43.116.135 with SMTP id fi7mr8515642icc.3.1352128350623; Mon, 05 Nov 2012 07:12:30 -0800 (PST) Received: by 10.64.97.106 with HTTP; Mon, 5 Nov 2012 07:12:30 -0800 (PST) In-Reply-To: References: Date: Mon, 5 Nov 2012 10:12:30 -0500 Message-ID: Subject: Re: How does Cassandra optimize this query? From: Edward Capriolo To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Interesting, Is this query the equivalent of a full table scan? Without a starting point get_range_slice is just starting at token 0? Edward On Mon, Nov 5, 2012 at 2:18 AM, Sylvain Lebresne wrote: > On Sun, Nov 4, 2012 at 7:49 PM, Edward Capriolo > wrote: >> >> CQL3 Allows me to search the second component of a primary key. Which >> really just seems to be component 1 of a composite column. >> >> So what thrift operation does this correspond to? This looks like a >> column slice without specifying a key? How does this work internally? > > > get_range_slice (with the right slice predicate to select the columns where > the first component == 'My funny cat') > > -- > Sylvain