[
https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stefan Häck updated CASSANDRA-4390:
---
Description:
Data is written to cassandra via phpcassa ( https://github.com/thobbs/phpcassa
v1.0).
Inspection the records via cqlsh,the query with a WHERE statement doesn't
deliver all records.
https://issues.apache.org/jira/secure/attachment/12533818/Cassandra_Query_Issue.png
I'am working with a 2 node cluster and the effect is the same on both nodes.
Furthermore a nodetool repair, nodetool rebuild has no positive effect. The
data type for this column is varint.
**
DESCRIBE COLUMNFAMILY rm_advertisements
CREATE TABLE rm_advertisements (
KEY text PRIMARY KEY,
css text,
form text,
custom_field2 text,
vacancy_type text,
custom_field3 text,
active boolean,
vacancy_responsibles text,
job_site text,
vacancy_email_notification text,
custom_field4 text,
vacancy_name text,
startdate text,
vacancy_id varint,
custom_field5 text,
html text,
company_id varint,
ctime text,
title text,
expires text,
atime text,
custom_field1 text,
vacancy_language text,
tags text,
mtime text,
mailapply boolean,
vacancy_description text,
vacancy_function text,
shorthash text
) WITH
comment='Advertisements' AND
comparator=text AND
read_repair_chance=1.00 AND
gc_grace_seconds=864000 AND
default_validation=text AND
min_compaction_threshold=4 AND
max_compaction_threshold=32 AND
replicate_on_write='true' AND
compaction_strategy_class='SizeTieredCompactionStrategy' AND
compression_parameters:sstable_compression='SnappyCompressor';
CREATE INDEX rm_advertisements_active ON rm_advertisements (active);
CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site);
CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id);
CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id);
CREATE INDEX rm_advertisements_title ON rm_advertisements (title);
CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires);
CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements
(vacancy_language);
CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply);
CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash);
was:
Data is written to cassandra via phpcassa ( https://github.com/thobbs/phpcassa
v1.0).
Inspection the records via cqlsh,the query with a WHERE statement doesn't
deliver all records.
http://imageshack.us/photo/my-images/820/cassandraqueryissue.png/
I'am working with a 2 node cluster and the effect is the same on both nodes.
Furthermore a nodetool repair, nodetool rebuild has no positive effect. The
data type for this column is varint.
**
DESCRIBE COLUMNFAMILY rm_advertisements
CREATE TABLE rm_advertisements (
KEY text PRIMARY KEY,
css text,
form text,
custom_field2 text,
vacancy_type text,
custom_field3 text,
active boolean,
vacancy_responsibles text,
job_site text,
vacancy_email_notification text,
custom_field4 text,
vacancy_name text,
startdate text,
vacancy_id varint,
custom_field5 text,
html text,
company_id varint,
ctime text,
title text,
expires text,
atime text,
custom_field1 text,
vacancy_language text,
tags text,
mtime text,
mailapply boolean,
vacancy_description text,
vacancy_function text,
shorthash text
) WITH
comment='Advertisements' AND
comparator=text AND
read_repair_chance=1.00 AND
gc_grace_seconds=864000 AND
default_validation=text AND
min_compaction_threshold=4 AND
max_compaction_threshold=32 AND
replicate_on_write='true' AND
compaction_strategy_class='SizeTieredCompactionStrategy' AND
compression_parameters:sstable_compression='SnappyCompressor';
CREATE INDEX rm_advertisements_active ON rm_advertisements (active);
CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site);
CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id);
CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id);
CREATE INDEX rm_advertisements_title ON rm_advertisements (title);
CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires);
CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements
(vacancy_language);
CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply);
CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash);
> Query with WHERE statement delivers wrong results
> -
>
> Key: CASSANDRA-4390
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4390
> Project: Cassandra
> Issue Type: Bug
>Affects Versions: 1.1.1
> Environment: Linux version 2.6.32-5-amd64 (Debian 2.6.32-45) |cqlsh
> 2.2.0 | Cassandra