[Cassandra 3.0.9 ] Disable “delete/Truncate/Drop”

Hi all, There is any way to disable “delete/Truncate/Drop” command on Cassandra? If yes then how we can implement this? Thanks & Regards, Abhishek Kumar Maheshwari +91- 805591 (Mobile) Times Internet Ltd. | A Times of India Group Company FC - 6, Sector 16A, Film City, Noida, U.P. 201301 |

Copy from CSV on OS X problem with varint values <= -2^63

On Apr 4, 2017, at 7:00 PM, Boris Babic wrote: Hi I’m testing the write of various datatypes on OS X for fun running cassandra 3.10 on a single laptop instance, and from what i can see varint should map to java.math.BigInteger and have no problems with Long.MIN_VALE , -9223372036854775808, b

Re: [Cassandra 3.0.9 ] Disable “delete/Truncate/Drop”

Hi Abhishek, You can restrict commands a user can issue by enabling authentication & authorization, then authorizing concerned user with appropriate privileges. For reference : http://cassandra.apache.org/doc/latest/cql/security.html Thanks, Bhuvan On Tue, Apr 4, 2017 at 1:58 PM, Abhishek Kumar

Re: [Cassandra 3.0.9 ] Disable “delete/Truncate/Drop”

Hi Abhishek, Truncate is very much a part of CQL and it does exactly what the name suggests i.e truncating/deleting all the rows of the table. TRUNCATE sends a JMX command to all nodes, telling them to delete SSTables that hold the data from the specified table. If any of these nodes is down or d

Re: Copy from CSV on OS X problem with varint values <= -2^63

I've reproduced the same problem on Linux, and I've opened CASSANDRA-13408 . As a workaround, disable prepared statements and it will work (WITH HEADER = TRUE AND PREPAREDSTATEMENTS = False). On Tue, Apr 4, 2017 at 5:02 PM, Boris Babic wrote:

Re: Copy from CSV on OS X problem with varint values <= -2^63

Thanks Stefania, going from memory don't think I noticed this on windows but haven't got a machine handy to test it on at the moment. > On Apr 4, 2017, at 19:44, Stefania Alborghetti > wrote: > > I've reproduced the same problem on Linux, and I've opened CASSANDRA-13408. > As a workaround, d

Re: Node Gossiping Information.

@Jeff thanks for your reply, What i am trying to find is where Gossip data will be stored on, which Keyspace ?? The nodes will Gossip at the time of their start or will get Gossiping Data from seed nodes, What i wanted to do is can we refresh the Gossiping Data with out restarting service, I ofte

upgrade to Cassandra 3.0.12

I've recently upgraded to 3.0.12 and unable to run CQLSH. No appropriate python interpreter found. The current python version installed is 2.6.6. I realize I need to upgrade to 2.7.12 at least, but I also cannot remove the 2.6.6 version. Are there any recommendations for installing a newer version

Re: upgrade to Cassandra 3.0.12

Multiple versions of python can coexist, the cqlsh shell script will attempt to execute via a python2.7 executable if it finds one. On Tue, Apr 4, 2017 at 9:49 AM, Jacob Shadix wrote: > I've recently upgraded to 3.0.12 and unable to run CQLSH. > No appropriate python interpreter found. > > The c

Re: upgrade to Cassandra 3.0.12

Hi Jacob, if you use RHEL/Centos, this article in Datastax Help Center explains how to solve the issue: https://support.datastax.com/hc/en-us/articles/115000180726--No-appropriate-python-interpreter-found-when-running-cqlsh Kind regards, 2017-04-04 17:22 GMT+02:00 Voytek Jarnot : > Multiple ver

Re: Node Gossiping Information.

Cassandra uses system.peers to record the list of peers for subsequent startups, but gossip state is only in memory You shouldn't ever manually need to disable/re-enable gossip unless you want the rest of the ring to believe a node went offline/online. What version are you using? On Tue, Apr 4,

Re: upgrade to Cassandra 3.0.12

I installed 2.7 and updated PYTHONPATH, but it is still not finding the newer version. -- Jacob Shadix On Tue, Apr 4, 2017 at 11:22 AM, Voytek Jarnot wrote: > Multiple versions of python can coexist, the cqlsh shell script will > attempt to execute via a python2.7 executable if it finds one. >

Re: Effective partition key for time series data, which allows range queries?

The typical recommendation for maximum partition size is on the order of 100mb and/or 100,000 rows. That's not a hard limit, but you may be setting yourself up for issues as you approach or exceed those numbers. If you need to reduce partition size, the typical way to do this is by "bucketing," th

Re: cassandra OOM

Thanks, that’s interesting – so CMS is a better option for stability/performance? We’ll try this out in our cluster. From: Alexander Dejanovski Reply-To: "user@cassandra.apache.org" Date: Monday, April 3, 2017 at 10:31 PM To: "user@cassandra.apache.org" Subject: Re: cassandra OOM Hi, we've s

Re: Copy from CSV on OS X problem with varint values <= -2^63

You are welcome. I traced the problem to a commit of the Python driver that shipped in version 3.8 of the driver. It is fixed in 3.8.1. More details on CASSANDRA-13408 . I don't think it's related to the OS. Since Cassandra 3.10 ships with an