Re: openjdk for cassandra production cluster

2018-10-10 Thread Christophe Schmitz
It is fixed in 3.11.2 https://issues.apache.org/jira/browse/CASSANDRA-13916 On Thu, 11 Oct 2018 at 02:10 prachirath72 wrote: > Thanks Jonathan, > Is there a ticket/bugid to remove this openjdk WARN. > Want to have a look . > > > Original message > From: Jonathan Haddad >

Re: SSTableMetadata Util

2018-10-01 Thread Christophe Schmitz
://github.com/instaclustr/cassandra-sstable-tools which will provided you with the desired info, plus more info you might find useful. Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - Cassandra | Kafka | Spark Consulting On Tue, 2 Oct 2018 at 11:31 Pranay akula wrote: >

Re: Cassandra loading data from another table

2018-10-01 Thread Christophe Schmitz
Have a look at using Spark on Cassandra. It's commonly used for data movement / data migration / reconciliation (on top of analytics). You will get much better performances. Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - Cassandra | Kafka | Spark Consulting On Tue,

Re: [EXTERNAL] Re: Rolling back Cassandra upgrades (tarball)

2018-10-01 Thread Christophe Schmitz
on the secondary DC. Once you are happy, you can decommission the old version DC (check carefully your application endpoint configuration, local_dc configuration) Hope this helps. Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - Cassandra | Kafka | Spark Consulting

Re: Cassandra loading data from another table

2018-10-01 Thread Christophe Schmitz
A or Table B during this process. Please test first :) Cheers, Christophe Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - Cassandra | Kafka | Spark Consulting On Tue, 2 Oct 2018 at 09:18 Richard Xin wrote: > I have a tableA with about a few ten millions record, and I ha

Re: Cassandra Storage per node

2018-09-27 Thread Christophe Schmitz
of STCS. Hope this help! Cheers, Christophe Christophe Schmitz - Instaclustr <https://www.instaclustr.com/> - Cassandra | Kafka | Spark Consulting On Fri, 28 Sep 2018 at 14:43 Suresh Rajagopal wrote: > Hi, > > I am new to Cassandra. Is there any recommended maximum dat

Re: GUI clients for Cassandra

2018-05-04 Thread Christophe Schmitz
gt; > On 24 Apr 2018, at 03:45, Christophe Schmitz <christo...@instaclustr.com> > wrote: > > Hi Hannu ;) > > > >> >> I have been asked many times that what is a good GUI client for >>> Cassandra. DevCenter is not available anymore and DataStax has a DevStud

Re: Version Upgrade

2018-04-25 Thread Christophe Schmitz
to 3.0.16 or 3.0.y to 3.11.y?? > > > Thanks > Pranay > -- *Christophe Schmitz - **VP Consulting* AU: +61 4 03751980 / FR: +33 7 82022899 <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <https://www.linkedin.com/company/instaclustr

Re: GUI clients for Cassandra

2018-04-23 Thread Christophe Schmitz
Hi Hannu ;) > > I have been asked many times that what is a good GUI client for Cassandra. >> DevCenter is not available anymore and DataStax has a DevStudio but that’s >> for DSE only. >> > DevCenter is still available, I just downloaded it. Cheers, Christophe

Re: A Cassandra Storage Estimation Mechanism

2018-04-18 Thread Christophe Schmitz
. The goal is usually to confirm the throughput / latency. As a side effect, this also gives the disk usage. Hope it helps! Cheers, Christophe > > Thanks in advance > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > -- *Christophe Schmitz - **VP Consulting* AU: +61 4 03751980 / FR: +33 7 82022899

Re: Why nodetool cleanup should be run sequentially after node joined a cluster

2018-04-10 Thread Christophe Schmitz
n one node > before running nodetool cleanup on the next node. > > I had added a new node to the cluster, and running nodetool cleanup > according to this recommendation - but it takes near 10 days to complete on > a single node. Is it safe to start it on all nodes? > -- *Christop

Re: copy from one table to another

2018-04-08 Thread Christophe Schmitz
tables with all files of that sequence and move to target tables > directory and rename it. > > Restart target node or run nodetool refresh > > Sent from my iPhone > > On Apr 8, 2018, at 4:15 AM, onmstester onmstester <onmstes...@zoho.com> > wrote: > > Is there any way

Re: Apache Cassandra start up script

