Cassandra 1.1.4 RPM required

Hi, I would like to install Apache Cassandra 1.1.4 from RPM. Please share a link to download rpm for CentOS (x86_64) and (i386). -- Thanks & Regards *Adeel**Akbar*

Re: Facing problem while configuring key and row cache

Answered in the other email as well, cache stats are in nodetool info. But you also have to set the "caching" property of the CF. By default it's keys_only. It should be documented in the cassanra-cli and the CQL docs http://www.datastax.com/docs/1.1/references/cql/index cheers --

Re: nodetool repair - when is it not needed ?

HH works to a point. Specifically, it only collects hints for the first hour the node is down and it has a safety valve to avoid the node collecting hints getting overwhelmed. Looking at the code it takes a bit for that the trip and you would get a TimeoutException coming back. Also when hints

Re: Deleting a row from a counter CF

I would guess that Pelops has called remove() on the Thrift API rather than remove_counter(). Check the code in Pelops. If you turn server side logging up to DEBUG it will log "remove" for the non counter call and "remove_counter" for the counter one. Cheers - Aaron Morton Fr

Re: Cassandra 1.1.4 RPM required

See step 1 here http://wiki.apache.org/cassandra/GettingStarted Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 7:40 PM, Adeel Akbar wrote: > Hi, > > I would like to install Apache Cassandra 1.1.4 from RPM. Please share a

Re: Cassandra 1.1.4 RPM required

Dear Aaron, Its required username and password which I have not. Can yo share direct link? Thanks & Regards *Adeel**Akbar* On 8/23/2012 3:02 PM, aaron morton wrote: See step 1 here http://wiki.apache.org/cassandra/GettingStarted Cheers - Aaron Morton Freelance Developer @aa

Data Modelling Suggestions

Hi, Need some help on a data modelling question. We're using Hector & Datastax Enterprise 2.1. I want to associate a list of items for a user. It should be sorted on the time added. And items can be updated (quantity of the item can be changed), and items can be deleted. I can model it like t

Re: Cassandra API Library.

I would vote for Hector :) On Thu, Aug 23, 2012 at 4:55 PM, Amit Handa wrote: > hi, > > kindly let me know which java client api is more matured, and easy to use > with all features(Super Columns, caching, pooling, etc) of Cassandra 1.X. > Right now i come to know that following client exists: >

Re: Cassandra API Library.

4) pelops (Thrift,Java) On 08/23/2012 01:28 PM, Baskar Sikkayan wrote: > I would vote for Hector :) > > On Thu, Aug 23, 2012 at 4:55 PM, Amit Handa wrote: > >> hi, >> >> kindly let me know which java client api is more matured, and easy to use >> with all features(Super Columns, caching, poolin

Re: Cassandra API Library.

We've used 'em all andŠ (IMHO) 1) I would avoid Thrift directly. 2) Hector is a sure bet. 3) Astyanax is the up and comer. 4) Kundera is good, but works like an ORM -- so not so good if your columns aren't defined ahead of time. -brian --- Brian O'Neill Lead Architect, Software Development H

Re: Cassandra API Library.

playOrm has a raw layer that if your columns are not defined ahead of time and SQL with no limitations on <, =, <=, etc. etc. as well as joins being added shortly BUT joins are for joining partitions so that your system can still scale to infinity. Also has an in-memory database as well for unit t

new type of join just discovered on cassandra

With playOrm we have been researching partitioning and joining partitions for OLTP applications which you typically partition per client anyways such that you can have infinite clients. Naturally, we have been looking at a lot of nested loop join, block nested loop join, sort merge join, and ha

Re: Cassandra API Library.

Thanks Dean… I hadn't played with that one. I wonder if that would better fit the bill for the Spring Data Cassandra module I'm hacking on. https://github.com/boneill42/spring-data-cassandra I'll poke around. -brian --- Brian O'Neill Lead Architect, Software Development Health Market Science

Re: Cassandra API Library.

FWIW.. I just threw this together... http://brianoneill.blogspot.com/2012/08/cassandra-apis-laundry-list.html Let me know if I missed any others. (I didn't have playorm on there) -brian On Thu, Aug 23, 2012 at 9:51 AM, Brian O'Neill wrote: > > Thanks Dean… I hadn't played with that one. I wond

Re: Cassandra API Library.

No problem, if you like SQL at all and don't mind adding a PARTITIONS clause, we have a raw ad-hoc layer(if you have properly added meta data which the ORM objects do for you but can be done manually) you get a query like this PARTITIONS p('account56') SELECT tr FROM Trades as tr WHERE tr. price >

