Frens Jan Rumph created CASSANDRA-8940:
------------------------------------------
Summary: 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
Reporter: Frens Jan Rumph
Fix For: 2.1.2
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)
