Re: Understanding C* -XX:MaxTenuringThreshold=1

2015-10-26 Thread John Schulz
You are correct. That is the intent of the MaxTenuringThreshold parameter. Setting the value > 1 keeps objects in survivor space longer, if there is space to keep them. The intent of keeping objects in survivor space for longer than one ParNew cycle is to prevent relatively short lived objects

Find partition row of Compacted partition maximum bytes

2015-10-26 Thread qihuang.zheng
I use nodetool cfstats to see table’s status, and findCompacted partition maximum bytes: 190G. Is there anyway to find this largest wide partition row? [qihuang.zheng@cass047202 cassandra]$ nodetool cfstats forseti.velocity Keyspace: forseti Read Count: 10470099 Read Latency: 1.3186399419909973

Re: Find partition row of Compacted partition maximum bytes

2015-10-26 Thread DuyHai Doan
>From C* 2.2.x > nodetool help toppartitions NAME nodetool toppartitions - Sample and print the most active partitions for a given column family On Mon, Oct 26, 2015 at 7:54 AM, qihuang.zheng wrote: > I use nodetool cfstats to see table’s

Re: Can consistency-levels be different for "read" and "write" in Datastax Java-Driver?

2015-10-26 Thread daemeon reiydelle
If one rethinks "consistency" to mean "copies returned" and "copies written" then one can have different values for the former (datastax) and the latter (within Cassandra). The latter changes eventual consistency (e.g. two copies must be written), the former can speed up a result at the (slight)

Re: how to grant permissions to OpsCenter keyspace?

2015-10-26 Thread Adam Holmberg
You need to quote the "OpsCenter" identifier to distinguish capital letters: https://cassandra.apache.org/doc/cql3/CQL.html#identifiers Adam On Mon, Oct 26, 2015 at 4:25 PM, Kai Wang wrote: > Hi, > > My understanding is that if I want to enable internal authentication and >

how to grant permissions to OpsCenter keyspace?

2015-10-26 Thread Kai Wang
Hi, My understanding is that if I want to enable internal authentication and authorization on C* while still keeping OpsCenter working, I should grant all to OpsCenter space and describe/select on everything else. But when I try to grant permissions to or even switch into OpsCenter, cqlsh reports

Re: how to grant permissions to OpsCenter keyspace?

2015-10-26 Thread Kai Wang
Thanks Adam. On Mon, Oct 26, 2015 at 5:30 PM, Adam Holmberg wrote: > You need to quote the "OpsCenter" identifier to distinguish capital > letters: > https://cassandra.apache.org/doc/cql3/CQL.html#identifiers > > Adam > > On Mon, Oct 26, 2015 at 4:25 PM, Kai Wang

Cassandra Hadoop Integration

2015-10-26 Thread Kenji Fnu
Hi guys, I was wondering how should hadoop and cassandra integrate with each other? Currently I am running a spring-data framework to integrate those 2. I wonder if there are other ways. Also is it possible to access cassandra from remote facility? thanks a lot!

decommission too slow

2015-10-26 Thread qihuang.zheng
Recently we want to delete some c* nodes for data migration. C* verision:2.0.15 we use nodetooldecommission with nohup: nohup nodetool decommission -h xxx After execute 3 days already, seems this process did’t finished yet! This decommissioning Node data isnearly 400G. 1. I check jps -lm, and

Re: C* Table Changed and Data Migration with new primary key

2015-10-26 Thread qihuang.zheng
Tks Doan! we would try spark. as our online already has spark1.4.1. but our C* version is 2.0.15, As spark1.4 need 2.1.5, when I query size get error “Failed to fetch size estimates for system.size_estimates”. but that’s not a serious problem. I tried use spark1.4.1 and cass2.01.5 on test env,

回复:Can consistency-levels be different for "read" and "write" inDatastax Java-Driver?

2015-10-26 Thread qihuang.zheng
Using java driver, both read and write will transfer to Statement. We use PrepareStatement like this: public PreparedStatement getPrepareSTMT(String cql){ PreparedStatement statement = session.prepare(cql);

Re: Can consistency-levels be different for "read" and "write" in Datastax Java-Driver?

2015-10-26 Thread Jonathan Haddad
What's your query? Do you have IF NOT EXISTS in there? On Mon, Oct 26, 2015 at 11:17 AM Ajay Garg wrote: > Right now, I have setup "LOCAL QUORUM" as the consistency level in the > driver, but it seems that "SERIAL" is being used during writes, and I > consistently get

unsubscribe

2015-10-26 Thread Brian Tarbox
-- http://about.me/BrianTarbox

Re: Find partition row of Compacted partition maximum bytes

2015-10-26 Thread Tushar Agrawal
Toppartions provide the most active partitions. I am trying to do same thing. I was able to narrow down the largest partition by looking at warning in system.log. Given that I have the key, how to see the entire data for that key? Thanks, Tushar > On Oct 26, 2015, at 4:21 AM, DuyHai Doan

Re : Data restore to a new cluster

2015-10-26 Thread sai krishnam raju potturi
hi; we are working on a data backup and restore procedure to a new cluster. We are following the datastax documentation. It mentions a step "Restore the SSTable files snapshotted from the old cluster onto the new cluster using the same directories"

Can consistency-levels be different for "read" and "write" in Datastax Java-Driver?

2015-10-26 Thread Ajay Garg
Right now, I have setup "LOCAL QUORUM" as the consistency level in the driver, but it seems that "SERIAL" is being used during writes, and I consistently get this error of type :: *Cassandra timeout during write query at consistency SERIAL (3 replica were required but only 0 acknowledged the