RE: Solr Search With Apache Cassandra

2017-11-20 Thread Jacques-Henri Berthemet
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:nandanpriyadarshi...@gmail.com]
Sent: lundi 20 novembre 2017 06:44
To: user 
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

2017-11-20 Thread @Nandan@
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.berthe...@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:nandanpriyadarshi...@gmail.com]
> *Sent:* lundi 20 novembre 2017 06:44
> *To:* user 
> *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
>


Stratio Lucene Index

2017-11-20 Thread Akshit Jain
Hi,
Does using lucene index affects the performance of the read/write in
cassandra.
How heavy is the operation of creating a lucene index on a table with some
GB's of data?


RE: Solr Search With Apache Cassandra

2017-11-20 Thread Jacques-Henri Berthemet
How are Cassandra and Solr related? they are two separate products.

--
Jacques-Henri Berthemet

From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com]
Sent: lundi 20 novembre 2017 10:04
To: user 
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 
mailto:jacques-henri.berthe...@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:nandanpriyadarshi...@gmail.com]
Sent: lundi 20 novembre 2017 06:44
To: user mailto:user@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

2017-11-20 Thread @Nandan@
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.berthe...@genesys.com> wrote:

> How are Cassandra and Solr related? they are two separate products.
>
>
>
> *--*
>
> *Jacques-Henri Berthemet*
>
>
>
> *From:* @Nandan@ [mailto:nandanpriyadarshi...@gmail.com]
> *Sent:* lundi 20 novembre 2017 10:04
> *To:* user 
> *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.berthe...@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:nandanpriyadarshi...@gmail.com]
> *Sent:* lundi 20 novembre 2017 06:44
> *To:* user 
> *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: Running Cassandra on FreeBSD

2017-11-20 Thread Jeronimo de A. Barros
Jens,

Al Tobey's Cassandra 2.1 tuning guide has excellents infos about running
Cassandra. Apparently he uses Arch Linux and we've been using Slackware
Linux in a 12 node cluster (2 DCs 6/6) for the last 3 years with no
problems.

https://tobert.github.io/pages/als-cassandra-21-tuning-guide.html

You just need a modern Linux distro scrapped from any services that could
compromise I/O and CPUs performance and memory (hence, we choose Slackware).

Regards,

Jero

On Sat, Nov 18, 2017 at 9:20 AM, Jens Grassel  wrote:

> Hi Michael,
>
> On Fri, 17 Nov 2017 08:22:20 -0600
> Michael Shuler  wrote:
>
> MS> That ML post was linked on:
> MS> https://issues.apache.org/jira/browse/CASSANDRA-8325
> MS>
> MS> That JIRA has a couple patches you might look at for examples.
>
> thanks. Sadly we don't have time to dive deep into this therefore we'll
> just pick a supported platform to run cassandra on.
>
> Regards,
>
> Jens
>
> --
> CTO, Wegtam GmbH, 18. Nebelung 2017, 12:19
> Homepage : https://www.wegtam.com
>
> Horace's best ode would not please a young woman as much
> as the mediocre verses of the young man she is in love with.
> -- Moore
>


Difference in ops/s for cassandra stress tool

2017-11-20 Thread Akshit Jain
hi,
Would there be any difference in the performance of the stress tool if the
keyspaces being populated are of type :-
One is of default keyspace1 standard1 having columns of blob type
Second one is of mixed type (string,int,text)etc.

Please tell in terms of ops/sec.


Warning on node decommision

2017-11-20 Thread Christian Lorenz
Hi,

I’ve tried to decommission a Node in a cassandra 3.11.1 cluster.
The following warning appear in the logfile of the other nodes:

WARN  [StreamReceiveTask:10] 2017-11-20 17:06:00,735 StorageProxy.java:790 - 
Received base materialized view mutation for key 
DecoratedKey(-3222800209314657990, 2f9e98706a924798aff34a9a693357f1) that does 
not belong to this node. There is probably a range movement happening (move or 
decommission),but this node hasn't updated its ring metadata yet. Adding 
mutation to local batchlog to be replayed later.

Is this something to worry about?

Cheers,
Christian


Re: Solr Search With Apache Cassandra

2017-11-20 Thread Nageswara Rao
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@"  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.berthe...@genesys.com> wrote:
>
>> How are Cassandra and Solr related? they are two separate products.
>>
>>
>>
>> *--*
>>
>> *Jacques-Henri Berthemet*
>>
>>
>>
>> *From:* @Nandan@ [mailto:nandanpriyadarshi...@gmail.com]
>> *Sent:* lundi 20 novembre 2017 10:04
>> *To:* user 
>> *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.berthe...@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:nandanpriyadarshi...@gmail.com]
>> *Sent:* lundi 20 novembre 2017 06:44
>> *To:* user 
>> *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

2017-11-20 Thread Jon Haddad
That’s long since been abandoned (last commit was 5 years ago)


> On Nov 20, 2017, at 12:10 PM, Nageswara Rao  wrote:
> 
> 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@"  > 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 
>  > wrote:
> How are Cassandra and Solr related? they are two separate products.
> 
>  
> 
> --
> 
> Jacques-Henri Berthemet
> 
>  
> 
> From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com 
> ] 
> Sent: lundi 20 novembre 2017 10:04
> To: user mailto:user@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 
>  > 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:nandanpriyadarshi...@gmail.com 
> ] 
> Sent: lundi 20 novembre 2017 06:44
> To: user mailto:user@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

2017-11-20 Thread Jacques-Henri Berthemet
Tjake is now working for Datastax and they made DSE out of Solandra.

--
Jacques-Henri Berthemet

From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad
Sent: lundi 20 novembre 2017 18:11
To: user 
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 
mailto:nageswara.r...@gmail.com>> wrote:

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@" 
mailto:nandanpriyadarshi...@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 
mailto:jacques-henri.berthe...@genesys.com>>
 wrote:
How are Cassandra and Solr related? they are two separate products.

--
Jacques-Henri Berthemet

From: @Nandan@ 
[mailto:nandanpriyadarshi...@gmail.com]
Sent: lundi 20 novembre 2017 10:04
To: user mailto:user@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 
mailto:jacques-henri.berthe...@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:nandanpriyadarshi...@gmail.com]
Sent: lundi 20 novembre 2017 06:44
To: user mailto:user@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: Warning on node decommision

2017-11-20 Thread kurt greaves
Should be fine, unless it keeps happening then it's a problem. Means
exactly what it says:
>
> There is probably a range movement happening (move or decommission),but
> this node hasn't updated its ring metadata yet

It will keep attempting to replay it until the node has updated its ring
metadata, so if it continues to be a problem you will continue to see this
warning.

On 20 November 2017 at 16:09, Christian Lorenz <
christian.lor...@webtrekk.com> wrote:

> Hi,
>
>
>
> I’ve tried to decommission a Node in a cassandra 3.11.1 cluster.
>
> The following warning appear in the logfile of the other nodes:
>
>
>
> WARN  [StreamReceiveTask:10] 2017-11-20 17:06:00,735 StorageProxy.java:790
> - Received base materialized view mutation for key 
> DecoratedKey(-3222800209314657990,
> 2f9e98706a924798aff34a9a693357f1) that does not belong to this node.
> There is probably a range movement happening (move or decommission),but
> this node hasn't updated its ring metadata yet. Adding mutation to local
> batchlog to be replayed later.
>
>
>
> Is this something to worry about?
>
>
>
> Cheers,
>
> Christian
>