You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by karim abbouh <ka...@yahoo.fr> on 2011/05/19 18:11:10 UTC

selecting data

i'm new using cassandra database,
i want to get data as in relationnel database:
select * from table where field="value";
i see using CLI we have just the followings commands :
get <ksp>.<cf>['<key>']                                  Get a slice of columns.
get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub columns.
get <ksp>.<cf>['<key>']['<col>']                             Get a column value.
get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column value.

is there a way for that.
i think using java API is possible.
cassandra version : 6.0.12


thanks for help

Re: Re : selecting data

Posted by Sasha Dolgy <sd...@gmail.com>.
http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes

On Thu, May 19, 2011 at 7:10 PM, karim abbouh <ka...@yahoo.fr> wrote:
> for example in 0.7 how we use index ?

Re : selecting data

Posted by karim abbouh <ka...@yahoo.fr>.
for example in 0.7 how we use index ?




________________________________
De : Jonathan Ellis <jb...@gmail.com>
À : user@cassandra.apache.org
Envoyé le : Jeu 19 mai 2011, 18h 04min 48s
Objet : Re: selecting data

only 0.7+ has index support

On Thu, May 19, 2011 at 11:38 AM, Watanabe Maki <wa...@gmail.com> wrote:
> Cassandra is not a RDBMS. Only you can do is search on a key, or you need
> full scan.
> You need to design your schema carefully as your application needs.
>
>
> On 2011/05/20, at 1:11, karim abbouh <ka...@yahoo.fr> wrote:
>
> i'm new using cassandra database,
> i want to get data as in relationnel database:
> select * from table where field="value";
> i see using CLI we have just the followings commands :
> get <ksp>.<cf>['<key>']                                  Get a slice of
> columns.
> get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub
> columns.
> get <ksp>.<cf>['<key>']['<col>']                             Get a column
> value.
> get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column
> value.
>
> is there a way for that.
> i think using java API is possible.
> cassandra version : 6.0.12
>
>
> thanks for help
>
>
>
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com

Re: selecting data

Posted by Jonathan Ellis <jb...@gmail.com>.
only 0.7+ has index support

On Thu, May 19, 2011 at 11:38 AM, Watanabe Maki <wa...@gmail.com> wrote:
> Cassandra is not a RDBMS. Only you can do is search on a key, or you need
> full scan.
> You need to design your schema carefully as your application needs.
>
>
> On 2011/05/20, at 1:11, karim abbouh <ka...@yahoo.fr> wrote:
>
> i'm new using cassandra database,
> i want to get data as in relationnel database:
> select * from table where field="value";
> i see using CLI we have just the followings commands :
> get <ksp>.<cf>['<key>']                                  Get a slice of
> columns.
> get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub
> columns.
> get <ksp>.<cf>['<key>']['<col>']                             Get a column
> value.
> get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column
> value.
>
> is there a way for that.
> i think using java API is possible.
> cassandra version : 6.0.12
>
>
> thanks for help
>
>
>
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com

Re : selecting data

Posted by karim abbouh <ka...@yahoo.fr>.
is there a way to set  for a column of the same key a set of value ?




________________________________
De : Watanabe Maki <wa...@gmail.com>
À : "user@cassandra.apache.org" <us...@cassandra.apache.org>
Envoyé le : Jeu 19 mai 2011, 17h 38min 39s
Objet : Re: selecting data


Cassandra is not a RDBMS. Only you can do is search on a key, or you need full 
scan.
You need to design your schema carefully as your application needs.



On 2011/05/20, at 1:11, karim abbouh <ka...@yahoo.fr> wrote:


i'm new using cassandra database,
>i want to get data as in relationnel database:
>select * from table where field="value";
>i see using CLI we have just the followings commands :
>get <ksp>.<cf>['<key>']                                  Get a slice of 
columns.
>get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub 
columns.
>get  <ksp>.<cf>['<key>']['<col>']                             Get a column 
>value.
>get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column 
value.
>
>is there a way for that.
>i think using java API is possible.
>cassandra version : 6.0.12
>
>
>thanks for help
>
>
>
>

