TR: how to store date before > 1970

Hello all, I have a tricky question about "how to store a date" if dates can be a date prior to 1970 ? I checked the potential data type and found timestamp and date but both begin to the epoch (January 1, 1970) ... If I want to store oldest dating, which data type and means I can use ? Thank

RE: [EXTERNAL] Re: Getting Consistency level TWO when it is requested LOCAL_ONE

https://issues.apache.org/jira/browse/CASSANDRA-9620 has something similar that was determined to be a driver error. I would start with looking at the driver version and also the RetryPolicy that is in effect for the Cluster. Secondly, I would look at whether a batch is really needed for the sta

Moving a node to another RAC in the same DC.

Hi, I have accidentally bootstrapped a node in a wrong RAC (RAC11) and I would like to move it to the correct RAC with the remaining nodes (RAC1). The status now is x.x.x.x=DC1:RAC1 x.x.x.x=DC1:RAC1 x.x.x.x=DC1:RAC1 x.x.x.x=DC1:RAC11 Due to issues with free storage I think will be dangerous t

Re: cass-2.2 trigger - how to get clustering columns and value?

Thank you all. On Thu, Apr 11, 2019 at 4:35 AM Paul Chandler wrote: > Hi Carl, > > I now this is not exactly answering your question, but it may help with > the split. > > I have split a multi tenancy cluster several times using a similar > process to TLP’s Data Centre Switch: > http://thelastp

Re: cass-2.2 trigger - how to get clustering columns and value?

Hi Carl, I now this is not exactly answering your question, but it may help with the split. I have split a multi tenancy cluster several times using a similar process to TLP’s Data Centre Switch: http://thelastpickle.com/blog/2019/02/26/data-center-switch.html However instead of phase 3, we

Re: Getting Consistency level TWO when it is requested LOCAL_ONE

Hi Jean, I want to understand how you are setting the write consistency level as LOCAL ONE. That is with every query you mentioning consistency level or you have set the spring cassandra config with provided consistency level. Like this: cluster.setQueryOptions(new QueryOptions().setConsistencyLev

Re: All time blocked in nodetool tpstats

Hi Abdul, That all depends on the cluster, so it really is best to experiment. By adding more threads you will use more of the system resources, so before you start you need to know if there is spare capacity in the CPU usage and the disk throughput. If there is spare capacity then increase the

Cassandra client side versus server side query timestamp.

Hello all, As per my knowledge spring data cassandra (recent version) uses by default cassandra client side query timestamp. I am just curious to know which once is more preferable and recommended to have out of client side or server side query timestamp. Also if any logical reason for the same.

Getting Consistency level TWO when it is requested LOCAL_ONE

Hello everyone, I have a case where the developers are using spring data framework for Cassandra. We are writing batches setting consistency level at LOCAL_ONE but we got a timeout like this *Caused by: com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during BATCH_LOG

Re: cass-2.2 trigger - how to get clustering columns and value?

Hi, You should take a look at how Stratio’s Lucene index decodes CFs and keys, start from RowService.doIndex() implementations: https://github.com/Stratio/cassandra-lucene-index/tree/branch-2.2.13/plugin/src/main/java/com/stratio/cassandra/lucene/service Note that in some cases an update without