cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Petrov (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-11031) MultiTenant : support “ALLOW FILTERING" for Partition Key
Date Fri, 19 Aug 2016 16:17:21 GMT


Alex Petrov commented on CASSANDRA-11031:

[~jasonstack] I've fixed most of problems with dtests by now. Unit tests look good. However,
ordering was not correct in limit tests,{{PER PARTITION LIMIT}} tests and test with {{ORDER
BY}} clause were absent. Could you please add those?

Please, use {{assert_all}} with {{ignore_order}} if results return more than one partition
as their order is not guaranteed. {{LIMIT}} tests are quite tricky. The easiest would probably
be to make sure you know which partition you're going to be getting back first, this way order
will be consistent. Otherwise you have to compare with contents of all possible partitions.

> MultiTenant : support “ALLOW FILTERING" for Partition Key
> ---------------------------------------------------------
>                 Key: CASSANDRA-11031
>                 URL:
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: CQL
>            Reporter: ZhaoYang
>            Assignee: ZhaoYang
>            Priority: Minor
>             Fix For: 3.x
> Currently, Allow Filtering only works for secondary Index column or clustering columns.
And it's slow, because Cassandra will read all data from SSTABLE from hard-disk to memory
to filter.
> But we can support allow filtering on Partition Key, as far as I know, Partition Key
is in memory, so we can easily filter them, and then read required data from SSTable.
> This will similar to "Select * from table" which scan through entire cluster.
> CREATE TABLE multi_tenant_table (
> 	tenant_id text,
> 	pk2 text,
> 	c1 text,
> 	c2 text,
> 	v1 text,
> 	v2 text,
> 	PRIMARY KEY ((tenant_id,pk2),c1,c2)
> ) ;
> Select * from multi_tenant_table where tenant_id = "datastax" allow filtering;

This message was sent by Atlassian JIRA

View raw message