Re: UDF/UDA for json data aggregation

"Can we do something like this" --> Yes but requires a lot of coding "can we import java classes from thirdparty jars for parsing/updating json in UDF defined" --> No because the reasoning behind this limitation is: IF you need to import third-party jars for your UDF/UDA, it means that the

UDF/UDA for json data aggregation

Hi all, Like to use UDF/UDA in c*-2.2 & above to aggregate attibutes values in a json data. For example below table. *"CREATE TABLE test ( id bigint , time1 bigint , jsonData text , PRIMARY KEY(id,time1));* *cqlsh:test> INSERT INTO test (id , time1 , jsonData ) VALUES ( 1, 123,

Clarify Support for 2.2 on Download Page

Hi, is it possible to update the language on the Apache Cassandra Download page to reflect that version 2.2 will enter Critical Fix Only support after November 21st? The current language creates quite a bit of confusion in the community with how long 2.2 and 2.1 will receive fixes from the

Re: Can nodes in c* cluster run different versions ?

Thank you @Alain On Wed, Nov 16, 2016 at 9:13 PM, Alain RODRIGUEZ wrote: > Hey Techpyaasa, > > Are you aware of this documentation? > > https://docs.datastax.com/en/upgrade/doc/upgrade/cassandra/ > upgrdCassandraDetails.html > > Basically yes, you can have multiple versions,

[RELEASE] Apache Cassandra 3.0.10 released

The Cassandra team is pleased to announce the release of Apache Cassandra version 3.0.10. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of source

Re: Cassandra Node Restart Stuck in STARTING?

We're on Cassandra 3.7, running on Ubuntu 14.04. In terms of system utilization, we saw one Cassandra process which was using 100% CPU, but overall load was very low on the box. Disk utilization was largely nominal. On Wed, Nov 16, 2016 at 2:19 PM, Jeff Jirsa wrote:

Re: Cassandra Node Restart Stuck in STARTING?

What version? Is the system doing anything (do you see high CPU / disk usage)? Sometimes restarts will trigger some changes to files on disk that are mostly invisible in the logs (https://issues.apache.org/jira/browse/CASSANDRA-11163 for example), but it’s usually during a different part

Re: Cassandra Node Restart Stuck in STARTING?

Attaching the system.log can give more details ... On 16 November 2016 at 11:05, Daniel Subak wrote: > Hey everyone, > > Ran into an issue running a node restart where "nodetool netstats" > reported the node as "STARTING" with no streams when run locally. "nodetool >

Cassandra Node Restart Stuck in STARTING?

Hey everyone, Ran into an issue running a node restart where "nodetool netstats" reported the node as "STARTING" with no streams when run locally. "nodetool status" run on other nodes reported that node as "DN". Both of those were expected. However, tailing the logs, there didn't seem to be

Re: Tomstones impact on repairs both anti-entropy and read repair

Hi, > My question to the community is will tombstone cause issues in data > consistency across the DCs. It might, if your repairs are not succeeding for some reason or not running fully (all the token ranges) within gc_grace_second (parameter at the table level) I wrote a blog post and talked

Re: Can nodes in c* cluster run different versions ?

Hey Techpyaasa, Are you aware of this documentation? https://docs.datastax.com/en/upgrade/doc/upgrade/cassandra/upgrdCassandraDetails.html Basically yes, you can have multiple versions, but you want to make this multi-version time it as short as possible. As it might take few days as it will

Re: Some questions to updating and tombstone

Hi Boying, Old value is not tombstone, but remains until compaction Be careful, the above is generally true but not necessary. Tombstones can actually be generated while using update in some corner cases. Using collections or prepared statements. I wrote a detailed blog post about deletes and

Can nodes in c* cluster run different versions ?

Hi all, We are currently running c*-2.0.17 with 2 datacenters each with 18 nodes. We like to upgrade to c*-2.1.16. Can we upgrade first all nodes(one by one) in one dc and then go to next data center. As it might take few days as it will have 'upgrade sstables' , so just wanted to know would be

Re: Some questions to updating and tombstone

Hi Fabrice, Just a small (out of the topic) question I couldn't find an answer to. What is a slice in Cassandra? (e.g. Maximum tombstones per slice) Thanks! Shalom Sagges DBA T: +972-74-700-4035

Does recovery continue after truncating a table?

Hi, I could find stale data after truncating a table. It seems that truncating starts while recovery is being executed just after a node restarts. After the truncating finishes, recovery still continues? Is it expected? I use C* 2.2.8 and can reproduce it as below. [create table]

Re: Too High resident memory of cassandra 2.2.8

Hi Jeff, I used below command to findout total off heap. bin/nodetool cfstats | grep 'Off heap memory used' | cut -d ":" -f2 | awk '{sum+=$1} END{print sum}' *1417134538* As per your suggestion, it is around 1GB only. we have around 50 tables and 2 column family but still it doesn't make