Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id D61BD200CBC for ; Tue, 20 Jun 2017 09:29:44 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id D3915160BE1; Tue, 20 Jun 2017 07:29:44 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id F2FFB160BD3 for ; Tue, 20 Jun 2017 09:29:43 +0200 (CEST) Received: (qmail 37262 invoked by uid 500); 20 Jun 2017 07:29:42 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 37252 invoked by uid 99); 20 Jun 2017 07:29:42 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Jun 2017 07:29:42 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id CA7D6CA9D7 for ; Tue, 20 Jun 2017 07:29:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.9 X-Spam-Level: X-Spam-Status: No, score=0.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-1, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id nTSAr3XMVRzC for ; Tue, 20 Jun 2017 07:29:41 +0000 (UTC) Received: from mail-wr0-f171.google.com (mail-wr0-f171.google.com [209.85.128.171]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 8F1345F6C1 for ; Tue, 20 Jun 2017 07:29:40 +0000 (UTC) Received: by mail-wr0-f171.google.com with SMTP id 77so86431457wrb.1 for ; Tue, 20 Jun 2017 00:29:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=OkusNK6uST/OVo/oe9LTyJ1uoc5xoiUZB0AAk2lETJ0=; b=ZBEU5p0K8TprALrttAdEc91PsfvpcmCvKFT9B0/ksvEWVPzDJZf3wwQiCGOi4F8QYJ AP6gtAleLeIXDAKZUTtbMEUPtLRO5jYpSpyFyzbR8UlKOkfqdo0ObVWbgwvztl5/gzHC Bg7gknMP+PaTDELtA2ZV/pScQ3dbTmqr762JDVnXzPQksUwdATB2NSXouJukDDu9mbCU LOk/XxYFaCT/GXYYrq47lqjlNtKsXAOOUB2L4J/xobRVbduLLWXkNau5SrwLo2D83Hmw b+YZzBwCDuahgYYhgoVeKK4dCVy2gYxq2eAxPuUzs4h0Uu9s4iwBnePndyBDZ+c0P/6W Sl4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=OkusNK6uST/OVo/oe9LTyJ1uoc5xoiUZB0AAk2lETJ0=; b=bcxBUQkmx8fuT68o3KEEsEgJHDwg0WoYsBZ6tt/PNd5AlQ5cF6IxXAZJvckVcLT+5f I/NV/HObUvkoKKSNN3AtG1dWQxrUD5D16eWwWCJ5I4zfH/+Bsgp1PkW9FgDgrQCAsihD O+FJV2XrBcNq7BTibFe+l49BuWwowdMY0IKY7jBCjtIDydnOtLVMW0jP2gj4+bFJhwoV pX835vlXxTgmKqMg4+VlYrHUkrftuv1h5qf2Uhby0L+I3+orgVUNDphmSuG5N7LZx4uW IAM7Akcq8KoP9WiVHzvsvd/f36RA66aQ4Zf5wVL+EBAkupe7HafW5EgFCGOQJmel6Nv2 ACFQ== X-Gm-Message-State: AKS2vOycu7USsp9xQ6Kt/Tw2IeTPaqwDZGs9kNncwwiOo3YU1IRFIypO 3f8+1RQxMz2gUyslD7/4GUpPaMupAw== X-Received: by 10.223.136.11 with SMTP id d11mr17572325wrd.73.1497943779574; Tue, 20 Jun 2017 00:29:39 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.162.153 with HTTP; Tue, 20 Jun 2017 00:29:39 -0700 (PDT) In-Reply-To: <053247A8CBB6754B8345743B8F18D68D308B5845@MOSTLS1MSGUSRFA.ITServices.sbc.com> References: <053247A8CBB6754B8345743B8F18D68D308B5845@MOSTLS1MSGUSRFA.ITServices.sbc.com> From: "techpyaasa ." Date: Tue, 20 Jun 2017 12:59:39 +0530 Message-ID: Subject: Re: Secondary Index To: "ZAIDI, ASAD A" Cc: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary="001a11461288e009d505525f36cb" archived-at: Tue, 20 Jun 2017 07:29:45 -0000 --001a11461288e009d505525f36cb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi ZAIDI, Thanks for reply. Sorry I didn't get your line "You can get away the potential situation by leveraging composite key, if that is possible for you?" How can I get through it?? Like I have a table as below CREATE TABLE ks1.cf1 (id1 bigint, id2 bigint, resp text, status int, PRIMARY KEY (id1, id2) ) WITH CLUSTERING ORDER BY (id2 ASC) 'status' will have values of 0/1/2/3/4 (4 possible values) , insertions to table(partition) will happen based on id2 i.e values(id1,id2,resp,status) I want to have a filtering/criteria applied on 'status' column too like select * from ks1.cf1 where id1=3D123 and status=3D0; How can I achieve this w/o secondary index (on 'status' column )?? On Tue, Jun 20, 2017 at 12:09 AM, ZAIDI, ASAD A wrote: > If you=E2=80=99re only creating index so that your query work, think agai= n! > You=E2=80=99ll be storing secondary index on each node , queries involvin= g index > could create issues (slowness!!) down the road the when index on multiple > node Is involved and not maintained! Tables involving a lot of > inserts/delete could easily ruin index performance. > > > > You can get away the potential situation by leveraging composite key, if > that is possible for you? > > > > > > *From:* techpyaasa . [mailto:techpyaasa@gmail.com] > *Sent:* Monday, June 19, 2017 1:01 PM > *To:* user@cassandra.apache.org > *Subject:* Secondary Index > > > > Hi, > > I want to create Index on already existing table which has more than 3 > GB/node. > We are using c*-2.1.17 with 2 DCs , each DC with 3 groups and each group > has 7 nodes.(Total 42 nodes in cluster) > > So is it ok to create Index on this table now or will it have any problem= ? > If its ok , how much time it would take for this process? > > > Thanks in advance, > TechPyaasa > --001a11461288e009d505525f36cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi ZAIDI,

Thanks for reply.
Sorry I didn't get your line
"You can get away the pot= ential situation by leveraging composite key, if that is possible for you?&= quot;

How can I get through = it??

Like I have a table as below
CREATE TABLE ks1.cf1 = (id1 bigint, id2 bigint, resp text, status int, PRIMARY KEY (id1, id2)
) WITH CLUSTERING ORDER BY (id2 ASC)
=

'status' will have values of 0/= 1/2/3/4 (4 possible values) , insertions to table(partition) will happen ba= sed on id2 i.e values(id1,id2,resp,status)

I want to have a filterin= g/criteria applied on 'status' column too like
select * from=C2= =A0ks1.cf1 where id1=3D123 and status=3D0;

How can I achieve this w/= o secondary index (on 'status' column )??


On Tue, Jun 20, 2017 at= 12:09 AM, ZAIDI, ASAD A <az192g@att.com> wrote:

If you=E2=80=99re only creating index= so that your query work, think again!=C2=A0 You=E2=80=99ll be storing seco= ndary index on each node , queries involving index could create issues (slowness!!) down the road the when index on multiple node Is involved and= =C2=A0not maintained!=C2=A0 Tables involving a lot of inserts/delete could= easily ruin index performance.

=C2=A0

You can get away the potential situat= ion by leveraging composite key, if that is possible for you?=

=C2=A0

=C2=A0

From: techpyaasa . [mailto:techpyaasa@gmail.com= ]
Sent: Monday, June 19, 2017 1:01 PM
To: u= ser@cassandra.apache.org
Subject: Secondary Index

=C2=A0

Hi,

I want to create Index on already existing table which has more than 3 GB/n= ode.
We are using c*-2.1.17 with 2 DCs , each DC with 3 groups and each group ha= s 7 nodes.(Total 42 nodes in cluster)

So is it ok to create Index on this table now or will it have any problem?<= br> If its ok , how much time it would take for this process?


Thanks in advance,
TechPyaasa


--001a11461288e009d505525f36cb--