DigestMismatchException after upgrade from c*-2.1.17 to c*-3.0.15

ava:79) > at java.lang.Thread.run(Thread.java:745) > No hints present /no mutation dropped, but still the above exception is thrown quite frequently. Could someone help us out in finding out the root cause. Thanks in advance TechPyaasa

Limit on number of connections to Cassandra

anks Techpyaasa

Re: Limit on having number of nodes in C* cluster

hundred nodes. I would rather run 5 100 node clusters than a single 500 node cluster. In theory, once you’ve built out the tooling to manage 2 clusters you should be able to apply it to manage 20 (reality always gets in the way though…) Jon On Aug 21, 2017, at 9:15 AM, techpyaasa . <t

Re: Limit on having number of nodes in C* cluster

;http://cassandra.apache.org/> > > Best regards, Vladimir Yudovin, > *Winguzone <https://winguzone.com?from=list> - Cloud Cassandra Hosting* > > > On Mon, 21 Aug 2017 08:35:37 -0400 *techpyaasa . > <techpya...@gmail.com <techpya...@gmail.com>>* wrote

Limit on having number of nodes in C* cluster

nted to clarify is there any limit/drawback having huge cluster/too many nodes in a c* cluster Thanks in advance TechPyaasa

How to have nested collections in UDF/UDA

pid=1; > test.groupbystatus(status) > ---- >{0: 2, 1: 3, 2: 1, 5: 1} In the same way I want to achieve Map> . How can I do the same ? Using c*-2.2.8 Thanks in advance TechPyaasa

Re: Help in c* Data modelling

BY (pid ASC); > I mean get all rows within same partition(account_id) whose status=0(say some value) using *UDF/UDA* in c* ? > > select group_by_status from test.user; where group_by_status is UDA/UDF Thanks in advance TechPyaasa On Sun, Jul 23, 2017 at 10:42 PM, Vladimir Yud

Re: Help in c* Data modelling

24x7.wm_current_status where > uid=1 order by dispName asc;* > You can use *in condition* on last partition key *status *in table > > *test.user_index.* > > > > *It depends on your use case and amount of data as well. It can be > optimized more...* > Thanks!! > > On Sun,

Help in c* Data modelling

ase let me know how can I achieve the same in cassandra(c*-2.1.17). I'm ok with applying indexes etc, Thanks TechPyaasa

Re: c* updates not getting reflected.

e: > What consistency are you using on those queries? > > On 11 Jul 2017 19:09, "techpyaasa ." <techpya...@gmail.com> wrote: > >> Hi, >> >> We have a table with following schema: >> >> CREATE TABLE ks1.cf1 ( pid bigint, cid bigint, resp_json

c* updates not getting reflected.

. And also is there any way to make sure that last UPDATE was success?? We are using c* - 2.1.17 , datastax java driver 2.1.18. Can someone point out what the issue is or anybody faced such strange issue? Any help is appreciated. Thanks in advance TechPyaasa

Re: UDF for sorting

he ability to modify rows ordering >> >> On Mon, Jul 3, 2017 at 10:14 PM, techpyaasa . <techpya...@gmail.com> >> wrote: >> >>> Hi all, >>> >>> I have a table like >>> >>> CREATE TABLE ks.cf ( pk1 bigint, cc1 bigint, disp_name tex

UDF for sorting

k1=123 and cc1=345;* and *select * from ks.cf <http://ks.cf> where pk1=123 and status=1;* In this case , I want rows to be sorted based on 'disp_name' (asc/desc) . Can I achieve the same using UDF or anything else ?? (Sorry If my understanding about UDF is wrong). Thanks in advance TechPyaasa

Re: Secondary Index

will > eventually get a hit cause index rebuilding is expensive operation on CPU > .. > > > > See please http://docs.datastax.com/en/cql/3.1/cql/ddl/ddl_when_use_ > index_c.html > > > > > > > > *From:* techpyaasa . [mailto:techpya...@gmail.c

Best practice to add(bootstrap) multiple nodes to cluster at once

Hi, What is the best practice to add(bootstrap) multiple nodes at once to c* cluster. Using c*-2.1.17 , 2 DCs , 3 groups in each DC Thanks TechPyaasa

Re: Secondary Index

ntial situation by leveraging composite key, if > that is possible for you? > > > > > > *From:* techpyaasa . [mailto:techpya...@gmail.com] > *Sent:* Monday, June 19, 2017 1:01 PM > *To:* user@cassandra.apache.org > *Subject:* Secondary Index > > > > Hi, > > I want

Secondary Index

time it would take for this process? Thanks in advance, TechPyaasa

Re: Huge Batches

gt; <https://www.slideshare.net/planetcassandra/cassandra-summit-2014-lesser-known-features-of-cassandra-21> > > > Cheers, > Justin > > On Thu, 8 Jun 2017 at 18:49 techpyaasa . <techpya...@gmail.com> wrote: > >> Hi , >> >> Recently we are seeing hug

Huge Batches

reshold, size - warnThreshold);* *}* *}* Thanks TechPyaasa

