Cassandra 1.1.4 RPM required

2012-08-23 Thread Adeel Akbar
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

2012-08-23 Thread aaron morton
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 ?

2012-08-23 Thread aaron morton
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

Re: Deleting a row from a counter CF

2012-08-23 Thread aaron morton
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

Re: Cassandra 1.1.4 RPM required

2012-08-23 Thread aaron morton
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 adeel.ak...@panasiangroup.com wrote: Hi, I would like to install Apache Cassandra 1.1.4

Re: Cassandra 1.1.4 RPM required

2012-08-23 Thread Adeel Akbar
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

Data Modelling Suggestions

2012-08-23 Thread Roshni Rajagopal
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

Re: Cassandra API Library.

2012-08-23 Thread Baskar Sikkayan
I would vote for Hector :) On Thu, Aug 23, 2012 at 4:55 PM, Amit Handa amithand...@gmail.com 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

Re: Cassandra API Library.

2012-08-23 Thread Thomas Spengler
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 amithand...@gmail.com wrote: hi, kindly let me know which java client api is more matured, and easy to use with all features(Super Columns,

Re: Cassandra API Library.

2012-08-23 Thread Brian O'Neill
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

Re: Cassandra API Library.

2012-08-23 Thread Hiller, Dean
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

new type of join just discovered on cassandra

2012-08-23 Thread Hiller, Dean
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

Re: Cassandra API Library.

2012-08-23 Thread Brian O'Neill
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

Re: Cassandra API Library.

2012-08-23 Thread Brian O'Neill
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 boneil...@gmail.com wrote: Thanks Dean… I hadn't played with

Re: Cassandra API Library.

2012-08-23 Thread Hiller, Dean
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.

2012-08-23 Thread Robin Verlangen
@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

Re: Cassandra API Library.

2012-08-23 Thread Brian O'Neill
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 http://www.twitter.com/boneill42 • healthmarketscience.com This

Re: Cassandra API Library.

2012-08-23 Thread Aaron Turner
+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 amithand...@gmail.com wrote: hi, kindly let me know which java client api is more matured, and easy to use with all features(Super Columns,

RE: Expanding cluster to include a new DR datacenter

2012-08-23 Thread Bryce Godfrey
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

2012-08-23 Thread Guillermo Winkler
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

2012-08-23 Thread Edward Sargisson
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,

Re: Node forgets about most of its column families

2012-08-23 Thread Rob Coli
On Thu, Aug 23, 2012 at 11:47 AM, Edward Sargisson edward.sargis...@globalrelay.net 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

Re: Node forgets about most of its column families

2012-08-23 Thread Edward Sargisson
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

commit log to disk with periodic mode

2012-08-23 Thread rubbish me
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

Re: nodetool repair - when is it not needed ?

2012-08-23 Thread aaron morton
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

Steps to Manually Resolve Stuck Schema!! CASSANDRA-4561

2012-08-23 Thread Arya Goudarzi
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

Secondary index partially created

2012-08-23 Thread Richard Crowley
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

Dynamic Column Families in CQLSH v3

2012-08-23 Thread Erik Onnen
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