Re: Re : Cluster performance after enabling SSL

2016-09-13 Thread G P
Read this: http://www.aifb.kit.edu/images/5/58/IC2E2014-Performance_Overhead_TLS.pdf It can cause bigger variances in latencies, but not much. Terça-feira, 13 Setembro 2016, 08:01PM +01:00 de sai krishnam raju potturi pskraj...@gmail.com: hi; will enabling SSL

Re: Re : Cluster performance after enabling SSL

2016-09-13 Thread Surbhi Gupta
We have seen a little overhead in latencies while enabling the client_encryption. Our cluster gets around 40-50K reads and writes per second. On 13 September 2016 at 12:01, sai krishnam raju potturi < pskraj...@gmail.com> wrote: > hi; > will enabling SSL (node-to-node) cause an overhead in the

Re : Cluster performance after enabling SSL

2016-09-13 Thread sai krishnam raju potturi
hi; will enabling SSL (node-to-node) cause an overhead in the performance of Cassandra? We have tried it out on a small test cluster while running Cassandra-stress tool, and did not see much difference in terms of read and write latencies. Could somebody throw some light regarding any

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

2016-09-13 Thread Mikhail Krupitskiy
Looks like we have different understanding of what results are expected. I based my understanding on http://docs.datastax.com/en/cql/3.3/cql/cql_using/useSASIIndex.html According to the doc ‘esc’ is a pattern for exact match

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

2016-09-13 Thread DuyHai Doan
CREATE CUSTOM INDEX ON test.escape(val) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'CONTAINS', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 'case_sensitive': 'false'}; I don't see any problem in the results you got SELECT *

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

2016-09-13 Thread Mikhail Krupitskiy
Thanks for the reply. Could you please provide what index definition did you use? With the index from my script I get the following results: cqlsh:test> select * from escape; id | val +--- 1 | %escapeme 2 | escape%me 3 | escape%esc Contains search cqlsh:test> SELECT * FROM

Re: How to query '%' character using LIKE operator in Cassandra 3.7?

2016-09-13 Thread DuyHai Doan
Use % to escape % cqlsh:test> select * from escape; id | val +--- 1 | %escapeme 2 | escape%me Contains search cqlsh:test> SELECT * FROM escape WHERE val LIKE '%%esc%'; id | val +--- 1 | %escapeme (1 rows) Prefix search cqlsh:test> SELECT * FROM escape

How to query '%' character using LIKE operator in Cassandra 3.7?

2016-09-13 Thread Mikhail Krupitskiy
Hi Cassandra guys, I use Cassandra 3.7 and wondering how to use ‘%’ as a simple char in a search pattern. Here is my test script: DROP keyspace if exists kmv; CREATE keyspace if not exists kmv WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor':'1'} ; USE kmv; CREATE TABLE if

Re: Incremental repairs in 3.0

2016-09-13 Thread Jean Carlo
Hi Paulo! Sorry there was something I was doing wrong. Now I can see that the value of Repaired At changes even if there is no streaming. I am using cassandra 2.1.14 and the comand was nodetool repair -inc -par. Anyway good to know this: > If you're using subrange repair, please note that this

Re: External linking Was: Isolation in case of Single Partition Writes and Batching with LWT

2016-09-13 Thread Benedict Elliott Smith
Again: *dev list*. "Please Note: These requirements apply to Apache projects: that is, to *individual committer and PMC behaviors* and actions within the context of collaboratively building software products at The Apache Software Foundation. By definition here, "Apache project" means the

External linking Was: Isolation in case of Single Partition Writes and Batching with LWT

2016-09-13 Thread Mark Thomas
On 12/09/2016 19:22, Jim Ancona wrote: > Mark, > > Is there some official Apache policy on which sites it's appropriate to > link to on an Apache mailing list? If so, could you please post a link > to it so we can all understand the rules. Or is this your personal > opinion on what you'd like to