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 queries. Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo <http://linkedin.com/in/carlosjuzarterolo>* Mobile: +31 6 159 61 814 | Tel: +1 613 565 8696 x1649 www.pythian.com On Wed, Jul 22, 2015 at 7:39 AM, Peer, Oded <oded.p...@rsa.com> wrote: > "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 knife and a fork > are eating utensils, but you wouldn't want to cut a tomato with a fork. > There are text-indexing databases out there that might suit your needs > better. Try elasticsearch. > > -----Original Message----- > From: anton [mailto:anto...@gmx.de] > Sent: Tuesday, July 21, 2015 7:54 PM > To: user@cassandra.apache.org > Subject: howto do sql query like in a relational database > > Hi, > > I have a simple (perhaps stupid) question. > > If I want to *search* data in cassandra, how could find in a text field > all records which start with 'Cas' > ( in sql I do select * from table where field like 'Cas%') > > I know that this is not directly possible. > > - But how is it possible? > > - Do nobody have the need to search text fragments, > and if not is there a small example to explain > *why* this is not needed? > > As far as I understand, databases are great for *searching* data. > Concerning numerical data in cassandra I can use < > = all that operators. > > Is cassandra intended to be used for mostly numerical data? > > I did not catch the point up to now, sorry. > > Anton > > > -- --
