cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krzysztof Zarzycki (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-7636) Data is not filtered out when using WHERE clause on cluster column on Column Family with row cache on.
Date Wed, 30 Jul 2014 22:43:40 GMT

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

Krzysztof Zarzycki updated CASSANDRA-7636:
------------------------------------------

    Summary: Data is not filtered out when using WHERE clause on cluster column on Column
Family with row cache on.  (was: Data is not filtered out when using WHERE clause on cluster
column)

> Data is not filtered out when using WHERE clause on cluster column on Column Family with
row cache on.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-7636
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7636
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra 2.1.0-rc4
>            Reporter: Krzysztof Zarzycki
>
> I have a table on which I'm running some SELECTs with WHERE clause filtering on cluster
columns, but the rows are not getting filtered out. 
> Look: 
> cqlsh:leadbullet> create KEYSPACE test_keyspace WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1};
> cqlsh:leadbullet> use test_keyspace ;
> cqlsh:test_keyspace> CREATE TABLE test (     p1 bigint,   c1 int,      PRIMARY KEY
(p1, c1) )  WITH caching = '{"keys":"NONE", "rows_per_partition":"ALL"}';
> cqlsh:test_keyspace> insert into test (p1, c1 ) values ( 123, 10);
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
> (0 rows)
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 9;
>  p1  | c1
> -----+----
>  123 | 10
> (1 rows)
> cqlsh:test_keyspace> select * from test where p1 = 123 and c1 > 10;
>  p1  | c1
> -----+----
>  123 | 10
> (1 rows)
> The filtering on other (partition) columns runs fine. Only the clustering column is somewhat
malfunctioning. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message