cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (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:57:39 GMT

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

Brandon Williams commented on CASSANDRA-7636:
---------------------------------------------

Doesn't repro for me against 2.1.0-HEAD:

{noformat}
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;

(0 rows)

cqlsh:test_keyspace>
{noformat}

Not sure what fixed it, though.

> 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
>
> My pretty simplified case looks like the following:
> I create a table with partition and cluster column. I set key caching to NONE and row
caching to ALL.  
> When I'm running some SELECTs with WHERE clause filtering on cluster columns, the rows
sometimes are not getting filtered out. When? When the row gets loaded to row cache (By some
previous query).
> Look at this scenario: 
> {code}
> cqlsh:xxx> create KEYSPACE test_keyspace WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1};
> cqlsh:xxx> 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)
> {code}
> 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