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)