Re: Problem with restoring a snapshot using sstableloader

2018-12-02 Thread Alex Ott
Peak transfer rate      : 0.000KiB/s OH> I'm always getting the message "Skipping file mc-11-big-Data.db: table snapshots.table3 doesn't exist". I also tried to rename OH> the snapshots folder into the keyspace name (cass_testapp) but then I get the message "Skipping file

Re: Understanding output of read/write histogram using opscenter API

2019-06-09 Thread Alex Ott
ache.org BR> For additional commands, e-mail: user-h...@cassandra.apache.org -- With best wishes,Alex Ott Solutions Architect EMEA, DataStax http://datastax.com/ - To unsubscribe, e-mail: user-unsubsc

Re: Performance impact with ALLOW FILTERING clause.

2019-08-17 Thread Alex Ott
ode. I’m not a developer though I want to know why developer don’t have any control on JB> this to happen. JB> I’ll appreciate your guidance here. JB> Thanks JB> Asad -- With best wishes,Alex Ott Solutions Architect EMEA, DataStax http

Re: Keyspace Clone in Existing Cluster

2019-10-29 Thread Alex Ott
; > *Thanks & Regards,* > *Ankit Gadhiya* > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: COPY command with where condition

2020-01-20 Thread Alex Ott
ondition >> >> The COPY command doesn't support filtering and it doesn't perform well >> for large tables. >> >> Have you considered the DSBulk tool from DataStax? Previously, it only >> worked with DataStax Enterprise but a few weeks ago, it was made free and >> works with open-source Apache Cassandra. For details, see this blogpost >> <https://www.datastax.com/blog/2019/12/tools-for-apache-cassandra>. >> Cheers! >> >> On Fri, Jan 17, 2020 at 6:57 PM adrien ruffie >> wrote: >> >> Hello all, >> >> In my company we want to export a big dataset of our cassandra's ring. >> We search to use COPY command but I don't find if and how can a WHERE >> condition can be use ? >> >> Because we need to export only several data which must be return by a >> WHERE closure, specially >> and unfortunately with ALLOW FILTERING due to several old tables which >> were poorly conceptualized... >> >> Do you know a means to do that please ? >> >> Thank all and best regards >> >> Adrian >> >> >> -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: How to know execute_async correctly?

2020-01-05 Thread Alex Ott
> Can anyone explain? l> thx -- With best wishes,Alex Ott Principal Architect, DataStax http://datastax.com/ - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

Re: Disabling Swap for Cassandra

2020-04-17 Thread Alex Ott
; Regards, K> Kunal K>   -- With best wishes,Alex Ott Principal Architect, DataStax http://datastax.com/ - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

Re: How to find which table partitions having the more reads per sstables ?

2020-03-16 Thread Alex Ott
and DataStax have answers! Share your expertise on ER> https://community.datastax.com/. -- With best wishes,Alex Ott Principal Architect, DataStax http://datastax.com/ - To unsubscribe, e-mail: user-unsubs

Re: OOM only on one datacenter nodes

2020-04-05 Thread Alex Ott
simply run netstat at regular intervals and go from there. Cheers! RP> GOT QUESTIONS? Apache Cassandra experts from the community and DataStax have answers! Share your expertise on https://community.datastax.com/. -- With

Re: Query data through python using IN clause

2020-04-02 Thread Alex Ott
t;in(bam_user)". Expected: , Got: NK> ; (cannot convert argument to integer) NK> I found examples for prepared statements for inserts but couldn't find any for select and not able to make it to work.  NK> Any suggestions?

Re: Issues, understanding how CQL works

2020-04-22 Thread Alex Ott
T/UPDATE statements, but that's probably not you). >>>> >>>> Or you can use a more flexible database. >>>> >>>> >>>> 2. I need a way to learn all values that are in the "monthyear" and >>>> "signalid" columns in order to be able to craft that query. >>>> How can I achieve that in a reasonable way? As I said: The DB is >>>> round >>>> about 260 GB which makes it next to impossible to just "have a look" >>>> at >>>> the output of "SELECT *".. >>>> >>>> >>>> You probably want to keep another table of monthyear + signalid pairs. >>> >>> - >>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >>> For additional commands, e-mail: user-h...@cassandra.apache.org >>> >>> >>> >>> >>> The information in this Internet Email is confidential and may be legally >>> privileged. It is intended solely for the addressee. Access to this Email >>> by anyone >>> else is unauthorized. If you are not the intended recipient, any >>> disclosure, copying, >>> distribution or any action taken or omitted to be taken in reliance on it, >>> is >>> prohibited and may be unlawful. When addressed to our clients any opinions >>> or advice >>> contained in this Email are subject to the terms and conditions expressed >>> in any >>> applicable governing The Home Depot terms of business or client engagement >>> letter. The >>> Home Depot disclaims all responsibility and liability for the accuracy and >>> content of >>> this attachment and for any damages or losses arising from any >>> inaccuracies, errors, >>> viruses, e.g., worms, trojan horses, etc., or other items of a destructive >>> nature, >>> which may be contained in this attachment and shall not be liable for >>> direct, indirect, >>> consequential or special damages in connection with this e-mail message or >>> its >>> attachment. >>> >>> - >>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >>> For additional commands, e-mail: user-h...@cassandra.apache.org >>> >> >> - >> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >> For additional commands, e-mail: user-h...@cassandra.apache.org MR> - MR> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org MR> For additional commands, e-mail: user-h...@cassandra.apache.org -- With best wishes,Alex Ott Principal Architect, DataStax http://datastax.com/ - To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org

Re: Issues, understanding how CQL works

