Hello Anton,
You need to look into Datastax Entreprise (DSE) Offering. It integrates
Solr search which allows you to do searches like the one you mention. There
are also some opensource projects doing this kind of integration, so its up
to you.
And as Oded mentioned Cassandra really shines on key
"Cassandra is a highly scalable, eventually consistent, distributed, structured
key-value store" http://wiki.apache.org/cassandra/
It is intended for searching by key. It has more querying options but it really
shines when querying by key.
Not all databases offer the same functionality. Both a k