cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carlos Alonso <i...@mrcalonso.com>
Subject Re: No query results while expecting results
Date Mon, 23 Nov 2015 10:10:26 GMT
Ok, so by default the CONSISTENCY LEVEL of CQLSH is ONE.

Therefore it could be that the node you're connected to doesn't actually
contain any of this data.

Try improving the CL for that read and see what happens.

Regards.

Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>

On 23 November 2015 at 09:31, Ramon Rockx <ramon@iqnomy.com> wrote:

> Hello,
>
> On our Cassandra 1.2.15 test cluster I'm stuck with querying data on one
> of our Cassandra tables.
> This is the table:
>
>
> cqlsh> describe table mls.te;
>
> CREATE TABLE te (
>   period bigint,
>   tnt_id varint,
>   evt_id timeuuid,
>   evt_type varint,
>   data text,
>   PRIMARY KEY ((period, tnt_id), evt_id, evt_type)
> ) WITH COMPACT STORAGE AND
>   CLUSTERING ORDER BY (evt_id DESC, evt_type ASC) AND
>   bloom_filter_fp_chance=0.010000 AND
>   caching='KEYS_ONLY' AND
>   comment='tenantevent' AND
>   dclocal_read_repair_chance=0.000000 AND
>   gc_grace_seconds=864000 AND
>   read_repair_chance=0.100000 AND
>   replicate_on_write='true' AND
>   populate_io_cache_on_flush='false' AND
>   compaction={'class': 'SizeTieredCompactionStrategy'} AND
>   compression={'sstable_compression': 'SnappyCompressor'};
>
> Notice that the partition key is a composite one.
> Now I will simply do a select all on this table with a limit:
>
> cqlsh> select * from mls.te limit 330;
>
>  period      | tnt_id     | evt_id                               |
> evt_type | data
>
> -------------+------------+--------------------------------------+----------+-------------------------------------------------------------------------------------------------
> ...
>  62013120356 |          5 | 3f33f950-5c1b-11e3-bf53-402d20524153 |
> 0 | {"v":1383387,"s":2052457,"r":95257,"pvs":3610245,"u":"
> http://www.example.com"}
>  62013120356 |          5 | ec15e5d0-5c1a-11e3-bf53-402d20524153 |
> 0 | {"v":1383387,"s":2052457,"r":95257,"pvs":3610243,"u":"
> http://www.example.com"}
>  62015032164 | 2063819251 | 63d5c920-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451223,"s":2130306,"r":104667,"u":"http://www.example.com"}
>  62015032164 | 2063819251 | 111ce010-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451222,"s":2130305,"r":104769,"u":"http://www.example.com"}
>  62015032164 | 2063819251 | 105e7210-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451221,"s":2130304,"r":104769,"u":"http://www.example.com"}
>  62015061055 | 2147429759 | 35b97470-0f68-11e5-8cc3-000c2981ebb4 |
> 1 |
> {"v":1453821,"s":2134354,"r":105462,"q":"13082ede-0843-47ee-8126-ba3767eae547"}
>  62015061055 | 2147429759 | 35a0bc50-0f68-11e5-8cc3-000c2981ebb4 |
> 0 | {"v":1453821,"s":2134354,"r":105462,"u":"http://www.example.com"}
>
> So far so good... Now I will try to query a few of these by using the
> composite partition key (period, tnt_id):
>
> cqlsh> select * from mls.te where period=62013120356 and tnt_id=5;
> cqlsh> select * from mls.te where period=62015032164 and tnt_id=2063819251
> ;
>
>  period      | tnt_id     | evt_id                               |
> evt_type | data
>
> -------------+------------+--------------------------------------+----------+-------------------------------------------------------------------------------------------------
>  62015032164 | 2063819251 | 63d5c920-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451223,"s":2130306,"r":104667,"u":"http://www.example.com"}
>  62015032164 | 2063819251 | 111ce010-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451222,"s":2130305,"r":104769,"u":"http://www.example.com"}
>  62015032164 | 2063819251 | 105e7210-cfdb-11e4-85e9-000c2981ebb4 |
> 0 | {"v":1451221,"s":2130304,"r":104769,"u":"http://www.example.com"}
>
> As you can see, the last query returned the results as expected (see also
> the 'select all' query). However the query "select * from mls.te where
> period=62013120356 and tnt_id=5;" does not return anything, I did expect
> results, since there are results based on this where clause.
>
> Does anybody know what is going on, or what am I doing wrong?
>
> Thanks!
>
> Ramon Rockx
>

Mime
View raw message