Re: selecting data

Posted by Watanabe Maki <wa...@gmail.com>.
Cassandra is not a RDBMS. Only you can do is search on a key, or you need full scan.
You need to design your schema carefully as your application needs.


On 2011/05/20, at 1:11, karim abbouh <ka...@yahoo.fr> wrote:

> i'm new using cassandra database,
> i want to get data as in relationnel database:
> select * from table where field="value";
> i see using CLI we have just the followings commands :
> get <ksp>.<cf>['<key>']                                  Get a slice of columns.
> get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub columns.
> get <ksp>.<cf>['<key>']['<col>']                             Get a column value.
> get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column value.
> 
> is there a way for that.
> i think using java API is possible.
> cassandra version : 6.0.12
> 
> 
> thanks for help
> 
> 
> 

Re : selecting data

Posted by karim abbouh <ka...@yahoo.fr>.
thanks,
but is there a way using just CLI and storage-conf.xml?




________________________________
De : Vivek Mishra <vi...@impetus.co.in>
À : "user@cassandra.apache.org" <us...@cassandra.apache.org>
Envoyé le : Jeu 19 mai 2011, 17h 23min 15s
Objet : RE: selecting data

 
You need to use CQL.
Additionally JDBC driver on top of CQL is part of beta release.


________________________________
 
From: karim abbouh [karim_rbt@yahoo.fr]
Sent: 19 May 2011 21:41
To: user@cassandra.apache.org
Subject: selecting data


i'm new using cassandra database,
i want to get data as in relationnel database:
select * from table where field="value";
i see using CLI we have just the followings commands :
get <ksp>.<cf>['<key>']                                  Get a slice of columns.
get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub columns.
get <ksp>.<cf>['<key>']['<col>']                             Get a column value.
get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column value.

is there a way for that.
i think using java API is possible.
cassandra version : 6.0.12


thanks for help




________________________________
 
Write to us for a Free Gold Pass to the Cloud Computing Expo, NYC to attend a 
live session by Head of Impetus Labs on ‘Secrets of Building a Cloud Vendor 
Agnostic PetaByte Scale Real-time Secure Web Application on the Cloud ‘. 


Looking to leverage the Cloud for your Big Data Strategy ? Attend Impetus 
webinar on May 27 by registering at http://www.impetus.com/webinar?eventid=42 .


NOTE: This message may contain information that is confidential, proprietary, 
privileged or otherwise protected by law. The message is intended solely for the 
named addressee. If received in error, please destroy and notify the sender. Any 
use of this email  is prohibited when received in error. Impetus does not 
represent, warrant and/or guarantee, that the integrity of this communication 
has been maintained nor that the communication is free of errors, virus, 
interception or interference.

RE: selecting data

Posted by Vivek Mishra <vi...@impetus.co.in>.
You need to use CQL.
Additionally JDBC driver on top of CQL is part of beta release.
________________________________
From: karim abbouh [karim_rbt@yahoo.fr]
Sent: 19 May 2011 21:41
To: user@cassandra.apache.org
Subject: selecting data

i'm new using cassandra database,
i want to get data as in relationnel database:
select * from table where field="value";
i see using CLI we have just the followings commands :
get <ksp>.<cf>['<key>']                                  Get a slice of columns.
get <ksp>.<cf>['<key>']['<super>']                   Get a slice of sub columns.
get <ksp>.<cf>['<key>']['<col>']                             Get a column value.
get <ksp>.<cf>['<key>']['<super>']['<col>']              Get a sub column value.

is there a way for that.
i think using java API is possible.
cassandra version : 6.0.12


thanks for help




________________________________

Write to us for a Free Gold Pass to the Cloud Computing Expo, NYC to attend a live session by Head of Impetus Labs on 'Secrets of Building a Cloud Vendor Agnostic PetaByte Scale Real-time Secure Web Application on the Cloud '.

Looking to leverage the Cloud for your Big Data Strategy ? Attend Impetus webinar on May 27 by registering at http://www.impetus.com/webinar?eventid=42 .


NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.