ave on
average when reading a value. This is available in:
- nodetool cfstats ks.cf<http://ks.cf> : Average tombstones per slice/Maximum
tombstones per slice
- JMX :
org.apache.cassandra.metrics:keyspace=,name=TombstoneScannedHistogram,scope=,type=ColumnFamily
Max/Count/99thPercentile/Mean
Thanks a lot for your help.
We are using STCS strategy and not using TTL
Is there any API that we can use to query the current number of tombstones in a
CF?
From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in]
Sent: 2016年11月14日 22:20
To: user@cassandra.apache.org
Subject: Re: Some questions to
Hi, All,
Will the Cassandra generates a new tombstone when updating a column by using
CQL update statement?
And is there any way to get the number of tombstones of a column family since
we want to void generating
too many tombstones within gc_grace_period?
Thanks
Boying
Hi, All,
We use Cassandra 2.1.11 in our product and I tried its sstable2json to dump
some sstable file like this:
sstable2json full-path-to-sstable-file (e.g. xxx-Data.db).
But I got an assert error at "assert initialized ||
keyspaceName.equals(SYSTEM_KS);" (Keyspace.java:97).
The 'keysp
août 2016 11h32, "Lu, Boying"
mailto:boying...@emc.com>> a écrit :
Here is the error message in our log file:
java.lang.RuntimeException: Incompatible SSTable found. Current version ka is
unable to read file:
/data/db/1/data/StorageOS/RemoteDirectorGroup/StorageOS-RemoteDirecto
have one time seen an issue with commit log archiving preventing a
startup during upgrade. Usually there is something else broken and the version
mismatch is a false signal.
Regards,
Ryan Svihla
On Aug 18, 2016, at 10:18 PM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Thanks a lot.
I’m a
月18日 18:44
To: user@cassandra.apache.org
Subject: Re: A question to updatesstables
Replies inline
Carlos Alonso | Software Engineer | @calonso<https://twitter.com/calonso>
On 18 August 2016 at 11:56, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All,
We use Cassandra in our pr
Hi, All,
We use Cassandra in our product. I our early release we use Cassandra 1.2.10
whose SSTable is 'ic' format.
We upgrade Cassandra to 2.0.10 in our product release. But the Cassandra server
failed to start due to the
incompatible SSTable format and the log message told us to use 'nodetool
yet, see https://issues.apache.org/jira/browse/CASSANDRA-10857
Note that secondary indexes don't scale. Be aware of their limitations.
If you want to change the data model of a CF, a Spark job can do the trick.
Best,
Romain
Le Mardi 7 juin 2016 10h51, "Lu, Boying"
mailto:boying...@emc.com>
Hi, All,
Since the Astyanax client has been EOL, we are considering to migrate to
Datastax java client in our product.
One thing I notice is that the CFs created by Astyanax have 'compact storage'
attribute which prevent us from
using some new features provided by CQL such as secondary index.
Hi, All,
We are considering to support more flexible searching on data in the Cassandra
DB (used in our product).
For example, full-text search and query data based on different columns.
After some investigating, I found
https://github.com/Stratio/cassandra-lucene-index/blob/branch-2.1.8/doc/sr
ssible but then we'll need to update the binary
protocol. Just create a JIRA and ask for this feature
On Tue, May 10, 2016 at 5:00 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Thanks very much.
I understand that the data needs to be read from the DB to get the next
‘PagingState
3. Since there are concurrent inserts on the cluster at the same time,
when you re-use the paging state 2 for example, you may not get the same
results as the previous read.
And it is inevitable in an eventual consistent distributed DB world
On Mon, May 9, 2016 at 12:25 PM, Lu, Boying
mailto:boy
dHi, All,
We are considering to use DataStax java driver in our codes. One important
feature provided by the driver we want to use is 'paging'.
But according to the
https://datastax.github.io/java-driver/3.0.0/manual/paging/, it seems that we
can't jump between pages.
Is it possible to just re
Hi, All,
We plan to upgrade Cassandra from 2.0.17 to the latest release 2.2.3 in our
product.
We use:
/**
* Same as forceRepairAsync, but handles a specified range
*/
public int forceRepairRangeAsync(String beginToken, String endToken, final
String keyspaceName, boolean isSequential,
Hi, All,
We plan to upgrade Cassandra from 2.0.17 to 2.1.11 (the latest stable release
recommended to be used in the product environment) in our product.
Currently we are using Astyanax 1.56.49 as Java client, I found there are many
new Astyanax at https://github.com/Netflix/astyanax/releases
So
Hi, All,
Can anyone give some suggestions about the
https://issues.apache.org/jira/browse/CASSANDRA-10420 ?
We are waiting for a solution of it.
Thanks
Boying
Hi, All,
The latest stable release of Cassandra is 2.2.1 and I notice the following line
in the "Requirements" section of README.asc comes with the source codes:
Java >=1.7 (OpenJDK and Oracle JVMS have been tested)
Does this mean that Cassandra 2.2.1 (binary release) can work with Java 7?
Tha
Hi, All,
We have an Cassandra environment with two connected DCs and our consistency
level of writing operation is EACH_QUORUM.
So if one DC is down, the write will be failed and we get
TokenRangeOfflineException on the client side (we use netfilix java client
libraries).
We want to give more
Thanks a lot :)
From: Yoshi Kimoto [mailto:yy.kim...@gmail.com]
Sent: 2015年6月24日 12:12
To: user@cassandra.apache.org
Subject: Re: Is there any roadmap of Cassandra 3.0?
Looking for this? Or something else?
http://planetcassandra.org/blog/cassandra-2-2-3-0-and-beyond/
On 2015/06/24 12:42, Lu
Hi, All,
Does anyone know the roadmap of Cassandra 3.0?
Thanks
Boying
sandra/blob/cassandra-2.1/conf/cqlshrc.sample>
Adam Holmberg
On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All,
Does anyone know the answer?
Thanks a lot
Boying
From: Lu, Boying
Sent: 2015年1月6日 11:21
To: user@cassandra.apache.org<
thub.com/apache/cassandra/blob/cassandra-2.1/pylib/cqlshlib/sslhandling.py>
Example cqlshrc
file<https://github.com/apache/cassandra/blob/cassandra-2.1/conf/cqlshrc.sample>
Adam Holmberg
On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All,
Does
lt;https://github.com/apache/cassandra/blob/cassandra-2.1/pylib/cqlshlib/sslhandling.py>
Example cqlshrc
file<https://github.com/apache/cassandra/blob/cassandra-2.1/conf/cqlshrc.sample>
Adam Holmberg
On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All
Hi, All,
Does anyone know the answer?
Thanks a lot
Boying
From: Lu, Boying
Sent: 2015年1月6日 11:21
To: user@cassandra.apache.org
Subject: How to use cqlsh to access Cassandra DB if the
client_encryption_options is enabled
Hi, All,
I turned on the dbclient_encryption_options like this
Hi, All,
I turned on the dbclient_encryption_options like this:
client_encryption_options:
enabled: true
keystore: path-to-my-keystore-file
keystore_password: my-keystore-password
truststore: path-to-my-truststore-file
truststore_password: my-truststore-password
...
I can use following cassand
or on the new datacenter:
Step 1 - Current DC
Step 2 - New DC
Step 3 - Depending on the snitch you may need to make changes on both the
current and new DCs
Step 4 - Client config
Step 5 - Client config
Step 6 - New DC
Step 7 - New DC
Step 8 - New DC
Mark
On 21 November 2014 03:27, Lu, B
onfig
Step 6 - New DC
Step 7 - New DC
Step 8 - New DC
Mark
On 21 November 2014 03:27, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, all,
I read the document about how to adding a new data center to existing clusters
posted at
http://www.datastax.com/documentation/cassandra/2.0/cassandra
Hi, all,
I read the document about how to adding a new data center to existing clusters
posted at
http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html
But I have a question: Are all those steps executed only at the new adding
cluster or on exist
Hi, All,
I'm trying to enable client-to-node encrypt communication in Cassandra (2.0.7)
with Astyanax client library (version=1.56.48)
I found the links about how to enable this feature:
http://www.datastax.com/documentation/cassandra/2.0/cassandra/security/secureSSLClientToNode_t.html
But this
Hi, All,
I want to enable client-to-node encrypt communication, I read some related
documents.
I need to set the following changes in the server side (in yaml):
client_encryption_opitons:
enabled : true
keystore: conf/.keystore
keystore_password: some-password
truststore: conf/.trustst
-download-432124.html
Bulat
On Sep 26, 2014, at 7:58, "Lu, Boying"
mailto:boying...@emc.com>> wrote:
Hi, All,
I use the following configuration (in yaml file) to enable the client-to-node
encryption:
client_encryption_options:
enabled: true
keystore: path-
Hi, All,
I use the following configuration (in yaml file) to enable the client-to-node
encryption:
client_encryption_options:
enabled: true
keystore: path-to-keystore-file
keystore_password: some-password
truststore: path-to-truststore-file
truststore_password: some-password
But
remove all nodes in DC3 via nodetool
removenode from a node in DC1, all nodes in both DC1 and DC2 will be informed
of the nodes removal so no need to run it from a node in DC2.
Mark
On Thu, Aug 14, 2014 at 10:20 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All,
We have a Cassandra
Hi, All,
We have a Cassandra 2.0.7 running in three connected DCs, say DC1, DC2 and DC3.
DC3 is powered off, so we run 'nodetool removenode' command on DC1 to remove
all nodes of DC3.
Do we need to run the same command on DC2?
Thanks
Boying
umentation here:
http://www.datastax.com/documentation/cassandra/1.2/cassandra/configuration/configCassandra_yaml_r.html
-- artur
On 14/08/14 06:48, Lu, Boying wrote:
Hi, All,
We are using Cassandra 2.0.7 in a multi DCs environments. If a connected DC is
powered off, we use the ‘nodetool remo
Hi, All,
We are using Cassandra 2.0.7 in a multi DCs environments. If a connected DC is
powered off, we use the 'nodetool removenode' command to remove it from the
connected DCs.
But we found that once the disconnected DC is powered on, it will connect to
other DCs automatically.
How can we p
datastax.com>> wrote:
On Tue, Aug 5, 2014 at 11:40 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
What I want to know is “are the strategy changed ?’ after the ‘udpate keyspace
with strategy_options…’ command returns successfully
Like all schema changes, not necessarily on all no
;
command
Changing the strategy options, and in particular the replication factor, does
not perform any data replication by itself. You need to run a repair to ensure
data is replicated following the new replication.
On Tue, Aug 5, 2014 at 10:52 AM, Lu, Boying
mailto:boying...@emc.com>&g
To: user
Subject: Re: A question about using 'update keyspace with strategyoptions'
command
Try the show keyspaces command and look for "Options" under each keyspace.
Thanks
Rahul
On Tue, Aug 5, 2014 at 2:01 PM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, A
Hi, All,
I want to run 'update keyspace with strategy_options={dc1:3, dc2:3}' from
cassandra-cli to update the strategy options of some keyspace
in a multi-DC environment.
When the command returns successfully, does it mean that the strategy options
have been updated successfully or I need to w
. That way user cannot modify data in
specific keyspace or column family.
http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/grant_r.html
-Vivek
On Mon, Jul 21, 2014 at 7:57 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Thanks a lot ☺
But I think authorization and authenticat
?
Boying
From: Vivek Mishra [mailto:mishra.v...@gmail.com]
Sent: 2014年7月17日 18:35
To: user@cassandra.apache.org
Subject: Re: How to prevent writing to a Keyspace?
Think about managing it via authorization and authentication support
On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying
mailto:boying
Hi, All,
I need to make a Cassandra keyspace to be read-only.
Does anyone know how to do that?
Thanks
Boying
Hi, All,
I need to remove a Cassandra data center from a set of connected Cassandra data
centers (I use Cassandra 2.0.7).
I found a related document at
http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_decomission_dc_t.html
But I need to do these in my Java programs.
Hi, All,
I use the astyanax 1.56.48 + Cassandra 2.0.6 in my test codes and do some query
like this:
query = keyspace.prepareQuery(..).getKey(...)
.autoPaginate(true)
.withColumnRange(new RangeBuilder().setLimit(pageSize).build());
ColumnList result;
result= query.execute().getResult();
while (!
Hi, All,
I need to add a Cassandra (running on a three nodes) fresh installed in a
datacenter say DC3 to existing Cassandra datacenters say DC1 and DC2.
I read the document about it at
http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html
But I h
Hi, All,
I wonder if I can change the seeds list at runtime. i.e. without change the
yaml file and restart DB service?
Thanks
Boying
:26 AM, "Lu, Boying"
mailto:boying...@emc.com>> wrote:
Hi, experts,
Since the Cassandra 2.x supports DB that across multiple DCs, my question is
how many DCs can Cassandra support in practice?
Thanks
Boying
Hi, experts,
Since the Cassandra 2.x supports DB that across multiple DCs, my question is
how many DCs can Cassandra support in practice?
Thanks
Boying
Hi, experts,
I need to query all columns of a row in a column family that meet some
conditions (see below). The column is composite column and has following
format:
... where componentN has String type.
What I want to do is to find out all columns that meet following conditions:
1. comp
Hi, All,
Does anyone know how many Datacenters Cassandra supports?
Thanks
Boying
Hi, All,
I need to paginate all columns in a row. but can not to use
RowQuery.autoPaginate() method to do this
due to some requirements.
All columns are composite column and I need to get next 'page' by a separated
query.
Here is my pseudo codes (page size =3):
ColumList result = query.execu
t way to do this is a bit
different but I hope this shows you the general idea.
T#
On Thu, Feb 27, 2014 at 11:36 AM, Lu, Boying
mailto:boying...@emc.com>> wrote:
Hi, All,
I’m using Netflix/Astyanax as a java cassandra client to access Cassandra DB.
I need to paginate through all columns in a
Hi, All,
I'm using Netflix/Astyanax as a java cassandra client to access Cassandra DB.
I need to paginate through all columns in a row and I found the document at
https://github.com/Netflix/astyanax/wiki/Reading-Data
about how to do that.
But my requirement is a little different. I don't want
Hi, All,
When I read the codes of OutboundTcpConnection.expireMessages(), I found the
following snippet in a loop:
if (qm.timestamp >= System.currentTimeMillis() - qm.message.getTimeout())
return;
My understanding is that this method is to remove all the expired messages fro
Thanks a lot :)
From: Robert Coli [mailto:rc...@eventbrite.com]
Sent: 2014年1月24日 4:54
To: user@cassandra.apache.org
Subject: Re: How to add a new DC to cluster in Cassandra 2.x
On Tue, Jan 21, 2014 at 7:16 AM, Tupshin Harper
mailto:tups...@tupshin.com>> wrote:
This should be the doc you are loo
/webhelp/index.html#cassandra/operations/ops_add_dc_to_cluster_t.html
-Tupshin
On Jan 21, 2014 2:14 AM, "Lu, Boying"
mailto:boying...@emc.com>> wrote:
Hi, All,
I’m new to Cassandra. I want to know how to add a DC to existing Cassandra
cluster (all running Cassandra 2.x).
I
Hi, All,
I'm new to Cassandra. I want to know how to add a DC to existing Cassandra
cluster (all running Cassandra 2.x).
I found a related document at
http://www.datastax.com/docs/1.1/cluster_management
Is it still valid for Cassandra 2.x?
Thanks
Boying
59 matches
Mail list logo