Re: Export as csv

2022-07-21 Thread Arvinder Dhillon
Yup, copy worked. Thanks. On Thu, Jul 21, 2022 at 10:55 AM Nitan Kainth wrote: > Use copy command or dsbulk > > > > > > Regards, > > Nitan K. > > 510-449-9629 > > > > > > *From: *Arvinder Dhillon > *Date: *Thursday, July 21, 2022 at

Export as csv

2022-07-21 Thread Arvinder Dhillon
What tool do I use to dump a columns of a table having 40K partitions into a csv file? I tried caqsh with CAPTURE, it stuck after 100 rows and needs "enter" to dump next 100, even with allow filtering. Thanks, Arvi

Re: Log4j vulnerability

2022-01-10 Thread Arvinder Dhillon
If anyone uses tlp-stress tool, it uses Log4j. It might not be in use most of the time, you might want to remove/upgrade the jar. On Mon, Dec 13, 2021 at 3:58 PM Bowen Song wrote: > Do you mean the log4j-over-slf4j-#.jar? If so, please read: > http://slf4j.org/log4shell.html > > On 13/12/2021

Re: Cassandra commitlog corruption on hard shutdown

2021-07-26 Thread Arvinder Dhillon
I thought durable_writes is the solution. -Arvinder On Mon, Jul 26, 2021, 1:00 PM Leon Zaruvinsky wrote: > Hi Cassandra community, > > We (and others) regularly run into commit log corruptions that are caused > by Cassandra, or the underlying infrastructure, being hard restarted. I > suspect

Re: Re: High mutation stage in multi dc deployment

2021-07-19 Thread Arvinder Dhillon
Is this the same cluster with 1G partition size? -Arvinder On Mon, Jul 19, 2021, 4:51 PM MyWorld wrote: > Hi daemeon, > We have already tuned the TCP settings to improve the bandwidth. Earlier > we had lot of hint and mutation msg drop which were gone after tuning TCP. > Moreover we are

Re: Snapshots space question

2021-02-16 Thread Arvinder Dhillon
You need to check if something/someone create snapshots. Maybe your application drops and recreate tables, and "create snapshot before drop" setting is enabled in your Cassandra setup? -Arvi On Tue, Feb 16, 2021, 1:04 PM Joe Obernberger wrote: > Hello all - I'm seeing a lot of disk usage by

Re: Encryption at rest

2020-06-24 Thread Arvinder Dhillon
Do it at storage level. On Wed, Jun 24, 2020, 1:01 PM Jeff Jirsa wrote: > Not really, no. > > > On Wed, Jun 24, 2020 at 1:00 PM Abdul Patel wrote: > >> Team, >> >> Do we have option in open source to do encryption at rest in cassandra ? >> >

data model for TWCS+TTL

2020-06-04 Thread Arvinder Dhillon
Hi eveyone, In our use-case, we need to insert 200 millions rows per day. By default we need to retain data for 10 days unless a certain condition is matched from client within same day(in that case we need to update ONE column and set ttl to 1 day). In 98% of cases we will find that match and

Re: How to elect a normal node to a seed node

2020-02-12 Thread Arvinder Dhillon
I believe seed nodes are not special nodes, it's just that you choose a few nodes from cluster that helps to bootstrap new joining nodes. You can change Cassandra.yaml to make any other node as seed node. There's nothing like promotion. -Arvinder On Wed, Feb 12, 2020, 8:37 AM Sergio wrote: >

Re: [EXTERNAL] How to reduce vnodes without downtime

2020-01-31 Thread Arvinder Dhillon
What is recommended vnodes now? I read 8 in later cassandra 3.x Is the new recommendation 4 now even in version 3.x (asking for 3.11)? Thanks On Fri, Jan 31, 2020 at 9:49 AM Durity, Sean R wrote: > These are good clarifications and expansions. > > > > Sean Durity > > > > *From:* Anthony Grasso

Re: *URGENT* Migration across different Cassandra cluster few having same keyspace/table names

2020-01-16 Thread Arvinder Dhillon
So as I understand, Cluster B already has some data and not an empty cluster. When you say, clusters share same keyspace and table names, do you mean both clusters have identical data on those ks/tables? -Arvi On Thu, Jan 16, 2020, 5:27 PM Ankit Gadhiya wrote: > Hello Group, > > I have a

Re: Authenticate cassandra-stress with cqlshrc

2019-01-08 Thread Arvinder Dhillon
, do not copy > or disclose its content, but please reply to this email immediately and > highlight the error to the sender and then immediately delete the message. > > > On Wed, 9 Jan 2019 at 06:01, Arvinder Dhillon > wrote: > >> I'm trying to connect cassandra-stress

Authenticate cassandra-stress with cqlshrc

2019-01-08 Thread Arvinder Dhillon
I'm trying to connect cassandra-stress 3.11.0 without providing user and password option on the comman line. It doesn't seems to be using cqlshrc. Any suggestions please? -Arvinder

Re: Wrong concistency level

2019-01-01 Thread Arvinder Dhillon
Probably you want to read this blog: https://academy.datastax.com/support-blog/read-repair -Arvinder On Tue, Jan 1, 2019, 12:43 PM Jeff Jirsa There are two types of read repair > > - Blocking/foreground due to reading you consistency level (local_quorum > for you) and one is the responses not

Re: nodetool repair -pr

2018-06-08 Thread Arvinder Dhillon
It depends on your data model. -pr only repair primary range. So if there is a keyspace with replication 'DC2:3', and you run repair -pr only on all nodes of DC1, it is not going to repair token ranges corsponding to DC2. So you will have to run on each node. -Arvinder On Fri, Jun 8, 2018, 8:42