cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Häck (JIRA) <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-4390) Query with WHERE statement delivers wrong results
Date Thu, 28 Jun 2012 12:07:43 GMT

     [ 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.000000 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.000000 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
1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
>            Reporter: Stefan Häck
>         Attachments: Cassandra_Query_Issue.png
>
>
> 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.000000 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);

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message