[jira] [Commented] (CASSANDRA-7079) allow filtering within wide row

["Ashot Golovenko (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-7079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14038767#comment-14038767 ] 

Ashot Golovenko commented on CASSANDRA-7079:
--------------------------------------------

Any comments?

> allow filtering within wide row
> -------------------------------
>
>                 Key: CASSANDRA-7079
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7079
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Ashot Golovenko
>
> 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)