[
https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146838#comment-16146838
]
Benjamin Lerer commented on CASSANDRA-13817:
--------------------------------------------
C* organize your data per partitions (in your case by the {{id}} columns) and
then within those partitions per rows (in your case by the {{name}} column).
Your query is going through all the partitions and searching for a specific row
within each of them.
How many different {{id}} values do you have? And for a given {{id}} value how
many {{name}} values do you have (in average)?
It would also be great if you could tell me how many {{name}} values you have
for the {{id}} associated to {{name = 'myName'}}.
> cassandra allow filtering bug
> -----------------------------
>
> Key: CASSANDRA-13817
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13817
> Project: Cassandra
> Issue Type: Bug
> Components: CQL, Libraries
> Reporter: wang huatao
> Assignee: Benjamin Lerer
> Labels: allow-filtering
> Fix For: 3.10
>
>
> I have one bug about cassandra cql, when I use select * from table where
> name = 'myName' alllow filtering, sometimes can be found, but sometimes can
> not found. I am very sure the row data existed. my data was very small, just
> 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