Re: How to find dataSize at client side?

Hi Nicolas I think only DataStax Enterprise(paid) c* version can ask questions/get support from datastax :( On Tue, May 23, 2017 at 9:44 PM, techpyaasa . <techpya...@gmail.com> wrote: > Thanks for your reply.. > > On Tue, May 23, 2017 at 7:40 PM, Nicolas Guyomar < > nico

How to find dataSize at client side?

to restrict inserts at client side by calculating *dataSize* of insert/batch statements before sending it to c* servers. We are using datastax java drivers , how can I get dataSize here?? Any ideas?? Thanks in advance TechPyaasa

Re: Slow performance after upgrading from 2.0.9 to 2.1.11

TechPyaasa On Wed, Nov 9, 2016 at 1:28 AM, Dikang Gu <dikan...@gmail.com> wrote: > Michael, thanks for the info. It sounds to me a very serious performance > regression. :( > > On Tue, Nov 8, 2016 at 11:39 AM, Michael Kjellman < > mkjell...@internalcircle.com> wrote: &g

Re: Disk full during new node bootstrap

6 AM, Jonathan Haddad <j...@jonhaddad.com> >> wrote: >> >> Are you using the same number of tokens on the new node as the old ones? >> >> On Fri, Feb 3, 2017 at 8:31 PM techpyaasa . <techpya...@gmail.com> wrote: >> >> Hi, >> >> We are

Disk full during new node bootstrap

to which it is added) OR Boootstrap/add 2(multiple nodes) at a time? Please suggest better way to fix this. Thanks in advance Techpyaasa

Re: How to change Replication Strategy and RF

Thanks a lot kurt Greaves On Fri, Dec 30, 2016 at 5:58 AM, kurt Greaves wrote: > > ​If you're already using the cluster in production and require no downtime > you should perform a datacenter migration first to change the RF to 3. > Rough process would be as follows: > >

How to change Replication Strategy and RF

nter to this cluster. Can someone please suggest *safest* way to do so. Thanks in advance, Techpyaasa

Re: OperationTimedOutException (NoHostAvailableException)

u should try? > > > > Is there anything in the logs on the 3 cassandra boxes listed > (192.168.198.168, 192.168.198.169, 192.168.198.75) that indicates they had > problems at that time, perhaps GCInspector or StatusLogger messages about > pauses, or any drops in network

OperationTimedOutException (NoHostAvailableException)

jar. In cassandra.yaml following were set rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4 This exception thrown for both READ & WRITE queries. Can someone please help me out in debugging things? Thanks Techpyaasa

Re: NoHostAvailableException

ive > port 9042 open in firewall (if there is one). > Can you connect to cluster with cqlsh? > > Best regards, Vladimir Yudovin, > > *Winguzone <https://winguzone.com?from=list> - Hosted Cloud > CassandraLaunch your cluster in minutes.* > > > On Mon, 21 N

Re: NoHostAvailableException

to other Cassandra nodes* *# Leaving this blank will set it to the same value as listen_address* *# broadcast_address: 1.2.3.4 #It is commented, I have not made any changes for itrpc_address: 0.0.0.0* *rpc_port: 9160* Thanks TechPyaasa On Mon, Nov 21, 2016 at 6:48 PM, Vladimir Yudovin <

Re: NoHostAvailableException

oadcast_rpc_address* on each node to its real external IP > address. > > Best regards, Vladimir Yudovin, > > *Winguzone <https://winguzone.com?from=list> - Hosted Cloud > CassandraLaunch your cluster in minutes.* > > > On Mon, 21 Nov 2016 05:47:00 -0500*techpy

NoHostAvailableException

nks in advance Techpyaasa.

UDF/UDA for json data aggregation

2"}}');"* Using UDF/UDA , I want attributes values of json data to be aggregated something like below *"select json_aggr(jsonData) from test; //SUM* *{"node1":{"attr1":"130","attr2":"61","attr3":"611"},"node2":{"attr4":"4.13","attr5":"6.772","attr6":"6.344"}}"* //130=91+22+17 etc., Can we do something like this , can we import java classes from thirdparty jars for parsing/updating json in UDF defined? And how? Can somebody please provide outline code for this? Thanks, Techpyaasa

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

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

Can nodes in c* cluster run different versions ?

be there any possibility during this mismatch of c* version among nodes in cluster during this upgrade process? Thanks Techpyaasa

Re: Cannot set TTL in COPY command

( :( > > On Wed, Oct 26, 2016 at 8:53 PM, Lahiru Gamathige <lah...@highfive.com> > wrote: > >> You have to use with default_time_to_live = 7200. >> >> On Wed, Oct 26, 2016 at 8:07 AM, techpyaasa . <techpya...@gmail.com> >> wrote: >> >>&

Cannot set TTL in COPY command

keyspace1.columnFamily1 FROM 'dump_data.csv' WITH TTL = '7200';* Version is as below *[cqlsh 4.1.1 | Cassandra 2.0.17 | CQL spec 3.1.1 | Thrift protocol 19.39.0]* Can some one please tell me how to set TTL using COPY command? Thanks Techpyaasa

Difference in token range count

space keyspace_name1" The count of ranges , it is supposed to be *2304*(256*9) as we have 9 nodes in one data center right but why it is showing as 2647 ranges ?? Can someone please clarify why this difference in token ranges count? Thanks techpyaasa

Re: New node block in autobootstrap

Forgot to set replication for new data center :( On Wed, Sep 28, 2016 at 11:33 PM, Jonathan Haddad <j...@jonhaddad.com> wrote: > What was the reason? > > On Wed, Sep 28, 2016 at 9:58 AM techpyaasa . <techpya...@gmail.com> wrote: > >> Very sorry...I got the rea

Re: New node block in autobootstrap

Very sorry...I got the reason for this issue.. Please ignore. On Wed, Sep 28, 2016 at 10:14 PM, techpyaasa . <techpya...@gmail.com> wrote: > @Paulo > > We have done changes as you said > net.ipv4.tcp_keepalive_time=60 > net.ipv4.tcp_keepalive_probes=3 > net.ipv

Re: New node block in autobootstrap

@Paulo We have done changes as you said net.ipv4.tcp_keepalive_time=60 net.ipv4.tcp_keepalive_probes=3 net.ipv4.tcp_keepalive_intvl=10 and increased streaming_socket_timeout_in_ms to 48 hours , "phi_convict_threshold : 9". And once again recommissioned new data center (DC3) , ran " nodetool

nodetool rebuild streaming exception

-to-reduce-the-impact-of-streaming-errors-or-failures and ran 'nodetool rebuild' one node at a time but was of NO USE . Still we are getting above exception. Can someone please help me in debugging and fixing this. Thanks, techpyaasa