Re: Unsubscribe

Omar, Send an empty email to user-unsubscr...@cassandra.apache.org to unsubscribe. See you On Wed, Oct 12, 2016 at 1:33 PM, Omar Mambelli wrote: > Unsubscribe > > -- > Inviato da iPhone >

unsubscrible

Best regards, Steven Zhao

Re: unsubscrible

Steven, Send an empty email to user-unsubscr...@cassandra.apache.org to unsubscribe. See you On Wed, Oct 12, 2016 at 8:15 PM, zhao yi wrote: > > > Best regards, > > Steven Zhao > >

Re: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

Hi Leena, First thing you should be concerned about is : Why the repair -pr operation doesnt complete ? Second comes the question : Which repair option is best? One probable cause of stuck repairs is : if the firewall between DCs is closing TCP connections and Cassandra is trying to use such

Inserting list data

Hi, When inserting different data into a list type column from different clients at the same time, is data supposed to be combined into one list? For example, if these 2 queries were requested from clients at the same timing, how events list should look like after? INSERT INTO

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

Well 1) I have not sent it to postgresql mailing lists 2) I thought this is an open ended question as it can involve ideas from everywhere including the Cassandra java driver mailing lists so sorry If that bothered you for some reason. On Wed, Oct 12, 2016 at 1:41 AM, Dorian Hoxha

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

Also, I'm not sure, but I don't think it's "cool" to write to multiple lists in the same message. (based on postgresql mailing lists rules). Example I'm not subscribed to those, and now the messages are separated. On Wed, Oct 12, 2016 at 10:37 AM, Dorian Hoxha wrote: >

Run sstablescrub in parallel

Hello, Is there any way to run sstablescrub on one CF in parallel? Thanks! -- Oleg Krayushkin

Unsubscribe

Unsubscribe -- Inviato da iPhone

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

There are some issues working on larger partitions. Hbase doesn't do what you say! You have also to be carefull on hbase not to create large rows! But since they are globally-sorted, you can easily sort between them and create small rows. In my opinion, cassandra people are wrong, in that they

Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

Hi All, I understand Cassandra can have a maximum of 2B rows per partition but in practice some people seem to suggest the magic number is 100K. why not create another partition/rowkey automatically (whenever we reach a safe limit that we consider would be efficient) with auto increment bigint

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

I did mention this in my previous email. This is not time series data. I understand how to structure it if it is a time series data/ What do you mean globally sorted? you mean keeping every partition sorted (since I come from Casandra world)? rowkey 1 -> blob page -> int or long or bigint col1

Re: Run sstablescrub in parallel

On Wed, Oct 12, 2016 at 2:38 AM, Oleg Krayushkin wrote: > Is there any way to run sstablescrub on one CF in parallel? I don't think so, but you can use `nodetool scrub' which has concurrency. If you need to do this "offline" you can use `nodetool disable{thrift,binary}` to

Re: Gossip status: hibernate

1. A hibernating node is participating in gossip but intentionally hasn't yet joined the ring. The two cases where a node would set a hibernating status are when the node was started with "-Dcassandra.join_ring=False" and has tokens or when the node was started to replace another node (using

Gossip status: hibernate

Hi, I've recently upgraded our Cassandra cluster from 2.1 to 3.9. By default(?) 3.9 creates a debug.log file containing a ton of lines (a new one every second) with: DEBUG [GossipTasks:1] 2016-10-12 14:43:38,761 Gossiper.java:337 - > Convicting /172.31.137.65 with status hibernate - alive false

Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

Please advice. Cannot find any clear documentation on what is the best strategy for repairing nodes on a regular basis with multiple datacenters involved. We are running cassandra 3.7 in multi datacenter with 4 nodes in each data center. We are trying to run repairs every other night to keep

WARN [SharedPool-Worker-3] AbstractTracingAwareExecutorService.java

I am seeing following warn in system.log, as a temporary turn around i can increase commitlog_size in cassandra.yaml to 64, but how can i trace it down ??? which appilcation is trying to write large writes and to which keyspace and table it is trying to write ?? WARN [SharedPool-Worker-3]

Re: JConsole Support for SSL in C* 2.0

Hi, I didn't try, but I guess it's possible. Look at conf/cassandra-env.sh in latest versions: JVM_OPTS="$JVM_OPTS -Dcom.sun.management.jmxremote.ssl=false" # JVM_OPTS="$JVM_OPTS -Djavax.net.ssl.keyStore=/path/to/keystore" # JVM_OPTS="$JVM_OPTS

JConsole Support for SSL in C* 2.0

Hi All, I was looking through the documentation of Security in C* 2.0, I noticed that there is no such mention of Jconsole over SSL whereas in latest 3.x doc, I can spot that : http://docs.datastax.com/en/cassandra_win/3.0/cassandra/configuration/secureJconsoleSSL.html so what I can infer

Re: Multiple Network Interfaces in non-EC2

Hi Amir, I would like to understand your requirement first. Why do you need multiface interface configuration mentioned at http://docs.datastax.com/en/cassandra/3.x/cassandra/configuration/configMultiNetworks.html with single DC setup? As per my understanding, you could simply set listen

