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 795F6104F4 for ; Tue, 29 Oct 2013 14:26:25 +0000 (UTC) Received: (qmail 16617 invoked by uid 500); 29 Oct 2013 14:25:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 16598 invoked by uid 500); 29 Oct 2013 14:25:25 -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 16581 invoked by uid 99); 29 Oct 2013 14:25:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Oct 2013 14:25:23 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of 8forty@gmail.com designates 209.85.223.176 as permitted sender) Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com) (209.85.223.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Oct 2013 14:25:15 +0000 Received: by mail-ie0-f176.google.com with SMTP id u16so13526465iet.7 for ; Tue, 29 Oct 2013 07:24:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type; bh=FBsAZu/acPo4CcYv0YgvEAE1WgnBOgho91rByVT9W7c=; b=RQTzMuwQQH5r4VLajoIGyX3LRag6M1HazuqE0p8zbiooCR3T9X2C+lsevoZhCRgeoA 1VI0koT4BbTXZ3GYbzh0TrRPHvSwZzdQLMCPt8CbUjofI12Uk9p8y4+ZYCzQabzH/J0g kcdgpplmzD6+k9DwpWiYEfpZLG20J00aLlYFf1AcvIsNogsvIIIcqMtMx4S0YFEQ7LXp QwSFJI8tMwiwbjzX/AOLGKu+cpSo/xjigjjFRxxy6JnhDU6XKfYBBt0GGZKE0i0XBN6f uaZNjRXaAcv14g1sWYkPSq+WKy/SU54yBMO7kCPNUTrl/8Bsnf06i25k7YzwJV+KsRRw 7Ajg== X-Received: by 10.50.30.42 with SMTP id p10mr12587732igh.5.1383056694069; Tue, 29 Oct 2013 07:24:54 -0700 (PDT) Received: from [127.0.0.1] ([162.216.44.217]) by mx.google.com with ESMTPSA id q6sm2888861igi.0.2013.10.29.07.24.52 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 29 Oct 2013 07:24:53 -0700 (PDT) Message-ID: <526FC533.1070106@gmail.com> Date: Tue, 29 Oct 2013 08:24:51 -0600 From: Keith Freeman <8forty@gmail.com> User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.0 MIME-Version: 1.0 To: user@cassandra.apache.org Subject: Re: CQL & selecting individual items from a map References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------050801000405060604090909" X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------050801000405060604090909 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit There's some rationale here: http://mail-archives.apache.org/mod_mbox/cassandra-user/201305.mbox/%3CCAENxBwx6pcSA=cWn=dKW_52K5odw5F3Xigj-zn_4BwFth+4ruA@mail.gmail.com%3E And I'm sure part of the reason is the 64k size limit: maps (and sets and lists) are limited to 64k total size (http://wiki.apache.org/cassandra/CassandraLimitations), so it wouldn't be very read-efficient to load individual elements. On 10/28/2013 08:03 PM, Liam Stewart wrote: > I was wondering if anybody could explain the rationale behind > disallowing selection of individual elements from a map in CQL and why > an entire map must be retrieved at once when items are stored as > distinct columns? Are there any plans to allow individual selection? > > -- > Liam Stewart :: liam.stewart@gmail.com --------------050801000405060604090909 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit There's some rationale here: http://mail-archives.apache.org/mod_mbox/cassandra-user/201305.mbox/%3CCAENxBwx6pcSA=cWn=dKW_52K5odw5F3Xigj-zn_4BwFth+4ruA@mail.gmail.com%3E

And I'm sure part of the reason is the 64k size limit: maps (and sets and lists) are limited to 64k total size (http://wiki.apache.org/cassandra/CassandraLimitations), so it wouldn't be very read-efficient to load individual elements.

On 10/28/2013 08:03 PM, Liam Stewart wrote:
I was wondering if anybody could explain the rationale behind disallowing selection of individual elements from a map in CQL and why an entire map must be retrieved at once when items are stored as distinct columns? Are there any plans to allow individual selection?

--
Liam Stewart :: liam.stewart@gmail.com

--------------050801000405060604090909--