From user-return-64363-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Mon Aug 19 20:23:57 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id DDD38180665 for ; Mon, 19 Aug 2019 22:23:56 +0200 (CEST) Received: (qmail 79253 invoked by uid 500); 19 Aug 2019 20:23:54 -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 79242 invoked by uid 99); 19 Aug 2019 20:23:54 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Aug 2019 20:23:54 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id EE2AD1A3280 for ; Mon, 19 Aug 2019 20:23:53 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.051 X-Spam-Level: ** X-Spam-Status: No, score=2.051 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id i3Nv9jqKZIPi for ; Mon, 19 Aug 2019 20:23:51 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.161.42; helo=mail-yw1-f42.google.com; envelope-from=rahulreddy1234@gmail.com; receiver= Received: from mail-yw1-f42.google.com (mail-yw1-f42.google.com [209.85.161.42]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 7604DBC7A9 for ; Mon, 19 Aug 2019 20:23:51 +0000 (UTC) Received: by mail-yw1-f42.google.com with SMTP id z63so1337434ywz.9 for ; Mon, 19 Aug 2019 13:23:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=H3h2Ahh08Gpiy3zryrnOorQpk/lTxlCKVm0sS2JMuMI=; b=hwAPD4/aYjMJGuuTYujHFJcz6HiyhhO3lO52yfvUgB76ju0nDuEg7wDvBjzWObRWHG ee8pVwQW1gxAcaBGzHKaJLaAiz5iEodD/6VFXCJOv0cNfMNS6QlGpX4yogccXNQH6YpJ RVVsez9YEXSZKFasQy1LtLo4lPYvLXdL8yBABxc35NwegtcldB9Pz0PDEEdO5YjSbdbs rvkzb7C7+IlLBfj7NpyFIfwKiREHVmoucQ8tS3xNbtz66iqj4CKNt7Nk8cHGmvqZe+Er q397wJDQKz9QHpqb3gby3sCmZk8OUZrMdvXiFPtloCLOoLuE0HqxjRjBbTDqF1ttIoag aaxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=H3h2Ahh08Gpiy3zryrnOorQpk/lTxlCKVm0sS2JMuMI=; b=dh7tc3afX+pmpWVv4dsiuqsVybOFxvTmoV/it/TlDmVGLpJRKJuOdHxTy4aTzJvtB/ DFEKy4dm2Gm98/o8mquUoobK+WvMG/zv0zeXBT8fQlnt50ZDgPVjPd9zNr1QVlx76FrN eLaW/fnbyt+rl3hnMUFHs7F78OPzHdFRlNIMQzLXLjZCIMA1eXjhTCstc1Xxt/gAaJZg mvyyLDz2qNPNvICf9raqNYKA1dsEwFdlCGn5MdyN5LmxQSNRMI4cCvuUI0vSmijJVfhw 6ELdHKxCXUZIcuPnmT29/VXnmo1T8sk8ffRYvGMMLqsQmLTQfEE5LkGpWU5GfFGujP48 u0pw== X-Gm-Message-State: APjAAAWRfGInpecPinBFPbNuGGI/G9yw9r3KQk5aKB3E0ddYMuzkuqvA hn0uw9AIW/Y1zsLXbEliTlxN2AYtOmfz+Kl0NE+N7A== X-Google-Smtp-Source: APXvYqyvVZ0Qc4E2IeoEFm+II8ekflrg8K2AjsCbXEy8wCNtesfI+C8zCj6F08OqznzxzfcPWK9i/kpwbUxqDhbeNJo= X-Received: by 2002:a0d:d450:: with SMTP id w77mr17838474ywd.243.1566246225061; Mon, 19 Aug 2019 13:23:45 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Rahul Reddy Date: Mon, 19 Aug 2019 16:23:34 -0400 Message-ID: Subject: Re: New column To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary="000000000000e02bf405907e1df5" --000000000000e02bf405907e1df5 Content-Type: text/plain; charset="UTF-8" Jon, If we expect non of our partition key to have more than 100 records and pass partition key in where clause we wouldnt see issues using new column and allow filtering? Can you please point me to any doc how allow filtering works. I was in assumption of it goes through all the partitions On Sun, Aug 18, 2019, 4:33 PM Jon Haddad wrote: > If you're giving the partition key you won't scan the whole table. The > overhead will depend on the size or the partition. > > Would be an interesting workload for our tlp-stress tool, I'll code > something up for the next release. > > On Sun, Aug 18, 2019, 12:58 PM Rahul Reddy > wrote: > >> Hello, >> >> We have a table and want to add column and select based on existing >> entire primary key plus new column using allow filtering. Since my where >> clause has all the primary key + new column does the allow filtering scan >> only the partions which are listed or does it has to scan whole table? What >> is the best approach add new column and query it based on existing primary >> key plus new column? >> > --000000000000e02bf405907e1df5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Jon,

<= div dir=3D"auto">If we expect non of=C2=A0 our partition key to have more t= han 100 records and pass partition key in where clause we wouldnt see issue= s using new column and allow filtering?=C2=A0 Can you please point me to an= y doc how allow filtering works. I was in assumption of it goes through all= the partitions=C2=A0

On Sun, Aug 18, 2019, 4:33 PM Jon Haddad <jon@jonhaddad.com> wrote:
If you're giving the partition key you won't sca= n the whole table. The overhead will depend on the size or the partition.= =C2=A0

Would be an interesting= workload for our tlp-stress tool, I'll code something up for the next = release.=C2=A0

On Sun, Aug 18, 2019, 12:58 PM Rahul Reddy <rahulreddy1234@gmail.com> wrote:
Hello,

We have a table and want to add column and select base= d on existing entire primary key plus new column using allow filtering. Sin= ce my where clause has all the primary key + new column does the allow filt= ering scan only the partions which are listed or does it has to scan whole = table? What is the best approach add new column and query it based on exist= ing primary key plus new column?
--000000000000e02bf405907e1df5--