Re: Manual Repairs

2017-06-21 Thread Ben Slater
The closest you can get to this kind of functionality is by breaking up your repairs by ranges and then you could pause/restart part way through the set of ranges. There are some basic scripted approaches around to doing this but Cassandra Reaper is probably your best bet to get this kind of functi

Re: Manual Repairs

2017-06-21 Thread Fay Hou [Storage Service] ­
what version of your cassandra and what kind repair you are doing? full repair or incremental repair? list your repair command On Wed, Jun 21, 2017 at 3:27 PM, Mark Furlong wrote: > Can a repair be paused, and if paused can it be restarted from the point > of the pause, or does it start over? >

Manual Repairs

2017-06-21 Thread Mark Furlong
Can a repair be paused, and if paused can it be restarted from the point of the pause, or does it start over? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreativ

Re: Count limit

2017-06-21 Thread Vladimir Yudovin
Hi, >Some body told because the count return 1 row result He is right Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Jun 2017 02:43:32 -0400 web master wrote According to http://www.maigfrga.ntweb.co/counting-i

Re: Pagination

2017-06-21 Thread Vladimir Yudovin
Hi, can this https://docs.datastax.com/en/developer/java-driver/2.1/manual/paging/ help you? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Jun 2017 02:44:17 -0400 web master wrote I am migrating from MySql to Cas

RE: COUNT

2017-06-21 Thread ZAIDI, ASAD A
Is it possible for you to share tracing info for the query? You can enable tracing at cqlsh prompt with command Cqlsh > TRACING ON Cqlsh> run your query Tracing session info should be printed on screen Tracing will enable us to know where most of the time is spent! From: web master [mailto:sock

Re: LIKE

2017-06-21 Thread @Nandan@
If you are sure , that you want to do LIKE , then you can go with SASI . https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html Hope this will help you . On Wed, Jun 21, 2017 at 2:44 PM, web master wrote: > I have this table > > CREATE TABLE users_by_username ( > username