2020-04-22 Thread Alex Ott
year + signalid pairs. > > ----- > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > > > > > The information in this Internet Email is confidential and may be legally > privileged. It is intended solely for the addressee. Access to this Email > by anyone else is unauthorized. If you are not the intended recipient, any > disclosure, copying, distribution or any action taken or omitted to be > taken in reliance on it, is prohibited and may be unlawful. When addressed > to our clients any opinions or advice contained in this Email are subject > to the terms and conditions expressed in any applicable governing The Home > Depot terms of business or client engagement letter. The Home Depot > disclaims all responsibility and liability for the accuracy and content of > this attachment and for any damages or losses arising from any > inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other > items of a destructive nature, which may be contained in this attachment > and shall not be liable for direct, indirect, consequential or special > damages in connection with this e-mail message or its attachment. > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Tool for schema upgrades

2020-10-08 Thread Alex Ott
> Thanks > > Paul > - > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: tombstones - however there are no deletes

2020-08-21 Thread Alex Ott
t; > > Attila Wind > > > > > > > > http://www.linkedin.com/in/attilaw > > > Mobile: +49 176 43556932 > > > > > > > > > > > > > 21.08.2020 11:04 keltezéssel, Alex Ott > > írta: > > > > > >

Re: tombstones - however there are no deletes

2020-08-21 Thread Alex Ott
.com/cassandra-collections-hidden-tombstones-and-how-to-avoid-them/ >> > > And A. Ott has already mentioned both these possible reasons :-) > > -- > Alex > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: tombstones - however there are no deletes

2020-08-21 Thread Alex Ott
eresting to me > why those never generated things like this > > thanks! > -- > Attila Wind > > http://www.linkedin.com/in/attilaw > Mobile: +49 176 43556932 > > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Understanding replication

2020-09-20 Thread Alex Ott
acket size). > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: reverse paging state

2020-10-23 Thread Alex Ott
t; > .setPagingState(pagingState)) > > > > Thanks > > Manu > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Cqlsh copy command on a larger data set

2020-07-14 Thread Alex Ott
s/known issues to > keep in mind before attempting this? > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Impact of enabling authentication on performance

2020-06-03 Thread Alex Ott
-- DSR> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org DSR> For additional commands, e-mail: user-h...@cassandra.apache.org -- With best wishes,Alex Ott Principal Architect, DataStax http://datastax.com/ -

Re: Partition size, limits, recommendations for tables where all columns are part of the primary key

2020-06-09 Thread Alex Ott
r limits / potential performance > issues I should be concerned about? > > Ben Christenson > Developer > > Kinetic Data, Inc. > Your business. Your process. > 651-556-0937 | ben.christen...@kineticdata.com > www.kineticdata.com | community.kineticdata.com > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: what is allowed and not allowed w.r.t altering cassandra table schema

2020-07-16 Thread Alex Ott
; the new field an additional key then what will be the value of this key for > existing data? > > > > Thanks > > Manu > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Alex Ott
effective tool for unloading & loading >>>>data from/to Cassandra/DSE. Use zstd compression for offloaded data to >>>> save >>>>disk space (see blog links below for more details). But the *preserving >>>>metadata* could be a problem. >>

Re: Cqlsh copy command on a larger data set

2020-07-16 Thread Alex Ott
look into a series of the blog posts that I sent, I think that it should be in the 4th post On Thu, Jul 16, 2020 at 8:27 PM Jai Bheemsen Rao Dhanwada < jaibheem...@gmail.com> wrote: > okay, is there a way to export the TTL using CQLsh or DSBulk? > > On Thu, Jul 16, 2020 at 11

Re: Use NetworkTopologyStrategy for single data center and add data centers later

2020-12-19 Thread Alex Ott
ch etc. > > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows 10 > > > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Last stored value metadata table

2020-11-10 Thread Alex Ott
e`. > > Is there a Cassandra friendly solution to store the last value of every > `name` in a separate metadata table? It will come with a lot of > tombstones... any other solution? :) > > -- > Bye, > Auth Gábor > -- With best wishes,Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: local read from coordinator

2020-11-10 Thread Alex Ott
so the driver will pick a coordinator where > the token (partition) exists. Cheers! > -- With best wishes, Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Re: local read from coordinator

2020-11-11 Thread Alex Ott
dinator only with no other connections to > other nodes! > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > > Forwarded message > From: Alex Ott > To: "user" > Date: Wed, 11 Nov 2020 11:28:56 +0330 > Subject: Re:

Re: local read from coordinator

2020-11-11 Thread Alex Ott
h is going to pick the best option for local_one reads and any > compactions or latency deviations from load will make it likely that > another replica is chosen in practice) > > On Nov 11, 2020, at 3:46 AM, Alex Ott wrote: > >  > if you force routing key, then the replic

Re: Which open source or free tool do you use to monitor cassandra clusters?

2021-06-16 Thread Alex Ott
hi > > -- With best wishes, Alex Ott http://alexott.net/ Twitter: alexott_en (English), alexott (Russian)

Re: Changing num_tokens and migrating to 4.0

2021-03-20 Thread Alex Ott
cal" clusters lead to problems? > > No real need to do that anyways, moving from 6 nodes to (eventually) 8 > should be enough lessen the load on the disks, and before more space is > needed I will probably have more nodes. > > Lapo > > On 2021-03-20 16:23, Alex Ott wro

Re: Changing num_tokens and migrating to 4.0

2021-03-20 Thread Alex Ott
I get it correctly? > Can it be done "better"? > > Thanks in advance for any suggestion or correction! > > -- > Lapo Luchini > l...@lapo.it > > > ----- > To unsubscribe, e-mail: user-unsubscr...@cassandr