cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (CASSANDRA-7079) allow filtering within wide row
Date Tue, 01 Jul 2014 03:58:25 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-7079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jonathan Ellis reassigned CASSANDRA-7079:
-----------------------------------------

    Assignee: Sylvain Lebresne

> 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)

Mime
View raw message