RE: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

The default repair process doesn't usually work at scale, unfortunately. Depending on your data size, you have the following options. Netflix Tickler: https://github.com/ckalantzis/cassTickler (Read at CL.ALL via CQL continuously :: Python) Spotify Reaper:

Re: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

In my experience dc local repair node by node with Pr and par options is best .full repair increased sstables A lot and take days to compact it back or another Easy option for repair is use a spark job ,read all data with Consistency all and increase read repair chance to 100 % or use Netflix

VNode Streaming Math

Hello, Suppose I have a 100 node ring, with num_tokens=32 (thus, 32 VNodes per physical machine). Assume this cluster has just one keyspace having one table. There are 10 SS Tables on each node, and size on disk is 10GB on each node. For simplicity, assume each SSTable is 1GB. Now, a node

Re: [Marketing Mail] Re: [Marketing Mail] Re: sstableloader question

Hello, It's about 2500 sstables worth 25TB of data. -t parameter doesn't change -t 1000 and -t 1 Most probably I face some limitation at target cluster. I'm preparing to split sstables and run up to ten parallel sstableloader sessions. Regards, Osman On 11-10-2016 21:46, Rajath Subramanyam

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

The "2 billion column limit" press clipping "puffery". This statement seemingly became popular because highly traffic traffic-ed story, in which a tech reporter embellished on a statement to make a splashy article. The effect is something like this:

RE: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

Agree. However, if we go from a world where repairs don’t run (or run very unreliably so C* can’t mark the SSTables as repaired anyways) to a world where repairs run more reliably (Spark / Tickler approach) – the impact on tombstone removal doesn’t become any worse (because SS Tables aren’t

corrupted gossip generation

*Env: * apache cassandra 2.1.8, 6-nodes *Problem: *one node had kernel panic and crashed twice this morning. seems gossip generation was messed up. all nodes are flooded with "received an invalid gossip generation for peer" warning messages. multiple rolling restarts only fixed "nodetool

Re: Repair in Multi Datacenter - Should you use -dc Datacenter repair or repair with -pr

Note that the tickle approach doesn’t mark sstables as repaired (it’s a simpler version of mutation based repair in a sense), so Cassandra has no way to prove that the data has been repaired. With tickets like https://issues.apache.org/jira/browse/CASSANDRA-6434, this has implications on

Re: VNode Streaming Math

Hi, Calculation in general is very simple - each node keeps replication_factor/number_of_nodes part of data (number of replicas is spread over all nodes). I.e. If you have 100 nodes and replication factor is three each node keeps 0.03 of table size. But you can go even with more simple

Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Hi All, I faced issue with triggers today. Below is the clear description of the issue: 1) When we planned to use triggers, we placed the triggers.jar file in /conf/triggers folder in Cassandra, restarted the Cassandra service and created a trigger in CQLSH. Everything was working good as

Re: Inserting list data

yes, that's what I thought. but, when I use these forms, INSERT ... ['A'] INSERT ... ['B'] The data is actually appended. not overwritten. so I guess this is something unexpected? Thanks, Aoi 2016-10-12 20:55 GMT-07:00 Vladimir Yudovin : > If you use form > INSERT ...

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Hi, where can I change that default location /tmp/lib it is using for creating the jar files? Cassandra uses Java property java.io.tmpdir as temporary folder. By default it's /tmp but can be changed with command line arguments: cassandra -Djava.io.tmpdir=/path/to/tmpdir Best regards,

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Appreciate your reply Vladimir! Is this the configuration I need to include in Cassandra-env.sh file? Regards Sudheer On Thursday, October 13, 2016, Vladimir Yudovin wrote: > Hi, > > where can I change that default location /tmp/lib it is using for creating > the jar

Re: Inserting list data

The data is actually appended. not overwritten. Strange, can you send exactly operators? Here is example I do: CREATE KEYSPACE events WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1}; CREATE TABLE events.data (id int primary key, events listtext); INSERT INTO

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Yes, pass this argument to bin/cassandra script: bin/cassandra -Djava.io.tmpdir=/path/to/tmpdir Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Thu, 13 Oct 2016 00:36:35 -0400sudheer k

Re: Inserting list data

If you use form INSERT ... ['A'] INSERT ... ['B'] latest INSERT will overwrite first, because this insert the whole list. It's better to use UPDATE like: UPDATE ... SET events = events + ['A'] UPDATE ... SET events = events + ['B'] These operations add new elements to the end of existing

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Sorry for the confusion. I didn't see that command line arguments you told in the mail. So, this arguments needs to be passed when I start Cassandra? Regards Sudheer On Thursday, October 13, 2016, sudheer k wrote: > Appreciate your reply Vladimir! Is this the

Re: Cassandra Triggers - Cassandra internally creating trigger.jar files in /tmp/lib/ directory

Thanks Vladimir!! I did that and it's working good now. It is taking new location when I reloadtriggers. Really appreciate your support! Regards Sudheer On Thursday, October 13, 2016, Vladimir Yudovin wrote: > Yes, pass this argument to bin/cassandra script: >