You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2014/08/22 17:16:11 UTC
[jira] [Resolved] (CASSANDRA-7079) allow filtering within wide row
[ https://issues.apache.org/jira/browse/CASSANDRA-7079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne resolved CASSANDRA-7079.
-----------------------------------------
Resolution: Duplicate
Reproduced In: 2.0.9, 2.0.8, 2.0.7 (was: 2.0.7, 2.0.8, 2.0.9)
> allow filtering within wide row
> -------------------------------
>
> Key: CASSANDRA-7079
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7079
> Project: Cassandra
> Issue Type: Bug
> Components: API, Core
> Reporter: Ashot Golovenko
> Assignee: Sylvain Lebresne
>
> Let's say I have a table with wide rows.
> CREATE TABLE relation (
> u1 bigint,
> u2 bigint,
> f boolean,
> PRIMARY KEY (u1, u2));
> Usually I need to retrieve the whole row:
> select * from relation where u1 = ?;
> But sometimes I just need the relations within u1 with f = true.
> By now I can't perform the following without creating an index which will degrade write performance:
> select * from relation where u1 = ? and f=true allow filtering;
> So now I filter rows on server side which means more network traffic and I don't know how much more server resources. Filtering rows in this case on a server side looks like nothing hard.
--
This message was sent by Atlassian JIRA
(v6.2#6252)