cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicolas Lalevée (JIRA) <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-8356) Slice query on super column camily with counters don't get all the data
Date Fri, 21 Nov 2014 14:10:33 GMT
Nicolas Lalevée created CASSANDRA-8356:
------------------------------------------

             Summary: Slice query on super column camily with counters don't get all the data
                 Key: CASSANDRA-8356
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
             Project: Cassandra
          Issue Type: Bug
            Reporter: Nicolas Lalevée


We've finally been able to upgrade our cluster to 2.0.11, after CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return all the expected
data. We first though because of all the trouble we had that we lost data, but there a way
to actually get the data, so nothing is lost; it just that cassandra seems to incorrectly
skip it.
See the following CQL log:
{noformat}
cqlsh:Theme> desc table theme_view;

CREATE TABLE theme_view (
  key bigint,
  column1 varint,
  column2 text,
  value counter,
  PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=1.000000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'SnappyCompressor'};

cqlsh:Theme> select * from theme_view where key = 99421 limit 10;

 key   | column1 | column2    | value
-------+---------+------------+-------
 99421 |     -12 | 2011-03-25 |    59
 99421 |     -12 | 2011-03-26 |     5
 99421 |     -12 | 2011-03-27 |     2
 99421 |     -12 | 2011-03-28 |    40
 99421 |     -12 | 2011-03-29 |    14
 99421 |     -12 | 2011-03-30 |    17
 99421 |     -12 | 2011-03-31 |     5
 99421 |     -12 | 2011-04-01 |    37
 99421 |     -12 | 2011-04-02 |     7
 99421 |     -12 | 2011-04-03 |     4

(10 rows)

cqlsh:Theme> select * from theme_view where key = 99421 and column1 = -12 limit 10;

 key   | column1 | column2    | value
-------+---------+------------+-------
 99421 |     -12 | 2011-03-25 |    59
 99421 |     -12 | 2014-05-06 |    15
 99421 |     -12 | 2014-06-06 |     7
 99421 |     -12 | 2014-06-10 |    22
 99421 |     -12 | 2014-06-11 |    34
 99421 |     -12 | 2014-06-12 |    35
 99421 |     -12 | 2014-06-13 |    26
 99421 |     -12 | 2014-06-14 |    16
 99421 |     -12 | 2014-06-15 |    24
 99421 |     -12 | 2014-06-16 |    25

(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not. Via thrift, we
have the exact same bug.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message