I've got a simple CF which stores the result of an expression, sort of a cache, which used a prefix and a MD5 hash as the row key. At times the cache must be invalidated, so I need to scan all rows which start with the prefix, for this I wanted to use a CQL query.
create column family LicenseXPath with comparator=UTF8Type and default_validation_class=UTF8Type and key_validation_class=UTF8Type;
If I do a "select KEY from LicenseXPath" I get the following keys:
All keys starting with "L0000001__" must be invalidated. So I intended to do a "select KEY from LicenseXPath where KEY >= 'L0000001__' and KEY < 'L0000001_a'", however this returns no keys. If I leave out the second condition, no rows. No matter what I do, as soon as there is a where condition I get no rows.
So I manually inserted the row key "L0000001__", and the select now does find that row. But only that row.
I'm doing something wrong. Got some wires twisted. Question is: what wires? What am I missing?