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 BC24D9ED4 for ; Sat, 29 Oct 2011 17:29:13 +0000 (UTC) Received: (qmail 86382 invoked by uid 500); 29 Oct 2011 17:29:11 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 86328 invoked by uid 500); 29 Oct 2011 17:29:11 -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 86320 invoked by uid 99); 29 Oct 2011 17:29:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2011 17:29:11 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mohitanchlia@gmail.com designates 209.85.210.46 as permitted sender) Received: from [209.85.210.46] (HELO mail-pz0-f46.google.com) (209.85.210.46) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2011 17:29:03 +0000 Received: by pzk2 with SMTP id 2so14516208pzk.5 for ; Sat, 29 Oct 2011 10:28:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=3QmQbHqijv0npqmMQlx5b+OsJwP8EgSobRuLegVYLd8=; b=BF4rpG/OPB3yB3oiOTa2VqO5YppgotQS9GWA/M7H7ekq1/kisXj96mVVANmcHwmHSl qltN0jJUtJgbC1mlh9LYE0AyMsYTQj+clFdNeeATUfsGGlkNng+lm8IKVVCeq/xa9JAq cxoFTxF1I7QONbncm7+51Ct5zEPcUBr/bCG44= MIME-Version: 1.0 Received: by 10.68.72.73 with SMTP id b9mr11689060pbv.100.1319909322707; Sat, 29 Oct 2011 10:28:42 -0700 (PDT) Received: by 10.68.43.68 with HTTP; Sat, 29 Oct 2011 10:28:42 -0700 (PDT) In-Reply-To: References: Date: Sat, 29 Oct 2011 10:28:42 -0700 Message-ID: Subject: Re: Programmatically allow only one out of two types of rows in a CF to enter the CACHE From: Mohit Anchlia To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Yes you need 2 queries but a better schema design. I think you might be trying to optimize where it actually will not give you any gain except few lines of less code. Can you give an example of what you are trying to do? Other question why not store in within the same row? On Sat, Oct 29, 2011 at 10:22 AM, Aditya Narayan wrote: > ..so that I can retrieve them through a single query. > > For reading cols from two CFs you need two queries, right ? > > > > > On Sat, Oct 29, 2011 at 9:53 PM, Mohit Anchlia > wrote: >> >> Why not use 2 CFs? >> >> On Fri, Oct 28, 2011 at 9:42 PM, Aditya Narayan wrote: >> > I need to keep the data of some entities in a single CF but split in two >> > rows for each entity. One row contains an overview information for the >> > entity & another row contains detailed information about entity. I am >> > wanting to keep both rows in single CF so they may be retrieved in a >> > single >> > query when required together. >> > >> > Now the problem I am facing is that I want to cache only first type of >> > rows(ie, the overview containing rows) & avoid second type rows(that >> > contains large data) from getting into cache. >> > >> > Is there a way I can manipulate such filtering of cache entering rows >> > from a >> > single CF? >> > >> > >> > > >