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

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

Ashot Golovenko created CASSANDRA-7079:
------------------------------------------

             Summary: allow filtering within wide row
                 Key: CASSANDRA-7079
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7079
             Project: Cassandra
          Issue Type: Wish
          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 cant 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)