howto do sql query like in a relational database

[anton <an...@gmx.de>]

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

[Carlos Rolo <ro...@pythian.com>]

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 <Od...@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:antonxx@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
>
>
>

-- 


--

RE: howto do sql query like in a relational database

["Peer, Oded" <Od...@rsa.com>]

"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:antonxx@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