Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 44272 invoked from network); 6 Feb 2011 08:15:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Feb 2011 08:15:20 -0000 Received: (qmail 93710 invoked by uid 500); 6 Feb 2011 08:15:18 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 93435 invoked by uid 500); 6 Feb 2011 08:15:14 -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 93425 invoked by uid 99); 6 Feb 2011 08:15:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Feb 2011 08:15:13 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of rajkumar.w93@gmail.com designates 209.85.161.44 as permitted sender) Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Feb 2011 08:15:05 +0000 Received: by fxm9 with SMTP id 9so4108210fxm.31 for ; Sun, 06 Feb 2011 00:14:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:date:x-google-sender-auth :message-id:subject:from:to:content-type; bh=yXFnTfO6jeaTiD28udHhpziPOifz/IEeJU4hMdNVaXI=; b=SouGqKU3CaHCwpd1X4eGiRZ+2vdr+Ou7NKUW2rUY1uPxEa/L8Bsf8Tw6pNU9VhT02a JObcFBG1XAH1DyOsoavXwTIW5MsbRSWxH56uwwJOfTWdDmfd8CCuhiddMIRLWjSs8aY2 QDN5IMdbstnkWhDQroXNlWzROQrZVYm7ZdbNg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:date:x-google-sender-auth:message-id:subject :from:to:content-type; b=qzPUaRO/xjXcJdHjLtXdTpKimol4qZWxbq+jWHINIJTUOZEqOEWlt1t40+oaLv0w0+ KM4con1udIHh7QrLUmqdU0GzanpyicxEj2C6PTfB0/3gcVK8aO+ENcRtYBk6ZajI407Z MlMI6Nt9lirqUJpYrfUgHAFrdo4i71GwM8sbg= MIME-Version: 1.0 Received: by 10.223.72.15 with SMTP id k15mr336429faj.54.1296980085324; Sun, 06 Feb 2011 00:14:45 -0800 (PST) Sender: rajkumar.w93@gmail.com Received: by 10.223.87.72 with HTTP; Sun, 6 Feb 2011 00:14:45 -0800 (PST) Date: Sun, 6 Feb 2011 13:44:45 +0530 X-Google-Sender-Auth: TGOaFr1H5-Z6n6_J26esAIxIihs Message-ID: Subject: Finding the intersection results of column sets of two rows From: Aklin_81 To: user , hector-users@googlegroups.com Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hi all, I want to procure the intersection of columns set of two rows (from 2 different column families). To achieve the intersection results, Can I, first retrieve all columns(around 300) from first row and just query by those column names in the second row(which contains maximum 100 000 columns) ? I am using the results during the write time & not before presentation to the user, so latency wont be much concern while writing. Is it the proper way to procure intersection results of two rows ? Would love to hear your comments.. --------- Regards, Asil