You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Jesus Ibanez <je...@gmail.com> on 2010/04/14 11:45:03 UTC
Lucandra or some way to query
Hello.
I need to know how to search in Cassandra. I could save the data in
different ways so I can then retrive it like for example this:
get keyspace.users['123']
=> (column=name, value=John, timestamp=xxxxxxxxxx)
get keyspace.searchByName['John']
=> (column=userID, value=123, timestamp=xxxxxxxxxx)
=> (column=userID, value=456, timestamp=xxxxxxxxxx)
=> (column=userID, value=789, timestamp=xxxxxxxxxx)
This works, but is very hard to maintain in the future and the amount of
data increase exponentially. You can do it for some data, but if I have to
do it for each property I need to query on, I have doubts if this is a good
idea. But if you think it can works, I will do it.
I red about Lucandra and seems interesting, but I couldn't run the examples,
I don't know if it is a good idea to use it and to be honest, I don't know
where to start.
I need to query a lot in my website, so what do you Cassandra users,
developers and testers recommend me?
Option 1 - insert data in all different ways I need in order to be able to
query?
Option 2 - implement Lucandra? Can you link me to a blog or an article that
guides me on how to implement Lucandra?
Option 3 - switch to an SQL database? (I hope not).
Thanks in advance!
Jesus.
Re: Lucandra or some way to query
Posted by malsmith <ma...@treehousesystems.com>.
We looking into migrating from a replicated solr infrastructure to some
form of clustered approach. Lucandra looks fantastic -- but this
statement is troubling:
"No normalizations are stored (no scoring)" from
http://github.com/tjake/Lucandra
When I use the demo/samples get do get a relevance score, can anyone
describe (or give a scenario) when this limitation would become a
problem?
Thanks in advance.
On Thu, 2010-04-15 at 05:16 +0000, Jake Luciani wrote:
> Lucandra spreads the data randomly by index + field combination so you
> do get "some" distribution for free. Otherwise you can use "nodetool
> loadbalance" to alter the token ring to alleviate hotspots.
>
> On Thu, Apr 15, 2010 at 2:04 AM, HubertChang <hu...@gmail.com> wrote:
>
>
> If you worked with Lucandra in a dedicated searching-purposed
> cluster, you
> could balanced the data very well with some effort.
>
> >>I think Lucandra is really a great idea, but since it needs
> order-preserving-partitioner, does that mean >>there may be
> some 'hot-spot'
> during searching?
>
> --
> View this message in context:
> http://n2.nabble.com/Lucandra-or-some-way-to-query-tp4900727p4905149.html
> Sent from the cassandra-user@incubator.apache.org mailing list
> archive at Nabble.com.
>
>
Re: Lucandra or some way to query
Posted by Jake Luciani <ja...@gmail.com>.
Lucandra spreads the data randomly by index + field combination so you do
get "some" distribution for free. Otherwise you can use "nodetool
loadbalance" to alter the token ring to alleviate hotspots.
On Thu, Apr 15, 2010 at 2:04 AM, HubertChang <hu...@gmail.com> wrote:
>
> If you worked with Lucandra in a dedicated searching-purposed cluster, you
> could balanced the data very well with some effort.
> >>I think Lucandra is really a great idea, but since it needs
> order-preserving-partitioner, does that mean >>there may be some 'hot-spot'
> during searching?
> --
> View this message in context:
> http://n2.nabble.com/Lucandra-or-some-way-to-query-tp4900727p4905149.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at
> Nabble.com.
>
Re: Lucandra or some way to query
Posted by HubertChang <hu...@gmail.com>.
If you worked with Lucandra in a dedicated searching-purposed cluster, you
could balanced the data very well with some effort.
>>I think Lucandra is really a great idea, but since it needs
order-preserving-partitioner, does that mean >>there may be some 'hot-spot'
during searching?
--
View this message in context: http://n2.nabble.com/Lucandra-or-some-way-to-query-tp4900727p4905149.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
Re: Lucandra or some way to query
Posted by Zhuguo Shi <bl...@gmail.com>.
I think Lucandra is really a great idea, but since it needs
order-preserving-partitioner, does that mean there may be some 'hot-spot'
during searching?
Re: Lucandra or some way to query
Posted by Jake Luciani <ja...@gmail.com>.
Hi,
What doesn't work with lucandra exactly? Feel free to msg me.
-Jake
On Wed, Apr 14, 2010 at 9:30 PM, Jesus Ibanez <je...@gmail.com> wrote:
> I will explore Lucandra a little more and if I can't get it to work today,
> I will go for Option 2.
> Using SQL will not be efficient in the future, if my website grows.
>
> Thenks for your answer Eric!
>
> Jesús.
>
>
> 2010/4/14 Eric Evans <ee...@rackspace.com>
>
> On Wed, 2010-04-14 at 06:45 -0300, Jesus Ibanez wrote:
>> > Option 1 - insert data in all different ways I need in order to be
>> > able to query?
>>
>> Rolling your own indexes is fairly common with Cassandra.
>>
>> > Option 2 - implement Lucandra? Can you link me to a blog or an article
>> > that guides me on how to implement Lucandra?
>>
>> I would recommend you explore this route a little further. I've never
>> used Lucandra so I can't be of help, but the author is active. Have you
>> tried submitting an issue on the github project page?
>>
>> > Option 3 - switch to an SQL database? (I hope not).
>>
>> If your requirements can be met with an SQL database, then sure, why
>> not?
>>
>> --
>> Eric Evans
>> eevans@rackspace.com
>>
>>
>
Re: Lucandra or some way to query
Posted by Jesus Ibanez <je...@gmail.com>.
I will explore Lucandra a little more and if I can't get it to work today, I
will go for Option 2.
Using SQL will not be efficient in the future, if my website grows.
Thenks for your answer Eric!
Jesús.
2010/4/14 Eric Evans <ee...@rackspace.com>
> On Wed, 2010-04-14 at 06:45 -0300, Jesus Ibanez wrote:
> > Option 1 - insert data in all different ways I need in order to be
> > able to query?
>
> Rolling your own indexes is fairly common with Cassandra.
>
> > Option 2 - implement Lucandra? Can you link me to a blog or an article
> > that guides me on how to implement Lucandra?
>
> I would recommend you explore this route a little further. I've never
> used Lucandra so I can't be of help, but the author is active. Have you
> tried submitting an issue on the github project page?
>
> > Option 3 - switch to an SQL database? (I hope not).
>
> If your requirements can be met with an SQL database, then sure, why
> not?
>
> --
> Eric Evans
> eevans@rackspace.com
>
>
Re: Lucandra or some way to query
Posted by Eric Evans <ee...@rackspace.com>.
On Wed, 2010-04-14 at 06:45 -0300, Jesus Ibanez wrote:
> Option 1 - insert data in all different ways I need in order to be
> able to query?
Rolling your own indexes is fairly common with Cassandra.
> Option 2 - implement Lucandra? Can you link me to a blog or an article
> that guides me on how to implement Lucandra?
I would recommend you explore this route a little further. I've never
used Lucandra so I can't be of help, but the author is active. Have you
tried submitting an issue on the github project page?
> Option 3 - switch to an SQL database? (I hope not).
If your requirements can be met with an SQL database, then sure, why
not?
--
Eric Evans
eevans@rackspace.com