Truncate Table - What happens to indexes?

What happens to indexes when a table is truncated? Indexes are removed or they stay around? Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This e-mail and the information, inc

RE: Cassandra Data Model design

you create a table. Rahul Gupta From: Check Peck [mailto:comptechge...@gmail.com] Sent: Wednesday, September 17, 2014 4:01 PM To: user Subject: Cassandra Data Model design I have recently started working with Cassandra. We have cassandra cluster which is using DSE 4.0 version and has VNODES

RE: Host ID collision making node disappear

all existing Cassandra nodes. Thanks, Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This e-mail and the information, including any attachments, it contains are intend

RE: Cassandra bootstrap error: java.lang.IllegalStateException: No sources found

That is the issue. Thanks..!! The new node runs Spark work load so I changed seed ip to the newly added node’s IP. Same with listen address. Only common link between Cassandra nodes and Spark nodes is the cluster name. Change seed IP fixed the issue. Thanks, Rahul Gupta DEKA Research

Cassandra bootstrap error: java.lang.IllegalStateException: No sources found

Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This e-mail and the information, including any attachments, it contains are intended to be a confidential communication only to the

Host ID collision making node disappear

52864 172.17.3.3 rack1 Up Normal 18.77 GB33.33% 141784319550391026443072753096570088106 Thanks, Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This

NULL in CQL

s as valid data so that's conflicting with fillers I have to use instead of NULL. Please advise. Thanks, Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666.3908 extn. 6504 | C: 603.718.9676 This e-mail and the in

How to find last inserted value using CQL3

= 'myevent' ORDER BY "eventTime" DESC; This returns bunch of events and their writetime, how to get last (or max) writetime using CQL? Thanks, Rahul Gupta This e-mail and the information, including any attachments, it contains are intended to b

Recommendation for hosting multi tenant clusters

ional recovery options Given Cassandra is designed to survive failures, combining replication factor 3 and backing-up to S3, I think should be enough for back up. Please advise. Thanks, Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchest

RE: Any good GUI based tool to manage data in Casandra?

Hello, Is there backward compatibility planned for DataStax DevCenter. I am using DSE 3.0.1 and Cassandra 1.1.9.7 Currently no plan to upgrade to C* 1.2. Thanks, Rahul Gupta DEKA Research & Development<http://www.dekaresearch.com/> 340 Commercial St Manchester, NH 03101 P: 603.666

Unable to describe table in CQL 3

icate_on_write='true' AND compaction_strategy_class='SizeTieredCompactionStrategy' AND compression_parameters:sstable_compression='SnappyCompressor'; Any ideas why CQL3 won't display Composite columns? What should be done to make them compatible? Thanks, Rahul Gu

RE: InvalidRequestException(why:Not enough bytes to read value of component 0)

Thank You. Your solution worked...!! Changed below line: HCounterColumn hColumn_ts = HFactory.createCounterColumn(ts.toString(), value, StringSerializer.get()); To this: HCounterColumn hColumn_tsCG = HFactory.createCounterColumn(tsCG, value, CompositeSerializer.get()); Rahul Gupta This e-mail

InvalidRequestException(why:Not enough bytes to read value of component 0)

HInvalidRequestException: InvalidRequestException(why:Not enough bytes to read value of component 0) Rahul Gupta This e-mail and the information, including any attachments, it contains are intended to be a confidential communication only to the person or entity to whom it is addressed and may