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 E4DFA200BAF for ; Mon, 31 Oct 2016 14:34:05 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id E3728160B05; Mon, 31 Oct 2016 13:34:05 +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 35FAC160AF0 for ; Mon, 31 Oct 2016 14:34:05 +0100 (CET) Received: (qmail 23507 invoked by uid 500); 31 Oct 2016 13:34:03 -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 23497 invoked by uid 99); 31 Oct 2016 13:34:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Oct 2016 13:34:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A4FD7C0C0D for ; Mon, 31 Oct 2016 13:34:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 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_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-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 (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 2P_biNvMWcPS for ; Mon, 31 Oct 2016 13:33:58 +0000 (UTC) Received: from mail-vk0-f51.google.com (mail-vk0-f51.google.com [209.85.213.51]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 8A1875FC80 for ; Mon, 31 Oct 2016 13:33:58 +0000 (UTC) Received: by mail-vk0-f51.google.com with SMTP id p9so2520856vkd.3 for ; Mon, 31 Oct 2016 06:33:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=3iOlCk4OXfHBDP3z5GqF0d3JO6g4wcZZn+nld+IoCxI=; b=Hhq/Zfp4Aqj5R/Qmntwr850cYqEfCAefUKsnX+OVe8nCHl4yj0uNlWUAHIVyT9IMXG rPgfk3dJFCbXNciiUbA2//sbhHYJkNGv5Rxw+IL0csYJH/Bf9yw0eC/8I0ISD/t3i4sW g9orgNrsu8WAHfo/TpivivZ6iJ2iczgDGiAx/O0V/pXNgS8CNfr55k0QldKWc56pRHeA eGu9rcsM5LqhsZNuJ+TmKSMafVVDUfZnzh4b6S/TLpwcp9ADQu8bA4t5nk+RYrPzaPcQ 525gZYsxTj33EkGS8v/G5/+CMCzxPozcZOXb81YfVnpd5dlWcbQKiw9r1Eh+bo+Oj4aM tPsg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=3iOlCk4OXfHBDP3z5GqF0d3JO6g4wcZZn+nld+IoCxI=; b=GPJMOMXrlRtzzP07boijeZcAZOC1m4Iym3Xk4IZ0AyT5/DPxkgI8SeAU6IyumIhIB5 QmydeRcqxzJ7qqbI445R8WucllfY588NOSkqTkK3ZwjOAamvISOd7yw/JOZu1yICcuLx 7UoJUsoxiyYxhgv43hYs8TQRyk79JlNvqDm6xAUZn2fO0P8/iNAKzK6BBozHLaZfpMO1 Tvbp+2NQsRnUlvR28crF31a/3dfZeM9W236BYJ9sRocC9DKpKSq+90TqkYm0lLttaSlI PCDvSj1Y5ZvsUyVSWEwioKExVjv0pqr5g4gcKLopUpl3YXPD6d1DrvbK3Xmko6QOW/2x e8ow== X-Gm-Message-State: ABUngvcKTmo11jqJ4+bK/qlWOJqh21llOwhOPBJ/t5one5sP9b1avvuxwJb51oMOkZ8NR7/LY09MUXw1ZL12uQ== X-Received: by 10.31.108.70 with SMTP id h67mr22706428vkc.163.1477920837950; Mon, 31 Oct 2016 06:33:57 -0700 (PDT) MIME-Version: 1.0 Received: by 10.103.73.20 with HTTP; Mon, 31 Oct 2016 06:33:37 -0700 (PDT) In-Reply-To: References: From: DuyHai Doan Date: Mon, 31 Oct 2016 14:33:37 +0100 Message-ID: Subject: Re: Secondary Index on Boolean column with TTL To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a11478d148d67c80540294237 archived-at: Mon, 31 Oct 2016 13:34:06 -0000 --001a11478d148d67c80540294237 Content-Type: text/plain; charset=UTF-8 http://www.planetcassandra.org/blog/cassandra-native-secondary-index-deep-dive/ See section E Caveats which applies to your boolean use-case On Mon, Oct 31, 2016 at 2:19 PM, Oleg Krayushkin wrote: > Hi, > > Is it a good approach to make a boolean column with TTL and build a > secondary index on it? > (For example, I want to get rows which need to be updated after a certain > time, but I don't want, say, to add a filed "update_date" as clustering > column or to create another table) > > In what kind of trouble it could lead me? > > Thanks in advance for any suggestions. > > -- > > Oleg Krayushkin > --001a11478d148d67c80540294237 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
http://www.planetcassandra.org/blog/cassa= ndra-native-secondary-index-deep-dive/

See secti= on E Caveats which applies to your boolean use-case

On Mon, Oct 31, 2016 at 2:1= 9 PM, Oleg Krayushkin <allight.me@gmail.com> wrote:
Hi,

I= s it a good approach to make a boolean column with TTL and build a secondar= y index on it?=C2=A0
(For example, I want to get rows which need = to be updated after a certain time, but I don't want, say, to add a fil= ed "update_date" as clustering column or to create another table)=

In what kind of trouble it could lead me?

Thanks in advance for any suggestions.

--

Oleg Krayushkin

--001a11478d148d67c80540294237--