You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "@Nandan@" <na...@gmail.com> on 2017/11/20 05:43:38 UTC
Solr Search With Apache Cassandra
Hi All,
How Solr Search affect the READ operation from Cassandra?
I am having a table with 100 columns with Primary Key as UUID.
Note:- I am having 100 columns in a single table because of implemented
Advance search on multiple columns like E-commerce.
Now my concerns are:-
1) whenever do READ from a table based on a Primary key such as
select * from table1 where col1 = UUID;
It's working perfectly.
2) When even do READ from table with using solr on 1,2 columns such as
using col1:val1 and col2:val2
it is working also perfect.
3) But when I am performing a complex search, it is taking time such as 4-5
seconds.
even currently READ and WRITE operations are not on the massive scale.
So please tell me what's the cause and how to resolve this.
Thanks
Nandan Priyadarshi
RE: Solr Search With Apache Cassandra
Posted by Jacques-Henri Berthemet <ja...@genesys.com>.
Tjake is now working for Datastax and they made DSE out of Solandra.
--
Jacques-Henri Berthemet
From: Jon Haddad [mailto:jonathan.haddad@gmail.com] On Behalf Of Jon Haddad
Sent: lundi 20 novembre 2017 18:11
To: user <us...@cassandra.apache.org>
Subject: Re: Solr Search With Apache Cassandra
That’s long since been abandoned (last commit was 5 years ago)
On Nov 20, 2017, at 12:10 PM, Nageswara Rao <na...@gmail.com>> wrote:
There is a fork with name on this combo called solandra
https://github.com/tjake/Solandra<https://github.com/tjake/Solandra>
Please check.
On 20 Nov 2017 3:13 p.m., "@Nandan@" <na...@gmail.com>> wrote:
Sorry, For my mistakes. I mean that Using Apache Cassandra for storage and Solr for search facility from DSE.
Thanks for your Suggestion, will check with DSE mates.
Thanks
Nandan
On Mon, Nov 20, 2017 at 5:36 PM, Jacques-Henri Berthemet <ja...@genesys.com>> wrote:
How are Cassandra and Solr related? they are two separate products.
--
Jacques-Henri Berthemet
From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com<ma...@gmail.com>]
Sent: lundi 20 novembre 2017 10:04
To: user <us...@cassandra.apache.org>>
Subject: Re: Solr Search With Apache Cassandra
Hi Jacques,
For testing, I configure Apache Cassandra and Solr.
and Using Solr Admin for testing the query.
Thanks
On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <ja...@genesys.com>> wrote:
Hi,
Apache Cassandra does not have Solr search, it’s Datastax Entreprise that supports such feature, you should contact Datastax support for such questions.
Regards,
--
Jacques-Henri Berthemet
From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com<ma...@gmail.com>]
Sent: lundi 20 novembre 2017 06:44
To: user <us...@cassandra.apache.org>>
Subject: Solr Search With Apache Cassandra
Hi All,
How Solr Search affect the READ operation from Cassandra?
I am having a table with 100 columns with Primary Key as UUID.
Note:- I am having 100 columns in a single table because of implemented Advance search on multiple columns like E-commerce.
Now my concerns are:-
1) whenever do READ from a table based on a Primary key such as
select * from table1 where col1 = UUID;
It's working perfectly.
2) When even do READ from table with using solr on 1,2 columns such as
using col1:val1 and col2:val2
it is working also perfect.
3) But when I am performing a complex search, it is taking time such as 4-5 seconds.
even currently READ and WRITE operations are not on the massive scale.
So please tell me what's the cause and how to resolve this.
Thanks
Nandan Priyadarshi
Re: Solr Search With Apache Cassandra
Posted by Jon Haddad <jo...@jonhaddad.com>.
That’s long since been abandoned (last commit was 5 years ago)
> On Nov 20, 2017, at 12:10 PM, Nageswara Rao <na...@gmail.com> wrote:
>
> There is a fork with name on this combo called solandra
>
> https://github.com/tjake/Solandra <https://github.com/tjake/Solandra>
>
> Please check.
>
>
> On 20 Nov 2017 3:13 p.m., "@Nandan@" <nandanpriyadarshi298@gmail.com <ma...@gmail.com>> wrote:
> Sorry, For my mistakes. I mean that Using Apache Cassandra for storage and Solr for search facility from DSE.
> Thanks for your Suggestion, will check with DSE mates.
>
> Thanks
> Nandan
>
> On Mon, Nov 20, 2017 at 5:36 PM, Jacques-Henri Berthemet <jacques-henri.berthemet@genesys.com <ma...@genesys.com>> wrote:
> How are Cassandra and Solr related? they are two separate products.
>
>
>
> --
>
> Jacques-Henri Berthemet
>
>
>
> From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com <ma...@gmail.com>]
> Sent: lundi 20 novembre 2017 10:04
> To: user <user@cassandra.apache.org <ma...@cassandra.apache.org>>
> Subject: Re: Solr Search With Apache Cassandra
>
>
>
> Hi Jacques,
>
>
>
> For testing, I configure Apache Cassandra and Solr.
>
> and Using Solr Admin for testing the query.
>
>
>
> Thanks
>
>
>
> On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <jacques-henri.berthemet@genesys.com <ma...@genesys.com>> wrote:
>
> Hi,
>
>
>
> Apache Cassandra does not have Solr search, it’s Datastax Entreprise that supports such feature, you should contact Datastax support for such questions.
>
>
>
> Regards,
>
> --
>
> Jacques-Henri Berthemet
>
>
>
> From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com <ma...@gmail.com>]
> Sent: lundi 20 novembre 2017 06:44
> To: user <user@cassandra.apache.org <ma...@cassandra.apache.org>>
> Subject: Solr Search With Apache Cassandra
>
>
>
> Hi All,
>
> How Solr Search affect the READ operation from Cassandra?
>
> I am having a table with 100 columns with Primary Key as UUID.
>
> Note:- I am having 100 columns in a single table because of implemented Advance search on multiple columns like E-commerce.
>
>
>
> Now my concerns are:-
>
> 1) whenever do READ from a table based on a Primary key such as
>
> select * from table1 where col1 = UUID;
>
> It's working perfectly.
>
> 2) When even do READ from table with using solr on 1,2 columns such as
>
> using col1:val1 and col2:val2
>
> it is working also perfect.
>
> 3) But when I am performing a complex search, it is taking time such as 4-5 seconds.
>
> even currently READ and WRITE operations are not on the massive scale.
>
>
>
> So please tell me what's the cause and how to resolve this.
>
> Thanks
>
> Nandan Priyadarshi
>
>
>
>
Re: Solr Search With Apache Cassandra
Posted by Nageswara Rao <na...@gmail.com>.
There is a fork with name on this combo called solandra
https://github.com/tjake/Solandra
Please check.
On 20 Nov 2017 3:13 p.m., "@Nandan@" <na...@gmail.com> wrote:
> Sorry, For my mistakes. I mean that Using Apache Cassandra for storage
> and Solr for search facility from DSE.
> Thanks for your Suggestion, will check with DSE mates.
>
> Thanks
> Nandan
>
> On Mon, Nov 20, 2017 at 5:36 PM, Jacques-Henri Berthemet <
> jacques-henri.berthemet@genesys.com> wrote:
>
>> How are Cassandra and Solr related? they are two separate products.
>>
>>
>>
>> *--*
>>
>> *Jacques-Henri Berthemet*
>>
>>
>>
>> *From:* @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
>> *Sent:* lundi 20 novembre 2017 10:04
>> *To:* user <us...@cassandra.apache.org>
>> *Subject:* Re: Solr Search With Apache Cassandra
>>
>>
>>
>> Hi Jacques,
>>
>>
>>
>> For testing, I configure Apache Cassandra and Solr.
>>
>> and Using Solr Admin for testing the query.
>>
>>
>>
>> Thanks
>>
>>
>>
>> On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <
>> jacques-henri.berthemet@genesys.com> wrote:
>>
>> Hi,
>>
>>
>>
>> Apache Cassandra does not have Solr search, it’s Datastax Entreprise
>> that supports such feature, you should contact Datastax support for such
>> questions.
>>
>>
>>
>> Regards,
>>
>> *--*
>>
>> *Jacques-Henri Berthemet*
>>
>>
>>
>> *From:* @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
>> *Sent:* lundi 20 novembre 2017 06:44
>> *To:* user <us...@cassandra.apache.org>
>> *Subject:* Solr Search With Apache Cassandra
>>
>>
>>
>> Hi All,
>>
>> How Solr Search affect the READ operation from Cassandra?
>>
>> I am having a table with 100 columns with Primary Key as UUID.
>>
>> Note:- I am having 100 columns in a single table because of implemented
>> Advance search on multiple columns like E-commerce.
>>
>>
>>
>> Now my concerns are:-
>>
>> 1) whenever do READ from a table based on a Primary key such as
>>
>> select * from table1 where col1 = UUID;
>>
>> It's working perfectly.
>>
>> 2) When even do READ from table with using solr on 1,2 columns such as
>>
>> using col1:val1 and col2:val2
>>
>> it is working also perfect.
>>
>> 3) But when I am performing a complex search, it is taking time such as
>> 4-5 seconds.
>>
>> even currently READ and WRITE operations are not on the massive scale.
>>
>>
>>
>> So please tell me what's the cause and how to resolve this.
>>
>> Thanks
>>
>> Nandan Priyadarshi
>>
>>
>>
>
>
Re: Solr Search With Apache Cassandra
Posted by "@Nandan@" <na...@gmail.com>.
Sorry, For my mistakes. I mean that Using Apache Cassandra for storage
and Solr for search facility from DSE.
Thanks for your Suggestion, will check with DSE mates.
Thanks
Nandan
On Mon, Nov 20, 2017 at 5:36 PM, Jacques-Henri Berthemet <
jacques-henri.berthemet@genesys.com> wrote:
> How are Cassandra and Solr related? they are two separate products.
>
>
>
> *--*
>
> *Jacques-Henri Berthemet*
>
>
>
> *From:* @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
> *Sent:* lundi 20 novembre 2017 10:04
> *To:* user <us...@cassandra.apache.org>
> *Subject:* Re: Solr Search With Apache Cassandra
>
>
>
> Hi Jacques,
>
>
>
> For testing, I configure Apache Cassandra and Solr.
>
> and Using Solr Admin for testing the query.
>
>
>
> Thanks
>
>
>
> On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <
> jacques-henri.berthemet@genesys.com> wrote:
>
> Hi,
>
>
>
> Apache Cassandra does not have Solr search, it’s Datastax Entreprise that
> supports such feature, you should contact Datastax support for such
> questions.
>
>
>
> Regards,
>
> *--*
>
> *Jacques-Henri Berthemet*
>
>
>
> *From:* @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
> *Sent:* lundi 20 novembre 2017 06:44
> *To:* user <us...@cassandra.apache.org>
> *Subject:* Solr Search With Apache Cassandra
>
>
>
> Hi All,
>
> How Solr Search affect the READ operation from Cassandra?
>
> I am having a table with 100 columns with Primary Key as UUID.
>
> Note:- I am having 100 columns in a single table because of implemented
> Advance search on multiple columns like E-commerce.
>
>
>
> Now my concerns are:-
>
> 1) whenever do READ from a table based on a Primary key such as
>
> select * from table1 where col1 = UUID;
>
> It's working perfectly.
>
> 2) When even do READ from table with using solr on 1,2 columns such as
>
> using col1:val1 and col2:val2
>
> it is working also perfect.
>
> 3) But when I am performing a complex search, it is taking time such as
> 4-5 seconds.
>
> even currently READ and WRITE operations are not on the massive scale.
>
>
>
> So please tell me what's the cause and how to resolve this.
>
> Thanks
>
> Nandan Priyadarshi
>
>
>
RE: Solr Search With Apache Cassandra
Posted by Jacques-Henri Berthemet <ja...@genesys.com>.
How are Cassandra and Solr related? they are two separate products.
--
Jacques-Henri Berthemet
From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
Sent: lundi 20 novembre 2017 10:04
To: user <us...@cassandra.apache.org>
Subject: Re: Solr Search With Apache Cassandra
Hi Jacques,
For testing, I configure Apache Cassandra and Solr.
and Using Solr Admin for testing the query.
Thanks
On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <ja...@genesys.com>> wrote:
Hi,
Apache Cassandra does not have Solr search, it’s Datastax Entreprise that supports such feature, you should contact Datastax support for such questions.
Regards,
--
Jacques-Henri Berthemet
From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com<ma...@gmail.com>]
Sent: lundi 20 novembre 2017 06:44
To: user <us...@cassandra.apache.org>>
Subject: Solr Search With Apache Cassandra
Hi All,
How Solr Search affect the READ operation from Cassandra?
I am having a table with 100 columns with Primary Key as UUID.
Note:- I am having 100 columns in a single table because of implemented Advance search on multiple columns like E-commerce.
Now my concerns are:-
1) whenever do READ from a table based on a Primary key such as
select * from table1 where col1 = UUID;
It's working perfectly.
2) When even do READ from table with using solr on 1,2 columns such as
using col1:val1 and col2:val2
it is working also perfect.
3) But when I am performing a complex search, it is taking time such as 4-5 seconds.
even currently READ and WRITE operations are not on the massive scale.
So please tell me what's the cause and how to resolve this.
Thanks
Nandan Priyadarshi
Re: Solr Search With Apache Cassandra
Posted by "@Nandan@" <na...@gmail.com>.
Hi Jacques,
For testing, I configure Apache Cassandra and Solr.
and Using Solr Admin for testing the query.
Thanks
On Mon, Nov 20, 2017 at 4:37 PM, Jacques-Henri Berthemet <
jacques-henri.berthemet@genesys.com> wrote:
> Hi,
>
>
>
> Apache Cassandra does not have Solr search, it’s Datastax Entreprise that
> supports such feature, you should contact Datastax support for such
> questions.
>
>
>
> Regards,
>
> *--*
>
> *Jacques-Henri Berthemet*
>
>
>
> *From:* @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
> *Sent:* lundi 20 novembre 2017 06:44
> *To:* user <us...@cassandra.apache.org>
> *Subject:* Solr Search With Apache Cassandra
>
>
>
> Hi All,
>
> How Solr Search affect the READ operation from Cassandra?
>
> I am having a table with 100 columns with Primary Key as UUID.
>
> Note:- I am having 100 columns in a single table because of implemented
> Advance search on multiple columns like E-commerce.
>
>
>
> Now my concerns are:-
>
> 1) whenever do READ from a table based on a Primary key such as
>
> select * from table1 where col1 = UUID;
>
> It's working perfectly.
>
> 2) When even do READ from table with using solr on 1,2 columns such as
>
> using col1:val1 and col2:val2
>
> it is working also perfect.
>
> 3) But when I am performing a complex search, it is taking time such as
> 4-5 seconds.
>
> even currently READ and WRITE operations are not on the massive scale.
>
>
>
> So please tell me what's the cause and how to resolve this.
>
> Thanks
>
> Nandan Priyadarshi
>
RE: Solr Search With Apache Cassandra
Posted by Jacques-Henri Berthemet <ja...@genesys.com>.
Hi,
Apache Cassandra does not have Solr search, it’s Datastax Entreprise that supports such feature, you should contact Datastax support for such questions.
Regards,
--
Jacques-Henri Berthemet
From: @Nandan@ [mailto:nandanpriyadarshi298@gmail.com]
Sent: lundi 20 novembre 2017 06:44
To: user <us...@cassandra.apache.org>
Subject: Solr Search With Apache Cassandra
Hi All,
How Solr Search affect the READ operation from Cassandra?
I am having a table with 100 columns with Primary Key as UUID.
Note:- I am having 100 columns in a single table because of implemented Advance search on multiple columns like E-commerce.
Now my concerns are:-
1) whenever do READ from a table based on a Primary key such as
select * from table1 where col1 = UUID;
It's working perfectly.
2) When even do READ from table with using solr on 1,2 columns such as
using col1:val1 and col2:val2
it is working also perfect.
3) But when I am performing a complex search, it is taking time such as 4-5 seconds.
even currently READ and WRITE operations are not on the massive scale.
So please tell me what's the cause and how to resolve this.
Thanks
Nandan Priyadarshi