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.