Re: Cassandra API Library.

@Brian: You're missing PhpCassa (PHP library) With kind regards, Robin Verlangen *Software engineer* * * W http://www.robinverlangen.nl E ro...@us2.nl Disclaimer: The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may

Re: Cassandra API Library.

Ha… how could I forget? =) Adding it now. --- Brian O'Neill Lead Architect, Software Development Health Market Science The Science of Better Results 2700 Horizon Drive • King of Prussia, PA • 19406 M: 215.588.6024 • @boneill42 • healthmarketscience.com This

Re: Cassandra API Library.

+1 vote for Hector. That said, don't use SuperColumns unless you really really know what you're doing. On Thu, Aug 23, 2012 at 4:25 AM, Amit Handa wrote: > hi, > > kindly let me know which java client api is more matured, and easy to use > with all features(Super Columns, caching, pooling, etc)

Commit log periodic sync?

Hi all First off, let's introduce the setup. - 6 x C* 1.1.2 in active DC (DC1), another 6 in another (DC2) - keyspace's RF=3 in each DC - Hector as client. - client talks only to DC1 unless DC1 can't serve the request. In which case talks only to DC2 - commit log was periodically sync with the

RE: Expanding cluster to include a new DR datacenter

Thanks for the information! Answers my questions. From: Tyler Hobbs [mailto:ty...@datastax.com] Sent: Wednesday, August 22, 2012 7:10 PM To: user@cassandra.apache.org Subject: Re: Expanding cluster to include a new DR datacenter If you didn't see this particular section, you may find it useful:

Re: Data Modelling Suggestions

I think you need another CF as index. user_itemid -> timestamped column_name Otherwise you can't guess what's the timestamp to use in the column name. Anyway I would prefer storing the item-ids as column names in the main column family and having a second CF for the order-by-date query only with

Node forgets about most of its column families

Hi all, I was wondering if anybody had seen the following behaviour before and how we might detect it and keep the application running. We have a 6 node cluster. It seems that one of these nodes forgot about all but one of the application column families - possibly after a restart. Then, when

Re: Node forgets about most of its column families

On Thu, Aug 23, 2012 at 11:47 AM, Edward Sargisson wrote: > I was wondering if anybody had seen the following behaviour before and how > we might detect it and keep the application running. I don't know the answer to your problem, but anyone who does will want to know in what version of Cassandra

Re: Node forgets about most of its column families

Ah, yes, I forgot that bit thanks! 1.1.2 running on Centos. Running nodetool resetlocalschema then nodetool repair fixed the problem but not understanding what happened is a concern. Cheers, Edward On 12-08-23 12:40 PM, Rob Coli wrote: On Thu, Aug 23, 2012 at 11:47 AM, Edward Sargisson wr

commit log to disk with periodic mode

Hi all First off, please let me introduce the setup. - a balance ring of 6 x C* 1.1.2 in active DC (DC1), 6 in another (DC2); - keyspace's RF=3 in each DC; - client talks only to DC1 unless DC1 can't serve the request, in which case talks only to DC2; - commit log is being sync periodicall

Re: nodetool repair - when is it not needed ?

> Also when hints are replayed they are sent of as mutations, which may still > be dropped by the target if they are not serviced before rpc_timeout. Sending > nodes throttle their requests so it's unlikely but possible. My bad there. I thought the mutations were send one way. When node is se

Steps to Manually Resolve Stuck Schema!! CASSANDRA-4561

Just had a good conversation with rcoli in chat. Wanted to clarify the steps for resolving this issue and see if there are any pitfalls I am missing. Issue: I upgraded from 1.1.2 to 1.1.3 a while ago and today I realized I cannot make any schema changes since the fix in https://issues.apache.org/j

Re: Cassandra API Library.

Agreed, +1 for Hector, it's feature rich, has an active development community, and is pretty well documented to get you started. I agree with the comments on avoiding raw Thrift, I'm working on writing a more up to date client for Perl, and looking at the code generated from the Thrift compiler, i

Secondary index partially created

I have a three-node cluster running Cassandra 1.0.10. In this cluster is a keyspace with RF=3. I *updated* a column family via Astyanax to add a column definition with an index on that column. Then I ran a backfill to populate the column in every row. Then I tried to query the index from Java a

Dynamic Column Families in CQLSH v3

Hello All, Attempting to create what the Datastax 1.1 documentation calls a Dynamic Column Family (http://www.datastax.com/docs/1.1/ddl/column_family#dynamic-column-families) via CQLSH. This works in v2 of the shell: "create table data ( key varchar PRIMARY KEY) WITH comparator=LongType;" When