Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Thu, 5 May 2016 13:16:12 +0000 (UTC)
From: "ZhaoYang (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12932317.1453183027000.117925.1462454172958@Atlassian.JIRA>
In-Reply-To: <JIRA.12932317.1453183027000@Atlassian.JIRA>
References: <JIRA.12932317.1453183027000@Atlassian.JIRA> <JIRA.12932317.1453183027429@arcas>
Subject: =?utf-8?Q?[jira]_[Updated]_(CASSANDRA-11031)_MultiTenant_:_?=
 =?utf-8?Q?support_=E2=80=9CALLOW_FILTERING"_for_First_Partition_Key?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Thu, 05 May 2016 13:16:14 -0000


     [ https://issues.apache.org/jira/browse/CASSANDRA-11031?page=3Dcom.atl=
assian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ZhaoYang updated CASSANDRA-11031:
---------------------------------
    Attachment:     (was: CASSANDRA-11031-3.7)

> MultiTenant : support =E2=80=9CALLOW FILTERING" for First Partition Key
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-11031
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-1103=
1
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: CQL
>            Reporter: ZhaoYang
>            Assignee: ZhaoYang
>            Priority: Minor
>             Fix For: 3.x
>
>         Attachments: CASSANDRA-11031-3.7.patch
>
>
> Currently, Allow Filtering only works for secondary Index column or clust=
ering columns. And it's slow, because Cassandra will read all data from SST=
ABLE from hard-disk to memory to filter.
> But we can support allow filtering on Partition Key, as far as I know, Pa=
rtition Key is in memory, so we can easily filter them, and then read requi=
red data from SSTable.
> This will similar to "Select * from table" which scan through entire clus=
ter.
> CREATE TABLE multi_tenant_table (
> =09tenant_id text,
> =09pk2 text,
> =09c1 text,
> =09c2 text,
> =09v1 text,
> =09v2 text,
> =09PRIMARY KEY ((tenant_id,pk2),c1,c2)
> ) ;
> Select * from multi_tenant_table where tenant_id =3D "datastax" allow fil=
tering;


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)