Re: Long joining node

What's your average data per node? Is 230gb close? All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png] [image: facebook.png]

Seeing wierd exceptions

Hi, In 2 of our clusters running 2.0.14 version we are seeing following exception, 15-08-05 16:11:32,723 [FlushWriter:268358] ERRORCassandraDaemon Exception in thread Thread[FlushWriter:268358,5,main]FSReadError in/opt/cassandra/data/ks1/cf1/ks1-cf1-jb-231142-Index.db     atorg.apache.cassa

Re: only grant select , but still can modify data

Did you set your authorizer correctly? http://docs.datastax.com/en/cassandra/1.2/cassandra/security/secure_config_native_authorize_t.html -Russ From: Dan Jatnieks Reply-To: Date: Wednesday, August 5, 2015 at 5:03 PM To: Subject: Re: only grant select , but still can modify data Hi Rock,

Re: only grant select , but still can modify data

Hi Rock, I was not able to reproduce this problem using C* 2.2 and DevCenter 1.4. What versions are you using? Did you check that the DevCenter connection properties are using the "readonly" account and that any existing connection was closed and re-opened? Did you get the expected result with cql

Re: TTLs on tables with *only* primary keys?

Thanks. This is what I was looking for… I ended up working around this by using a boolean field as a column. Wastes a bit of space but its not the end of the world. On Wed, Aug 5, 2015 at 7:33 AM, Tyler Hobbs wrote: > You can set the TTL on a row when you create it using an INSERT > statement.

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

ok, I fixed my issue by making sure that the total chunk I read in is equaled the total size of the file. Using Bytes.getArray(bytebuff) to write out and my total file read and write is now the same size. Thanks, Noah On Monday, September 22, 2014 at 6:50:51 AM UTC-4, Carlos Scheidecker wro

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

Carlos, I am having the same issue as you. I used below: for (Row row : rs) { bytebuff=row.getBytes("data"); byte data[]; data=Bytes.getArray(bytebuff); out.write(data); Did you ever find the answer for this? Thanks, Noah On Monday, September 22, 2014 at 6:50:51 AM UTC-4,

Re: auto_bootstrap=false broken?

On Wed, Aug 5, 2015 at 2:08 AM, horschi wrote: > So what I am trying to say is: Everytime you use auto_bootstrap=false, you > are entering a dangerous path. And I think this could be fixed, if > auto_bootstrap=false would leave the node in a write-only state. Then the > operator could still decid

Re: Retrieve all the columnfamily / tables of thrift and CQL from the keyspace in cassandra

+1. The project hasn't had a single relevant commit in almost a full year and is now officially unsupported. Migrate your data asap to CQL. On Wed, Aug 5, 2015 at 9:05 AM Alain RODRIGUEZ wrote: > Hi > > "I use hector" --> This is a very bad idea imho, even more while using C* > 2.1. > > Hecto

Re: Retrieve all the columnfamily / tables of thrift and CQL from the keyspace in cassandra

Hi "I use hector" --> This is a very bad idea imho, even more while using C* 2.1. Hector is not maintained for a while and it uses the thrift protocol that allow accessing to limited features with worst performances than native / cql. See http://www.datastax.com/dev/blog/cassandra-2-1-now-over-5

Re: cassandra cluster loadbalancing

Hi Sara, I am not sure why you say that this is unbalanced, such small amounts of data are not relevant. It depends of too much factors (keys inserted, compaction that ran or are to run...) You should use "nodetool status *myks*" to see if your tokens are well distributed - column "Owns (effectiv

Re: TTLs on tables with *only* primary keys?

You can set the TTL on a row when you create it using an INSERT statement. For example: INSERT INTO mytable (partitionkey, clusteringkey) VALUES (0, 0) USING TTL 100; However, Cassandra doesn't support the ttl() function on primary key columns yet. The ticket to support this is https://issues.ap

Re: Status of OPSC-4080 ?

Cyril, That ticket should be fixed in the latest 5.2 series of OpsCenter. The fix did not make it into the 5.1 release series unfortunately. -Nick On Wed, Aug 5, 2015 at 3:44 AM, Cyril Scetbon wrote: > Hi guys, > > I've seen at http://stackoverflow.com/a/27417153/2354384 that Arre said > on De

Re: Long joining node

I set the stream timeout to 1 hour this morning and started fresh trying to join this node. It took about an hour to stream over 230gb of data, and then into hour 2 I wound up back where I was yesterday, the node's load is slowly reducing and the netstats does not show sending or receiving anythin

cassandra cluster loadbalancing

hello there, Can you tell me please how can I loadbalance my canssandra cluster. When I do nodetool status I can see that the load is not loadbalanced among my cassandra nodes Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Loa

Re: Cassandra: UDF

Suresh, tip: you can use alternative (”pg-style”) string delimiters, which can span over multiple lines and makes the CQL statement much nicer: CREATE OR REPLACE FUNCTION state_groupbyandsum ( state map, datetime text, amount text ) CALLED ON NULL INPUT RETURNS map LANGUAGE java AS $$

Cassandra: UDF

Hi, I need your help. I have a query which get top 5 records group by date (not date + time) and sum of amount. I wrote the following but it returns all the records not just top 5 records CREATE OR REPLACE FUNCTION state_groupbyandsum( state map, datetime text, amount text ) CALLED ON NULL INPUT

Re: auto_bootstrap=false broken?

Hi Rob, let me try to give examples why auto_bootstrap=false is dangerous: I just yesterday had the issue that we wanted to set up a new DC: Unfortunetaly we had one application that used CL.ONE (because its only querying static data and its read heavy). That application stopped working after we

Status of OPSC-4080 ?

Hi guys, I've seen at http://stackoverflow.com/a/27417153/2354384 that Arre said on December 14th 2014 that hopefully it would be fixed in next 5.1.x. However it seems it hasn't been fixed yet. Any more information on the status of this ticket ? Th

Re: Cassandra Data Stax java driver & Snappy Compression library

I’ve never used Astyanax, so it’s difficult to say, but if you can find the snappy-java in the classpath, it’s quite possible that compression is enabled for S1 and S2 automatically. You could try removing the snappy jar from S1 and see if that changes the latencies compared to S2. ;-) It proba