full text search on some text columns

2018-07-31 Thread onmstester onmstester
I need to do a full text search (like) on one of my clustering keys and one of partition keys (it use text as data type). The input rate is high so only Cassandra could handle it, Is there any open source version project which help using cassandra+ solr or cassandra + elastic? Any

Re: optimization to cassandra-env.sh

2018-07-31 Thread R1 J1
Thank you Sean and Rahul for the consult On Sun, Jul 29, 2018 at 6:52 PM, Rahul Singh wrote: > Depends on which GC you are using but you can definitely manage GC - but > you will always be stuck to the upper limit of memory. > > I found the Hubspot gc visualizer and the associated blog post

RE: [EXTERNAL] full text search on some text columns

2018-07-31 Thread Durity, Sean R
That sounds like a problem tailor-made for the DataStax Search (embedded SOLR) solution. I think that would be the fastest path to success. Sean Durity From: onmstester onmstester Sent: Tuesday, July 31, 2018 10:46 AM To: user Subject: [EXTERNAL] full text search on some text columns I need

Cassandra 3.11 and subrange repairs

2018-07-31 Thread Jean Carlo
Hello everyone, I am just wondering if someone is using this tool to make repairs in cassandra 3.11 https://github.com/BrianGallew/cassandra_range_repair Or everybody is using cassandra-reaper ? :) I am willing to use cassandra-reaper soon but meanwhile I will just need to cron the repairs in

Re: Cassandra 3.11 and subrange repairs

2018-07-31 Thread Martin Mačura
I am using this tool with 3.11, had to modify it to make it usable: https://github.com/BrianGallew/cassandra_range_repair/pull/60 Martin On Tue, Jul 31, 2018 at 3:44 PM Jean Carlo wrote: > > Hello everyone, > > I am just wondering if someone is using this tool to make repairs in > cassandra

Re: Alter table

2018-07-31 Thread James Shaw
in a heavy transaction PROD env, it is risk, considering c* has a lot of bugs. the DDL has to be replicated to all nodes, use nodetool describecluster to check schema version same on all nodes, if not, you may restart that node which DDL not replicated. in new version, DDL is none or all, you

Fwd: Re: [EXTERNAL] full text search on some text columns

2018-07-31 Thread onmstester onmstester
It seems to be an interesting project but sort of abandoned. No update in last 8 Months and not supporting Cassandra 3.11.2  (the version i currently use) Sent using Zoho Mail Forwarded message From : Andrzej Śliwiński To : Date : Wed, 01 Aug 2018 08:16:06 +0430

Re: full text search on some text columns

2018-07-31 Thread onmstester onmstester
Thanks Jordan, There would be millions of rows per day, is SASI capable of standing such a rate? Sent using Zoho Mail On Tue, 31 Jul 2018 19:47:55 +0430 Jordan West wrote On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester wrote: I need to do a full text search (like) on one of

RE: [EXTERNAL] full text search on some text columns

2018-07-31 Thread onmstester onmstester
Actually we can't afford buying DataStax Search Sent using Zoho Mail On Tue, 31 Jul 2018 19:38:28 +0430 Durity, Sean R wrote That sounds like a problem tailor-made for the DataStax Search (embedded SOLR) solution. I think that would be the fastest path to success.     Sean Durity  

Re: [EXTERNAL] full text search on some text columns

2018-07-31 Thread Andrzej Śliwiński
Maybe this plugin could do the job: https://github.com/Stratio/cassandra-lucene-index On Tue, 31 Jul 2018 at 22:37, onmstester onmstester wrote: > Actually we can't afford buying DataStax Search > > Sent using Zoho Mail > > > On Tue, 31 Jul 2018 19:38:28 +0430

Re: Re: [EXTERNAL] full text search on some text columns

2018-07-31 Thread Ben Slater
We (Instaclustr) will be submitting a PR for 3.11.3 support for cassandra-lucene-index once 3.11.3 is officially released as we offer it as part of our service and have customers using it. Cheers Ben On Wed, 1 Aug 2018 at 14:06 onmstester onmstester wrote: > It seems to be an interesting

JOB | Permanent Java Development Manager (Montreal, Canada)

2018-07-31 Thread James Tobin
Hello, I'm working with an employer that is looking to hire (for their Montreal office) a permanent development manager that has extensive hands-on Java coding experience. Consequently I had hoped that some members of this mailing list may like to discuss with me further; off-list. I can be

Re: Reaper 1.2 released

2018-07-31 Thread Akash Gangil
Hi, I see that when I try to access /snapshot/{clusterName} API endpoint, I get a 404 while all the other endpoints /cluster, /repair_run and /repair_scheduler work for me. I am using version 1.2.1 It appears as if the /snapshot endpoint is not there API doc that I am referring

Re: full text search on some text columns

2018-07-31 Thread DuyHai Doan
I had SASI in mind before stopping myself from replying to this thread. Actually the OP needs to index clustering column and partition key, and as far as I remember, I've myself opened a JIRA and pushed a patch for SASI to support indexing composite partition key but there are some issues so far

Secure data

2018-07-31 Thread Rahul Reddy
Hello, I'm trying to find a good document on to enable encryption for Apache Cassandra (not on dse) tables and commilogs and store the keystore in kms or vault. If any of you already configured please direct me to documentation for it.

Re: full text search on some text columns

2018-07-31 Thread Jordan West
On Tue, Jul 31, 2018 at 7:45 AM, onmstester onmstester wrote: > I need to do a full text search (like) on one of my clustering keys and > one of partition keys (it use text as data type). > For simple LIKE queries on existing columns you could give SASI (