[ https://issues.apache.org/jira/browse/CASSANDRA-8940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14537524#comment-14537524 ]
Frens Jan Rumph commented on CASSANDRA-8940: -------------------------------------------- [~blerer], great that you found this out and resolved the matter! > Inconsistent select count and select distinct > --------------------------------------------- > > Key: CASSANDRA-8940 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8940 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: 2.1.2 > Reporter: Frens Jan Rumph > Assignee: Benjamin Lerer > Fix For: 2.0.15 > > Attachments: 7b74fb00-e935-11e4-b10c-317579db7eb4.csv, 8940.txt, > 8d5899d0-e935-11e4-847b-2d06da75a6cd.csv, Vagrantfile, install_cassandra.sh, > setup_hosts.sh > > > When performing {{select count( * ) from ...}} I expect the results to be > consistent over multiple query executions if the table at hand is not written > to / deleted from in the mean time. However, in my set-up it is not. The > counts returned vary considerable (several percent). The same holds for > {{select distinct partition-key-columns from ...}}. > I have a table in a keyspace with replication_factor = 1 which is something > like: > {code} > CREATE TABLE tbl ( > id frozen<id_type>, > bucket bigint, > offset int, > value double, > PRIMARY KEY ((id, bucket), offset) > ) > {code} > The frozen udt is: > {code} > CREATE TYPE id_type ( > tags map<text, text> > ); > {code} > The table contains around 35k rows (I'm not trying to be funny here ...). The > consistency level for the queries was ONE. -- This message was sent by Atlassian JIRA (v6.3.4#6332)