2018-03-27 Thread Christophe Schmitz
; Mob-718-844-3841 > PA,USA > > Sent from my iPhone > - > To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org > For additional commands, e-mail: user-h...@cassandra.apache.org > > -- *Christophe Schmitz - **VP Consulting* AU:

Re: Execute an external program

2018-03-27 Thread Christophe Schmitz
ll, > > I may be over the edge here, but is there a way to execute an external > program if a new row is added or if an existing row is updated on a table? > > Cheers, > Earl > > -- > There are seven words in this sentence. > -- *Christophe Schmitz - **VP Cons

Re: high latency on one node after replacement

2018-03-27 Thread Christophe Schmitz
t thought was that this is related > to the EBS volumes, but it seems too consistent to be actually caused by > that. The problem is consistent across multiple replacements, and multiple > EC2 regions. > > I appreciate any suggestions! > > - Mike > -- *Christophe Schmitz

Re: Measuring eventual consistency latency

2018-03-25 Thread Christophe Schmitz
s topic in some place and someone > could point me the direction, it will be of great help. > > Thanks ! > -- *Christophe Schmitz - **VP Consulting* AU: +61 4 03751980 / FR: +33 7 82022899 <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> <htt

Re: Deserialize Map[Int, UDT] to a case class from Spark Connector

2018-03-25 Thread Christophe Schmitz
a:36) > at com.datastax.spark.connector.types.TypeConverter$ > CollectionConverter.targetTypeName(TypeConverter.scala:682) > at com.datastax.spark.connector.rdd.reader. > GettableDataToMappedTypeConverter.tryConvert( > GettableDataToMappedTypeConverter.scala:156) > -- *Christophe

Re: Cassandra CF Level Metrics (Read, Write Count and Latency)

2017-08-31 Thread Christophe Schmitz
document and tried setting up the metric as following, > does this is not matching with the total read requests. I am using > "ReadLatency_OneMinuteRate" > > /org.apache.cassandra.metrics:type=ColumnFamily,keyspace=*, > scope=*,name=ReadLatency > > On Thu, Aug 31, 2017 at

Re: Cassandra CF Level Metrics (Read, Write Count and Latency)

2017-08-31 Thread Christophe Schmitz
Hello Jai, Did you have a look at the following page: http://cassandra.apache.org/doc/latest/operating/metrics.html In your case, you would want the following MBeans: org.apache.cassandra.metrics:type=Table keyspace= scope= name= With MetricName set to ReadLatency and WriteLatency Cheers,

Re: Getting all unique keys

2017-08-21 Thread Christophe Schmitz
Cheers > Avi > > On Mon, Aug 21, 2017 at 3:43 AM, Christophe Schmitz < > christo...@instaclustr.com> wrote: > >> Hi Avi, >> >> Have you thought of using Spark for that work? If you collocate the spark >> workers on each Cassandra nodes, the spark-ca

Re: Getting all unique keys

2017-08-20 Thread Christophe Schmitz
* >>> >>> is not very efficient but how about the approach presented here >>> <http://www.scylladb.com/2017/02/13/efficient-full-table-scans-with-scylla-1-6/> >>> sending queries in parallel and using the token >>> >>> *SELECT DISTINCT id

Re: Cassandra Writes Duplicated/Concatenated List Data

2017-08-16 Thread Christophe Schmitz
Hi Nathan, The code may occasionally write to the same row multiple times. > > Can you run a test using IF NOT EXISTS in your inserts to see if that makes a difference? That shouldn't make a difference, but I don't see what the problem might be at the moment. -- *Christophe S

Re: Large tombstones creation

2017-08-13 Thread Christophe Schmitz
* FROM ... LIMIT 5000 (see tombstone_warn_threshold)* > > How it can happen? I have several SASI indexes for this table, can this be > a reason? > > Regards, Vlad > -- *Christophe Schmitz* *Director of consulting EMEA*AU: +61 4 03751980 / FR: +33 7 82022899 <https://www.instacl

DateTieredCompactionStrategy DTCS sometimes stop dropping SSTables

2015-07-20 Thread Christophe Schmitz
Hi there, I am running a 6 node cluster on 2.1.7 with a table using DTCS to store time series data, for up to 12 hours (using ttl of 12h). Data are written as they arrive, without any update or active delete. During the first 12h, the cluster gets filled with data. And a bit later, the amount of