Re: howto do sql query like in a relational database
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 -- --
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
RE: howto do sql query like in a relational database
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